Forum Discussion
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...
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?
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.
- 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.