K
klein
In excel 2003 in some cases where 2 equal amounts are subtracted the result
is not 0 How can this be avoided?
is not 0 How can this be avoided?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
S
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.
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.
M
Max
In excel 2003 in some cases where 2 equal amounts are subtracted
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
---
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
---
P
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
http://www.cpearson.com/excel/rounding.htm
it explains the floating point errors
--
Regards,
Peo Sjoblom