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

[Dave O]

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

 

[Frank Kabel]

Hi
see:
http://www.xldynamic.com/source/xld.Rounding.html

 

[Don Guillett]

does this help
=FLOOR(C1,0.125)

 

[Bob Phillips]

Don, works in this instance, but always rounds down, not rounds. If he
really wants round he needs

=ROUND(C1*8,0)/8

 

[Don Guillett]

Bob,
That's why I didn't send that solution. It would have rounded UP in this
case.

 

[Bob Phillips]

Don,

By my calculations, apply =ROUND(C1*8,0)/8 to 99.897 and you get 99.875?

 

[Don Guillett]

So you do. I was using 987 instead.....

 

[Bob Phillips]

Thought that might be the case (as I also did in my first test <vbg>).