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?

2 Answers 2

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, 2019 at 20:31
  • @fred in that case use: # ??/?? - i.stack.imgur.com/9qW8c.png
    – user0
    Jul 22, 2019 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, 2019 at 20:18
  • well, you can't have both its either # ??/?? or #??/?? or # ??/32or #??/32
    – user0
    Jul 23, 2019 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 and acknowledge that you have read and understand our privacy policy and code of conduct.

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