Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I get the wrong answer when subtracting currency.
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I get the wrong answer when subtracting currency.
Hi,
Are the amounts in B1, B2 and B3 calculated from something? If so, there might be more decimal places than you have displayed. Increase the number of decimal places and see if it is a rounding problem. Dave "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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I get the wrong answer when subtracting currency.
I get 4.4400. Whenever weird stuff happens, I try things like =trim() or
something along those lines. Maybe you have a little speck of some other type of data in one of those cells. I suppose you could check the rounding of B1, B2, and B3; sometimes what is 'displayed' in a cell is not really what is in the cell. Regards, Ryan--- -- RyGuy "Dave Curtis" wrote: Hi, Are the amounts in B1, B2 and B3 calculated from something? If so, there might be more decimal places than you have displayed. Increase the number of decimal places and see if it is a rounding problem. Dave "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. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I get the wrong answer when subtracting currency.
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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) |