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%