Excel formula help

From Gemini A.I.

Step 1: Force the math to round to the nearest 1/16th
Instead of just typing your formula or referencing a cell, wrap your calculation in the MROUND function. This forces Excel to lock the decimal to a perfect 1/16th increment before it even tries to display it as a fraction.

If your decimal is in cell A1, use this formula:
=MROUND(A1, 1/16)

(Note: If you are doing math inside the cell, just replace A1 with your formula, like =MROUND(A1*B2, 1/16))

Step 2: Apply the "Up to two digits" format
Because you've mathematically forced the number to be an exact 16th, you can now safely use Excel's default fraction reducer without it accidentally spitting out a 1/5 or a 1/7.

1.Select the cells with your new formula.
2.Hit Ctrl + 1 (or right-click and select Format Cells).
3.Go to the Number tab and select Fraction.
4.Choose Up to two digits (21/25).

Hope it works

This will give you a text string to the closest 1/32, 1/16, 1/8, 1/4, or 1/2 for a number, in this case, in cell F60. Just copy the whole thing and paste it in. You can do a search and replace to replace F60 with whatever cell you want to point it at. For a fraction less than 1 it will give you 0 1/32 etc. If you want to eliminate 32nds I can help you with that as well.

=IF(ISODD(ROUND((F60-TRUNC(F60))*32,0)),CONCAT(TRUNC(F60)," ",ROUND((F60-TRUNC(F60))*32,0),"/32"),IF(ISODD(ROUND((F60-TRUNC(F60))*16,0)),CONCAT(TRUNC(F60)," ",ROUND((F60-TRUNC(F60))*16,0),"/16"),IF(ISODD(ROUND((F60-TRUNC(F60))*8,0)),CONCAT(TRUNC(F60)," ",ROUND((F60-TRUNC(F60))*8,0),"/8"),IF(ISODD(ROUND((F60-TRUNC(F60))*4,0)),CONCAT(TRUNC(F60)," ",ROUND((F60-TRUNC(F60))*4,0),"/4"),CONCAT(TRUNC(F60)," ",ROUND((F60-TRUNC(F60))*2,0),"/2")))))