isnumber find formula HELP please

I am trying to create a multiple if statement formula that will look in a string of text in cell C62 if it finds the word "FHA" and the number 15 it will reference a particluar cell if it only find the word "FHA" it references another particular cell etc...

=IF(ISNUMBER(FIND("FHA",C62)),'Pricing and Set up info'!B27,IF(C26>=97.01%,'Pricing and Set up info'!$B20,IF(C26>=95.01%,'Pricing and Set up info'!$B21,IF(C26>=90.01%,'Pricing and Set up info'!$B22,IF(C26>=85.01%,'Pricing and Set up info'!$B23,IF(C26>=80.01%,'Pricing and Set up info'!$B24,0))))))*Plan1_LoanAmt/12

This is what i have so far and it works great except I need to add the function that if it finds fha and 15 in cell c62 it will reference another cell

I have never worked with AND before so i was trying to just write a simple AND statement to understand the syntax of it, but i cant seem to get that at all

I realize i may also be approaching the maximum allowable if statements in a nest

Any help would be most appreciated

Thanks
=if(and(isnumber(find("FHA",c62)),isnumber(find(15,c62),.50%,0

First part could be

Please Login or Register  to view this content.

Excel 2003 and before allows a max of 7 nested IFs. You are close to the limit, but you can shorten the formula by reversing the order of cells B20:B24. To continue the formula above that would be,

Please Login or Register  to view this content.

Awesome didnt feel like rewriting the whole formula using the "lookup" so I just added the additional "find" criteria to exisitng formula and it works like a charm, I was missing the + sign

Thanks so much