Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
incorrect subtraction
In excel 2003 in some cases where 2 equal amounts are subtracted the result is not 0 How can this be avoided? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 --- |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Subtraction | Excel Worksheet Functions | |||
Subtraction Chart | Excel Discussion (Misc queries) | |||
Cell subtraction | New Users to Excel | |||
Subtraction question | Excel Discussion (Misc queries) | |||
Subtraction Question | Excel Discussion (Misc queries) |