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