Thread: I get the wrong answer when subtracting currency.
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Midwest Midwest is offline
external usenet poster
  
Posts: 1
Default 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.
Reply With QuoteReply With Quote