Changing a result ending in 32ths to 16ths i.e. 5 5/32 to 5 3/16

W

WGL

I have a cell where a number (variable) i.e. 10 5/16 which in another cell I
have to divide it in half. The problem is that the number will end with a 32
fraction like 5 5/32. I need that or any other result to end in 16 i.e. 5
3/16. I work in a carton corrugator and we don't use 32ths in measures. We
use 16ths and up. Please help!
 
N

Niek Otten

In recent versions of Excel:

Format>Cells>Fraction>as sixteenths

In older versions:

Format>Cells>Custom># ?/16

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel
 
W

WGL

Thanks Niek, but, that does not solve my problem.
I need the cell to finish in any other fraction but 32ths. In other words,
if the result finish in a 32th, I want to make a formula that sums a .03125
to that result.
 
S

Sandy Mann

Do the division, multiply the result by 16, round it to zero decimal places
and then divide the answer by 16. With the starting value in A1:

=ROUND(A1/2*16,0)/16

Sandy
 
S

Sandy Mann

Your welcome. It's exactly the same answer that JE McGrimpsey gave to
another poster asking the same question on 23rd August.

Regards

Sansy
 
Top