reducing fractions and showing 8/16's as 1/2 etc.
Posted by Jim on January 28, 2001 1:08 PM
I need to reduce my fractions to the nearest 16th but
show 4/16's as 1/4 and 8/16's as 1/2 etc. I've tried
custom number format ( #??/16 ) and Mr Excels tip of
week both still show 4/16's etc. My formula that gives
the result as a fraction is:
=Sum((IF(C2<C1,SQRT(C9^2)+SQRT(K14^2)))-M14
Any help or ideas would be appreciated
Thanks, Jim
Posted by Celia on January 28, 2001 1:40 PM
Format as #???/??? and change your formula to :-
=MROUND(yourformula,1/16)
Celia
