![]() ![]() So rather than round G3 and E3 in the formula above, I would argue that the formulas in G3 and E3 should be rounded explicitly to the cent in the first place. (It also eliminates arithmetic anomalies that creep into Excel/computer calculations and cause many "inexplicable" results.) ![]() This minimizes differences that might arise when comparing manualĪnd computer arithmetic results. Second, I am a strong advocate of roundingĮach dollar-and-cents calculation to the cent (with some notable exceptions), especially when the calculation represents a line item - something that might appear on a statement. =IFERROR(IF(ISBLANK(F3)," ",((ROUND(G3,2))-(ROUND(E3,2)))/(ROUND(E3,2)))," ")įirst, when dealing with any government (especially the US feds), it is important to follow whatever procedure they specify, if any.įor example, if you look at any US tax form that involves division or multiplication by fractions, it is not uncommon for the instructions to state that each line should be rounded to the cent (or to the dollar in some cases). Could one of you please explain why they should not use the round function more than once in a formula or tell me that I am wrong and it is acceptable? We would really appreciate this.
0 Comments
Leave a Reply. |