Forum Discussion

treehawk's avatar
treehawk
Copper Contributor
Aug 02, 2022

Rounding with an IF formula

I have a formula for an invoice that appears not to be calculating properly due to a rounding issue. here is the original formula   =IFNA(IF(ISNUMBER(VALUE(LEFT([@GARMENT],2))),INDEX('STYLES CUSTOM...
Formulas and Functions
HansVogelaar's avatar
HansVogelaar
MVP
Aug 02, 2022

treehawk 

How about

 

=IFERROR(ROUND((IF(ISNUMBER(VALUE(LEFT([@GARMENT],2))),INDEX('STYLES CUSTOMER $$'!$E$3:$I$102,MATCH([@GARMENT],'STYLES CUSTOMER $$'!$A$3:$A$102,0),MATCH(IFS([@4XL]<>"",$L$18,[@3XL]<>"",$K$18,[@2XL]<>"",$J$18,OR([@XL]<>"",[@L]<>"",[@M]<>"",[@S]<>"",[@XS]<>"",[@YTH]<>""),"YTH-XL"),'STYLES CUSTOMER $$'!$E$2:$I$2,0)),VLOOKUP([@Column1],$S$18:$Y$47,7,0)),2),"")

treehawk's avatar
treehawk
Copper Contributor
Aug 02, 2022

HansVogelaar 

Thanks for trying. It didn't work. says theres a problem with the formula. Looks like there was  a couple things removed from the formula....was that intentional or is that by chance the error?

  • HansVogelaar's avatar
    HansVogelaar
    MVP
    Aug 03, 2022

    treehawk 

    Could you attach a sample workbook (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar? Thanks in advance.

    • treehawk's avatar
      treehawk
      Copper Contributor
      Aug 04, 2022
      I CAN'T SEE HOW TO ADD THE FILE HERE. is there a way to just email it to you so the file isn't plastered all over the internet? i need to send all the tabs as there are links from other formulas on different tabs. sorry if confusing.

Resources