0

In Google Sheets I would like to express any decimal number to the nearest 32nd of an inch. If I type 1.537 I want the result to be 1 17/32, but if I type 1.5 I need it to be expressed as 1 1/2 not 1 16/32 nor 48/32, is there a way to achieve this?

1

With # ??/32 you are locking it only to "/32" fractions. For variable fractions you need to use:

#??/??

0

4
  • right I didn't specify but I also need them to output as mixed numbers not improper fractions. If I have 1.5 I like it to show as 1 1/2 not 3/2. – fred Jul 22 '19 at 20:31
  • @fred in that case use: # ??/?? - i.stack.imgur.com/9qW8c.png – user0 Jul 22 '19 at 20:41
  • This doesn't round to the nearest 32nd as intended, I edited my question to clarify what I mean. – fred Jul 23 '19 at 20:18
  • well, you can't have both its either # ??/?? or #??/?? or # ??/32or #??/32 – user0 Jul 23 '19 at 20:19
1

This worked great for me when I had the same question:
http://dmcritchie.mvps.org/excel/fractex1.htm

Conceptually, round to the closest 1/32 (or whatever fraction you want) and then display format to the simplified fraction.

I used this formula:

=ROUND(A1*32,0)/32 

With this display format: # ??/??

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.