Thread: HELP!
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Vanessa Vanessa is offline
external usenet poster
 
Posts: 32
Default HELP!

I am subtracting two values that I rounded to 2 decimal places, yet the
answer depicts the actual numbers, not the rounded numbers. Is there a way to
use the actual rounded numbers? Since the answer is 1 penny off.

The actual numbers a 80,094.75540 - 78,185.09160 = 1,909.66380
When rounded to 2 decimal places they a80,094.76 - 78,185.09
....and this should equal to 1,909.67, yet it shows 1,909.66

Heeeeeeeelp...