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?
This worked great for me when I had the same question:
Conceptually, round to the closest 1/32 (or whatever fraction you want) and then display format to the simplified fraction.
I used this formula:
With this display format: