Cell not adding correctly - Problem.xls (0/1)

[Bobby]

Cell I4 is a penney off, and I can't understand why.
I know it's only a penney but I have other cells in the whole
spreadsheet that is also off.

Thanks Bobby

 

[Peo Sjoblom]

Use tools>options>calculations and precision as displayed
or use the round function. You probably suffer from underlying values
being not the same as displayed

 

[Bobby]

Thanks it worked.
Never ran into this before, have to read on what it does.
Thanks again
Bob

 

[Peo Sjoblom]

If you format for currency and 2 decimals and a value like

$1.12

might be

1.12345

now if you have a lot of thos values eventually there will be a discrepancy.
I personally prefer rounding to precision as displayed