add rounded numbers using the rounded value
in [General]
|
Prev: DOS..BAT file problem from VB
Next: Need data result in last cell of array that contains blank cells
From: Ruth on 8 Feb 2010 14:46 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.
From: Jim Thomlinson on 8 Feb 2010 14:51 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.
From: Joe User on 8 Feb 2010 14:59
"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. |