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?