or even 3.0098, but you hopefully get my drift!

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS


"Nick Hodge" wrote in message
...
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 ToolsOptionsCalculationPrecision as displayed

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS


"kflag" wrote in message
...
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.