Formual Help

[tmcshane224]

Hi All,

I can't seem to get this to work.

=IF(AND(OR(AI7="a",AJ7="a",AK7="a"),(IF(R8<>"F",AND((R9<11),(R9<>"")),AND(R8="F",R9<11,R9<>"")))),"a","")

When I type M in R8 and 11 or above in R9 it doesnt put an "a" in my cell.

When I type F in R8 and 11 or above in R9 it doesnt put an "a" in my cell.

When I don't type M or F it seems to work when I put a number below 11 in R9.

I need it to populate the cell is there is an M in R8 and any age in R9 and if the there is an F in R8 and an age under 11 in R9.

Help would be great thanks.

 

[texasalynn]

So try breaking down your formula into smaller test, like

=AND((R9<=11),(R9<>""))
=AND(R8="F",R9<=11,R9<>"")
then you can see where your statement is failing

 

[tmcshane224]

I still haven't been able to get this work. Any help out there?

Thanks

 

[texasalynn]

did you try breaking it down first?

 

[tmcshane224]

Yes, I can't seem to get it to pick up another letter other than "F"

 

[VaraK]

Hi,

From what I understood, this should work.

=IF(AND(IF(R8="M","a",IF(AND(R8="F",R9<11),"a",""))="a",OR(AI7="a",AJ7="a",AK7="a")),"a","")

Hope this helps.

 

[tmcshane224]

VaraK you rock... Thanks for this help! Works great.