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

  • Thread starter Thread starter Bobby
  • Start date Start date
B

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
 
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
 
Thanks it worked.
Never ran into this before, have to read on what it does.
Thanks again
Bob
 
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
 
Back
Top