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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 
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.
 
Back
Top