Rounding to a fraction?

  • Thread starter Thread starter RMD
  • Start date Start date
R

RMD

I'm trying to use the TEXT function to convert a number to a fraction and
round to the nearest 1/16. Example 0.191 to 3/16. Can someone tell me how to
do this. Is there a function that rounds to a specific fraction?

Thanks
Rick
 
One way to round to 1/16:

=ROUND(A1*16,0)/16

Format the cell with Format/Cell/Number/Custom # 0/16
 
One way

=TEXT(ROUND(G1*16,)/16,"# ??/16")

the above is a text value but I assumed you wanted
just to display the value as opposed to making calculations

If you want a numeric value

=ROUND(G1*16,)/16

and format as fraction
 
The problem is that sometimes the result is a 1/8ths or in 1/4ers etc., I
just need it rounded to the nearest 1/16, but display it in whatever
fraction it ends up being.
 
Hi RMD!

That is what JE's formatting does:

A1:
=24/16
B1:
=ROUND(A1*16,0)/16
Format # 0/16
Returns: 1 8/16

If you want the result simplified:

Format # 0/0
Returns 1 1/2

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
...
...
A1:
=24/16
B1:
=ROUND(A1*16,0)/16
Format # 0/16
Returns: 1 8/16

If you want the result simplified:

Format # 0/0
Returns 1 1/2
Click to expand...
...

OK, but if A1 contains =17/16, and were formatted as # 0/0 , it'd display as

1 0/1

which is wrong and ugly. Better to format as 0 #/## .
 
Back
Top