Thread: HELP!
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Elkar Elkar is offline
external usenet poster
 
Posts: 964
Default HELP!

When you say you "rounded" these numbers, do you mean you changed the Cell
Format to display two decimal places? If so, then the numbers aren't really
rounded, only what is displayed has been rounded. The cell contents are
still the original numbers.

To actually round the numbers, use the ROUND() function. So, let's say your
numbers are in A1 and A2. In A3, use this formula:

=ROUND(A1,2)-ROUND(A2,2)

HTH,
Elkar


"Vanessa" wrote:

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...