I get the wrong answer when subtracting currency.

  • Thread starter Thread starter Midwest
  • Start date Start date
M

Midwest

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.
 
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
 
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---
 
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.
Click to expand...

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
 
Back
Top