Forum Discussion
math question
My formula gives me a value that is off by .01.
For example:
value of (bf12) = 1222.82(-)
value of bfe13) = 1020.00
but my formula gives me a value of 202.81 (s/b) 202.81
What is wrong with the math? formula?
2 Replies
Set the number format of all cells involved to Number with 15 decimal places. Are the numbers you see then exactly equal to 1222.82 and 1020.00?
- quite possibly nothing besides rounding for display purposes. I cannot follow the maths you are doing, but negative rounding rules are different from positive rounding rules.
