incorrect subtraction
 

In excel 2003 in some cases where 2 equal amounts are subtracted the result
is not 0 How can this be avoided?

incorrect subtraction
 

That happens when you have nos set to display with no decimal points but the
underlying number has decimal part...

You can check the box against "Precision as displayed" under
Tools|Options|Calculation|Workbook Options Group

Do note that this has wider impact and may hurt you elsewhere.
--
Always provide your feedback so that others know whether the solution worked
or problem still persists ...


"klein" wrote:


In excel 2003 in some cases where 2 equal amounts are subtracted the result
is not 0 How can this be avoided?

incorrect subtraction
 

In excel 2003 in some cases where 2 equal amounts are subtracted
the result is not 0 How can this be avoided?

Probably you could try using ROUND,
eg something like this:
=ROUND(A1-SUM(B1:C1),0)
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:19,000 Files:362 Subscribers:62
xdemechanik
---

incorrect subtraction
 

Use rounding or toolsoptionscalculation and precision as displayed


http://www.cpearson.com/excel/rounding.htm

it explains the floating point errors



--


Regards,


Peo Sjoblom

"klein" wrote in message
...

In excel 2003 in some cases where 2 equal amounts are subtracted the
result
is not 0 How can this be avoided?