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?

0

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

#??/??

0

| improve this answer | |
  • 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

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.