View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Joe User[_2_] Joe User[_2_] is offline
external usenet poster
 
Posts: 905
Default add rounded numbers using the rounded value

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