fractions
 

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

fractions
 

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

fractions
 

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

fractions
 

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

fractions
 

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

fractions
 

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