This works too:
=ROUND(your_formula/16,0)*16
<g
Biff
"Ron Rosenfeld" wrote in message
...
On Thu, 16 Jun 2005 13:33:08 -0700, "Derek"
wrote:
I have data in millimeters and converting in aanother cell to inch
fractions
in 16ths format (result must be in 16 increments). How do I reduce to
LCD - I
do not want to see 8/16 but do want 1/2.
Round your result to the nearest 16th, and format the cell as a fraction
with
up to two digits.
To round:
=ROUND(your_formula*16,0)/16
Format code:
# ??/??
--ron
|