incorrect subtraction

[klein]

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

 

[Sheeloo]

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.

 

[Max]

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
---

 

[Peo Sjoblom]

Use rounding or tools>options>calculation and precision as displayed


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

it explains the floating point errors



--


Regards,


Peo Sjoblom