Applying two conditions in formula

[tiger3p]

Hello,

Trying the following formula and I keep getting an error:

=IF((AND(E4="FT",(U4<=DATE(2010,10,10)),IF(V4>=160,L7,IF(P4>=12,L6))))

I'm trying to meet the following condition: If the cell in E4 is FT AND the date in U4 is less than 10/10/2010, evaluate the following: if cell V4 is greater than or equal to 160, return L7 else if P4 greater than or equal to 12, return L6, ELSE return "Not Applicable".

Appreciate any help!

Thanks

 

[Michael M]

Try

=IF(AND(E4="FT",U4<=DATE(2010,10,10)),IF(V4>=160,L7,IF(P4>=12,L6,"NA")))

 

[tiger3p]

That works! Thank you. What if I wanted to add an additional condition to state =IF(AND(E4="FT",U4<=DATE(2010,10,10),A5="IRS"),IF(V4>=160,L7,IF(P4>=12,L6,"NA"))) Otherwise,
=IF(AND(E4="FT",U4<=DATE(2010,10,10),A5="BIR"),IF(V4>=160,L8,IF(P4>=12,L5,"NA")))

 

[Michael M]

Maybe this, but I don't follow the "Otherwise" part of your formula, as you have added more than 1 additional criteria !!

=IF(AND(E4="FT",A5="IRS",U4<=DATE(2010,10,10)),IF(V4>=160,L7,IF(P4>=12,L6,"NA")))

 

[tiger3p]

Thanks for this! Does the condition also work using VLookup?

I tried =IF(AND(E4="FT",U4>=DATE(2019,2,1),U4<=DATE(2010,10,10),0, vlookup(A4,'Test Source'!$B$2:$Y$200,23,0)) and I get the vlookup value instead of 0.

 

[Michael M]

Maybe this....UNTESTED

=IF(AND(E4="FT",U4>=DATE(2019,2,1),U4<=DATE(2010,10,10)),VLOOKUP(A4,'Test Source'!$B$2:$Y$200,23,0),0)