X
Xhawk57
how would you convert this formula for the nearest 1/8%
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
X
Xhawk57
sorry, the formula is =round(A1*8,0)/8
I am looking for a way to enter a % as A1 (ie. 3.485% and have it return
3.50%)
I am looking for a way to enter a % as A1 (ie. 3.485% and have it return
3.50%)
M
mphell0
Use MROUND
=MROUND(A1,0.125)
You will have to load the analysis toolpak to get the MROUND Function.
=MROUND(A1,0.125)
You will have to load the analysis toolpak to get the MROUND Function.
R
Ron Rosenfeld
sorry, the formula is =round(A1*8,0)/8
I am looking for a way to enter a % as A1 (ie. 3.485% and have it return
3.50%)
=ROUND(A1/(1/8)%,0)*(1/8)%
or
=ROUND(A1*800,0)/800
--ron
X
Xhawk57
Changing the 8 to 800 did the trick, thank you.
Ron Rosenfeld said:=ROUND(A1/(1/8)%,0)*(1/8)%
or
=ROUND(A1*800,0)/800
--ron
R
Ron Rosenfeld
Changing the 8 to 800 did the trick, thank you.
Both work. Just different ways of expressing the same number.
--ron
R
Ron Rosenfeld
Changing the 8 to 800 did the trick, thank you.
Both work. Just different ways of expressing the same number.
Thanks for the feedback.
--ron
D
daddylonglegs
....or another way
=ROUND(A1*8,2)/8
=ROUND(A1*8,2)/8