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