excel rank function help

[bricklayer]

im using the rank trigger sheet:
=IF(AND(AA5=1,F5<=4,$F$2="",COUNTBLANK(T$5:T$50)=46),"BACK-IP","")

i would like to add another condition to the above, that would also select rank5 and rank6 when the first selection at AA5=1 fires the trigger.

eg, i need to add AA5=5, AND AA5=6 somewhere in the formula.


any help would be much appreciated,

[Captain Sensible]

Just nest this formula within a new IF formula so it checks a bet has been fired i.e. COUNTBLANK(T$5:T$50)=45 and checks the ranking

something like

=IF(AND(COUNTBLANK(T$5:T$50)=45,OR(AA5=5,AA5=6)),"Whatever you want to do",IF(AND(AA5=1,F5<=4,$F$2="",COUNTBLANK(T$5:T$50)=46),"BACK-IP","") )

I haven't tried ths so check it does what you need before using,

[bricklayer]

Thanks Captain,

will give that a try to see if it does what im trying to do