Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
wrongly added or subtracted decimals
Suddenly I have started problem with simple calculations (addition and
subtraction). I have starting values in the first column wtih maximum two significant figures. I then perform a few operations (addition and subtraction) using numbers from a previous operation(s) for a following operation. For instance, 1) the original value, 2.875, 2) 100-2.875, then 3) the answer from 2) - 95.15. The final answers should be exactly 1.075, but when I extend a number of decimal places, the value has a small value either added or subracted from the supposed to be answers. For example, instead of 1.075, it shows 1.0750000000001200. I have tried to correct this error without any success. Does anyone have any idea how to correct this problem? none |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I change the number format for decimals from , to .? | Setting up and Configuration of Excel | |||
How do I calculate without decimals in excel? | Excel Worksheet Functions | |||
named range, data validation: list non-selected items, and new added items | Excel Discussion (Misc queries) | |||
Links pull wrong line when rows are added | Excel Discussion (Misc queries) | |||
Decimals separation by . or , | Excel Discussion (Misc queries) |