Home |
Search |
Today's Posts |
#4
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
On Thu, 22 Jan 2009 08:18:14 -0800, Midwest
wrote: When calculating a net dollar amount, excell displays the wrong answer. Example: B1= $10.00, B2 = $4.34, B3 = $1.22, B4 = formula =B1-B2-B3 The ansxwer should be $4.44, excell displays $4.45. If B1:B3 truly contained the values you posted, Excel would display 4.44 So B1:B3 do NOT contain the values you posted. The cells may display the values you posted, but that is merely a matter of cell formatting and formatting generally does not affect the underlying value. How are the values in B1:B3 obtained? What shows in the formula bar when you click on B1, B2 and B3? --ron |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
vlookup returns wrong answer (off by one row) | Excel Worksheet Functions | |||
The wrong answer | Excel Discussion (Misc queries) | |||
Formula returning wrong answer | Excel Worksheet Functions | |||
Wrong Answer | Excel Discussion (Misc queries) | |||
Array gives wrong answer | Excel Discussion (Misc queries) |