Desperate need help today converting ad size to decimal size

[petice]

=IF(LEN(M39),IF(ISNUMBER(LEFT(M39,1)+0),IF(ISNUMBER(LEFT(M39,4)+0),1/MID(M39,3,2),1/MID(M39,3,1)),1),"")

For print advertising sales. We have various sizes of ads that I need to convert to a decimal size. The ad sizes are a combination of fractions and text such as

1/4S-COL meaning this is a 1/4 square ad that is color. The formula works on all fractions except
1/12S-COL
1/16S-COL
1/24S-COL
1/48S-COL
can anybody tell me why it isn't working on any of the small fractions?

 

[Mark W.]

Re: Desperate need help today converting ad size to decimal

Book1
	A	B	C	D	E	F	G	H
1	1/4S-COL	0.25
2	1/12S-COL	0.083333
3	1/16S-COL	0.0625
4	1/24S-COL	0.041667
5	1/48S-COL	0.020833
6
7
Sheet6

 

[Aladin Akyurek]

Re: Desperate need help today converting ad size to decimal

=IF(LEN(M39),IF(ISNUMBER(LEFT(M39,1)+0),IF(ISNUMBER(LEFT(M39,4)+0),1/MID(M39,3,2),1/MID(M39,3,1)),1),"")

For print advertising sales. We have various sizes of ads that I need to convert to a decimal size. The ad sizes are a combination of fractions and text such as

1/4S-COL meaning this is a 1/4 square ad that is color. The formula works on all fractions except
1/12S-COL
1/16S-COL
1/24S-COL
1/48S-COL
can anybody tell me why it isn't working on any of the small fractions?

I get...

{0.25;
0.0833333333333333;
0.0625;
0.0416666666666667;
0.0208333333333333}