why do numbers not add correctly in excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

When adding currency in an excel worksheet, the sums are not always correct .
They may be a penny higher or a penny lower than the correct amount. Some of
the amounts that are being added are obtained by using a percentage of
another amount.
 
It's because Excel holds a far greater precision than that displayed by the
format. You may see 1.50+1.50 and expect 3.00, but Excel may be holding a
true value of 1.5049+1.5049=3.098 or formatted to two decimals 3.01

To overcome this you can use the ROUND function on all your calculations, or
go to Tools>Options>Calculation>Precision as displayed

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
 
or even 3.0098, but you hopefully get my drift!

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
 
Back
Top