Fractions

  • Thread starter Thread starter Jordon
  • Start date Start date
J

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
 
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,

If you want the answer as a number then

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

HTH

Sandy
 
Back
Top