Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi friends,
I have a simple question about calculation accuracy (excel 2002) that drives me crazy: just enter in A1 value 388 B1 value 372.58 C1 value 15.42 and then in a new cell the formula = A1 - B1 - C1 One would expect 0 as result, instead gets 1.59872E-14 Do you know why this occur? There is a way to force the result to 0 anyway? Thanks a lot for any help or suggestion on this. Ciao Flavio |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I improve Accuracy of trendlines? | Charts and Charting in Excel | |||
Forecasting Accuracy | Charts and Charting in Excel | |||
Data Accuracy | Excel Discussion (Misc queries) | |||
CHecking accuracy | Excel Discussion (Misc queries) | |||
Accuracy Studies | Excel Discussion (Misc queries) |