what is (rounded to the nearest one-tousandth of 1%, with five te.

[Kristal]

I have this rate 2.1349%. I have to determine the arithmetic average rounded
to the nearest one-thousandth of 1%, with five ten-thousandths of 1% being
rounded upwards) Please explain what this means.

 

[Frank Kabel]

Hi
try
=ROUND(A1,5)
if A1 stores your percentage

 

[Fred Smith]

Could this be a homework assignment?

I assume the rate of 2.1349% is already the arithmetic average. Now you need
to round it to the nearest 1/1000 of a percent. 0.1 is a tenth of a percent,
0.01 is a hundredth of a percent, and 0.001 is a thousandth of a percent. So
you want three decimal places. You need to change 2.1349% to 2.135%. If you
had 2.1344%, it would change to 2.134%. If you have 2.1345%, it gets changed
to 2.135% ("five ten-thousandths of 1% being rounded upwards")

Frank's formula will do what you want.

 

[Myrna Larson]

Hi, Fred:

If the 2.1349% he's talking about is in fact a decimal, 0.021349, formatted as
percent, then you need to round to 4 decimal places, no? If so, then
=ROUND(A1,4) should do it.