how would you convert this formula for the nearest 1/8%

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%)

"Xhawk57" wrote:

how would you convert this formula for the nearest 1/8%

Use MROUND

=MROUND(A1,0.125)

You will have to load the analysis toolpak to get the MROUND Function.


--
mphell0
------------------------------------------------------------------------
mphell0's Profile: http://www.excelforum.com/member.php...o&userid=30153
View this thread: http://www.excelforum.com/showthread...hreadid=513298

On Thu, 16 Feb 2006 10:00:26 -0800, "Xhawk57"
wrote:

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%)

"Xhawk57" wrote:

how would you convert this formula for the nearest 1/8%


=ROUND(A1/(1/8)%,0)*(1/8)%

or

=ROUND(A1*800,0)/800


--ron

Changing the 8 to 800 did the trick, thank you.

"Ron Rosenfeld" wrote:

On Thu, 16 Feb 2006 10:00:26 -0800, "Xhawk57"
wrote:

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%)

"Xhawk57" wrote:

how would you convert this formula for the nearest 1/8%


=ROUND(A1/(1/8)%,0)*(1/8)%

or

=ROUND(A1*800,0)/800


--ron

On Thu, 16 Feb 2006 12:58:28 -0800, "Xhawk57"
wrote:

Changing the 8 to 800 did the trick, thank you.


Both work. Just different ways of expressing the same number.

--ron

On Thu, 16 Feb 2006 12:58:28 -0800, "Xhawk57"
wrote:

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

...or another way

=ROUND(A1*8,2)/8


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=513298