Formulas don't work when looking at another formula result

[rplohocky]

Hello,
I haven't ever seen this issue before. I have a formula in cell J2 that looks at cell D2 to determine what J2 should display. The formula in J2 only works if I manually type in a number in cell D2, when I use a formula to acquire that number, cell J2 goes blank. I have tried 3 different formulas to see if its the formula and the format is set to General. Here are the formulas I used in D2:

=LEFT(A2, MATCH(FALSE, ISNUMBER(MID(A2, ROW(INDIRECT("1:"&LEN(A2)+1)), 1) *1), 0) -1)

[I]=LEFT(A1,(FIND(" ",A1,1)-1))[/I]

=LEFT(B2,2)

These formulas are supposed to extract the numbers before the text ( 12 Count--CAB6 118), in this example it would be 12.

Here is the formula I'm using in cell J2:

=IF(AND(D2>11,D2<145),25,IF(D2=288,30,""))

What am I missing?

 

[Anthony47]

Your formulas will return a String in D2, and the string "12" is different than the value 12
Try this, in J2:

=IF(AND(--D2>11,--D2<145),25,IF(--D2=288,30,""))

 

[robertdseals]

Try using "substitute" in the formula.

 

[Fluff]

You can add 0 to the formula in D2 to convert it from text into a number like

=LEFT(A1,(FIND(" ",A1,1)-1))+0

 

[rplohocky]

You can add 0 to the formula in D2 to convert it from text into a number like

=LEFT(A1,(FIND(" ",A1,1)-1))+0

Although Anthony47 had an option that worked as well, I thought Fluff was the one I am used to and decided to use. Thank you both for your help!

 

[Fluff]

Glad we could help & thanks for the feedback.