MROUND w/ Analysis ToolPak
Posted by Jim on August 08, 2001 12:28 PM
In past formulas i've used the mround function in the
Analysis ToolPak, and set the number as "fraction" and
"Type" as eighths. This would return the answer as eigths
or sxteenths. This my problem today. cell C2 formula :
=Sqrt(C11^2+H9^2)/12*C11 in this case the answer is
11 4/16, Cell O14 = Cell C2, so the answer in Cell
O14 is 11 4/16, i've tried various method w/ the mround
with no results i.e. =mround(C2,1/16).What i ultimately
is a formula that would convert 4/16 to 1/4 or 4/8
to 1/2.Any ideas would be appreciated. Also the sheets
protected so the format cells is not an option.
Thanks Jim
Posted by Barrie Davidson on August 08, 2001 12:50 PM
Jim, you could try (this converts to 1/4's).
=TEXT(C2,"#")&" "&TEXT(C2-INT(C2),"#/4")
One note, the formula result will be text not a number. Does this matter to you?
Barrie
Posted by Jim on August 08, 2001 12:55 PM
Hi Barrie,
Unfortunately it needs to be in number format
Jim
Posted by Barrie Davidson on August 08, 2001 1:04 PM
Jim, I believe you can only keep it as a number (and have it formatted the way you want) if you format the cells. I could be wrong, but I'm not aware of any other way to do it.
Barrie :(
Posted by brent on August 08, 2001 2:31 PM
I expect this is dirty pool, besides cumbersome. Can you link the the protected sheet's cell to an unprotected sheet and set in your function and fractional format? On another sheet(Sheet2) =MROUND(Sheet1!C2,1/16)
