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

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

"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.

If you are interested only in multiples of 1/8, I would be tempted to do:

=CHOOSE(1 + ROUND((A1-INT(A1))/0.125, 0),
"", "1/8", "1/4", "3/8", "1/2", "5/8", "3/4", "7/8", "")

You might want to select Format Cells Alignment Horizontal Right.

First, Format cells Fraction Select Up to one digit (1/4)

then enter 2/4 press enter it will automatic convert to 1/2


"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

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

On Sat, 2 Dec 2006 11:06:00 -0800, NILELATOR
wrote:

Ron, right again works just right. I changed it to
=if(g170,round(g17/f/17*4,0)/4,"") and it gives me quarters.

Glad to help. Thanks for the feedback.


thank you, just how do you keep coming up with these??

Sometimes from reading here on this NG. Sometimes I don't know; but I've been
fooling with computers for 45 years or so. So some things have rubbed off.
--ron