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