Combining IF and OR formulas

[Scuba*33]

I am having a little trouble getting this formula figured out. I have three columns Type (E5), Score (K5), and number of Hits (L5).

IF E5 is equal to M16 then use the following formula =IF(AND(L5>=0, L5<=22),"DQ",IF(AND(L5>=23, L5<=29),"MM",IF(AND(L5>=30, L5<=35), "SS", IF(AND(L5>=36, L5<=40), "EX",0))))

OR

IF E5 is eqaul to M9 use the following formula =IF(AND(L6>=0, L6<=23),"DQ",IF(AND(L6>=24, L6<=28),"MM",IF(AND(L6>=29, L6<=35), "SS", IF(AND(L6>=36, L6<=40), "EX",0))))

How do I combine the two formula's in cell K5?

Thanks in advance for any help.

[FDibbins]

Hi and welcome to the forum

Based on just what you said you wanted above, and untested...

=if(E5=E16, IF(AND(L5>=0, L5<=22),"DQ",IF(AND(L5>=23, L5<=29),"MM",IF(AND(L5>=30, L5<=35), "SS", IF(AND(L5>=36, L5<=40), "EX",0)))), if(E5=M9, IF(AND(L6>=0, L6<=23),"DQ",IF(AND(L6>=24, L6<=28),"MM",IF(AND(L6>=29, L6<=35), "SS", IF(AND(L6>=36, L6<=40), "EX",0)))), ""))

[Scuba*33]

That Worked out PERFECT! M16 and M9 where text, I forgot to say that in the thread. I Put "" around them and it worked smooth as butter. Thanks FDibbins!

[FDibbins]

Great stuff

you'r welcome. If this answered your question, please take a moment to mark the thread as "solved" - it helps keep things neat and tidy lol, and consider adding the reputation to those that helped (see points 2 & 3 below my 1st post to you)