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