View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jim Thomlinson Jim Thomlinson is offline
external usenet poster
 
Posts: 5,939
Default add rounded numbers using the rounded value

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.