Fractions

  • Thread starter Thread starter Joe H
  • Start date Start date
J

Joe H

I have generated a table via formulas and need the result
display as a mixed fraction to the nearest 16th. Not a
problem so far. The problem arises in that I need the
fraction displayed as a reduced fraction. E.g. 2/16
needs to be 1/8, 4/16 needs to be 1/4, etc.

Now if the table were static I could go through and
change the fraction format... but the table is dynamic
and cell values are subject to change.

How can I accomplish my goal?

Oh, btw... PLEASE!
 
Joe,

You can round your values to the nearest 1/16 with:

=ROUND(A1*16,0)/16

Then format for fractions, at least up to two digits.
 
Ahh... That does it!

Thank you very, very much.

-----Original Message-----
Joe,

You can round your values to the nearest 1/16 with:

=ROUND(A1*16,0)/16

Then format for fractions, at least up to two digits.

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------




.
Click to expand...
 
Back
Top