Fractions

[Jordon]

Can anyone suggest how to arrive at the number 19
for the difference between 24/32 and 5/32 (24 minus
5)?

For what it's worth, I need to determine the cost
in dollars and cents per 32nd of an inch of tire
tread life using 5/32 as an "end of life" figure.

TIA,

Jordon

 

[Jason Morin]

Try:

=LEFT(TEXT(A1-B1,"00/32"),FIND("/",TEXT(A1-B1,"00/32"))-1)
*1

where A1 holds =24/32 and B1 holds =5/32.

HTH
Jason
Atlanta, GA

 

[Jordon]

Excellent Jason. Thank you very much.

Jordon

=LEFT(TEXT(A1-B1,"00/32"),FIND("/",TEXT(A1-B1,"00/32"))-1)
*1

where A1 holds =24/32 and B1 holds =5/32.

 

[Sandy Mann]

Jordon,

If you want the answer as a number then

=(A1-B1)*32 will return 19 in your example

HTH

Sandy