If the cells values listed (i.e. C17 and H17) are functions of other numbers
(i.e. C17 is actually "=SUM(C15:C16)") and the formatting of these cell
display a numerical value of only 2 decimal places the function will still
use the unrounded numbers.

Example
C15 = "4.862"
C16 = "100.00"
C17 = "SUM(C15:C16)"

If the above was True the Sun of the fields is 104.862
However if the formatting for C17 was set for only 2 decimal places if will
display 104.86 as you have provided below.
Now if you use the C17 Cell in an equation as you are it will still use the
104.862, there for throwing the math off to not use the exact value.




"justlearnin" wrote:

I have a formula in my spreadsheet that check a balance.
=IF(SUM(C17:H17)=I17,"OK", "ERR")
Here are the values that are in each cell
C17 104.86
D17 58.32
E18 -209.11
F19 0
G19 0
H19 52.78
I17 6.85
I get "ERR" because when I evaluate K17 where the formula is it gives me
6.84999999999999. I have tried everything I can think of to fix this with no
luck. I even tried a new spreadsheet with the values and fromulas with no
luck (I did not use copy and paste to get the info to the new sheet, typed it
all in)
Please help