MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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