Ron, right again works just right. I changed it to
=if(g170,round(g17/f/17*4,0)/4,"") and it gives me quarters.
thank you, just how do you keep coming up with these??

"Ron Rosenfeld" wrote:

On Fri, 1 Dec 2006 17:02:00 -0800, NILELATOR
wrote:

I have a spreedsheet that i need to get answers in the form of fractions in
1/8's, 1/4's, and 1/2's depending on which one. I all I can find is one or
the other not all is there any way to get the answer the way I want ie....
instead of 2/4 I need 1/2, and 1/4 instead of 2/8.

help please

You will need to round your result to the nearest 1/8, and then format as a
fraction with up to one digit # ?/?

For example:

=ROUND(your_formula*8,0)/8


--ron