Is there a way to round to the nearest fraction (not 10th, 100th,.

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

Guest

I'm trying to round a value to the nearest 1/8 in decimal for ie:
99.897-->99.875, is there anyway to do this without creating my own function
with logical statements?
Thanks
 
Don, works in this instance, but always rounds down, not rounds. If he
really wants round he needs

=ROUND(C1*8,0)/8
 
Bob,
That's why I didn't send that solution. It would have rounded UP in this
case.
 
Don,

By my calculations, apply =ROUND(C1*8,0)/8 to 99.897 and you get 99.875?
 
Thought that might be the case (as I also did in my first test <vbg>).
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

fractions 3
calc # of d, m, y, then round to nearest fraction 2
Round up 10th of Decimal 1
Is there a formula to round a number to the nearest .09? 5
IF and Round 5
Round a number to the Nearest .25 2
A rounding function 4
rounding figures to nearest thousand 3

Back
Top