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

Be sure you round the values using the ROUND() function rather than by just
formatting the cells.
--
Gary''s Student
gsnu200702


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

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

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?

I suspect the values "rounded to 2 decimal places" are merely
__displayed__ to 2 decimal places. Three solutions that might work for
you....

1. Explicitly round each value. For example, instead of
=AVERAGE(A1:A10), write =ROUND(AVERAGE(A1:A10), 2).

2. Alternatively, where you sum the two values, instead of =A1+A2,
write =ROUND(A1,2) + ROUND(A2,2).

3. Use Tools - Options - Calculation - Precision As Displayed.

Solution #2 is useful when you want to retain the exact values in A1
and A2, even if their rounded value is displayed.

I do not recommend solution #3 because it can have unexpected
consequences, since it applies to all calculations in the workbook.

There's a slight difference between this equation:
=ROUND(80,094.75540-78,185.09160,2)
and this one
=ROUND(80,094.75540,2)-ROUND(78,185.09160,2)

The first yields 1,909.66; the second give 1,909.67. Rounding protocol
will be determined by where these numbers come from, what they
represent, etc.

HTH,
Dave O

IT WORKED, thanks all.

"Elkar" wrote:

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