I want to add the value of 2 numbers that are rounded and want to use the
value at 2 decimal points, not the whole number.

There are 2 forms of rounding. One is to format the number to show only a
certain number of deciaml points. In this case then the number is not altered
and all of the decimals are still their even though they are not displayed.
The Other optin that I think you are looking for is the Round Function. This
alters the number to round the number to the sepcified number of decimals.
Everything after that point is removed.

=Round(A1, 2) rounds the value in A1 to 2 decimal points.
--
HTH...

Jim Thomlinson


"Ruth" wrote:

I want to add the value of 2 numbers that are rounded and want to use the
value at 2 decimal points, not the whole number.

"Ruth" wrote:
I want to add the value of 2 numbers that are rounded
and want to use the value at 2 decimal points, not the
whole number.

It is unclear what you mean exactly. It is always wise to include specific
examples and other details in your inquiry.

If you mean, for example, that you have numbers in A1 and A2 which appear
rounded to 2 decimal places due to formatting, but which might actually have
more decimal places in actual value (in fact, that is usually the case), then
you might want:

=round(A1,2) + round(A2,2)

For a larger range of numbers, you might want to use the following:

=sumproduct(round(A1:A2,2))

The use of SUMPRODUCT is a trick to avoid having to enter an array formula,
which would be the case for SUM.

However, you might want to consider rounding A1 and A2 explicitly instead of
relying on formatting. That obviates the need to round them everywhere you
reference them in formulas.