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.

@falco19777 

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?