math question

Occasional Visitor

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


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?