fractions

N

NILELATOR

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
 
R

Ron Rosenfeld

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
Click to expand...

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
 
J

joeu2004

NILELATOR said:
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.
Click to expand...

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

Teethless mama

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

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

NILELATOR

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

Ron Rosenfeld

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

Glad to help. Thanks for the feedback.

thank you, just how do you keep coming up with these??
Click to expand...

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
 
Top