Thread: rounding down to positive when adding cells
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
billatmei billatmei is offline
external usenet poster
  
Posts: 1
Default rounding down to positive when adding cells
When I am adding two cells excel wants to round down to a positive number. I
have tried to use the accounting and the currency function with no success.
Example would be =C5 ($23.81) + E5 (23.82) I get $47.62 not $47.63
Reply With QuoteReply With Quote