Reduction Fractions to LCD
this works perfectly! thank you so much.
"Ron Rosenfeld" wrote:
On Wed, 7 Feb 2007 13:16:20 -0800, Chad wrote:
I've got a formula that I want to read in a fraction (i.e. 14 1/2 instead of
14.5). I've formatted the cells to read as a fraction in 1/8 increments.
The problem is I sometimes get things like 14 4/8, instead of the LCD and
being reduced to 14 1/2. Any suggestions on how to get around this and
display the lowest common denominator? Thanks.
-Chad
If you want to ROUND the cells to the nearest 1/8, and then display it as the
reduced fraction, then:
=ROUND(A1*8,0)/8
or
=ROUND(your_formula*8,0)/8
and format as fraction with up to one digit
# ?/?
--ron
|