Applying two conditions in formula

tiger3p

New Member
Joined
Feb 24, 2006
Messages
22
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
 

Excel Facts

Copy formula down without changing references
If you have =SUM(F2:F49) in F50; type Alt+' in F51 to copy =SUM(F2:F49) to F51, leaving the formula in edit mode. Change SUM to COUNT.
Try

Code:
=IF(AND(E4="FT",U4<=DATE(2010,10,10)),IF(V4>=160,L7,IF(P4>=12,L6,"NA")))
 
Upvote 0
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")))
 
Upvote 0
Maybe this, but I don't follow the "Otherwise" part of your formula, as you have added more than 1 additional criteria !!

Code:
=IF(AND(E4="FT",A5="IRS",U4<=DATE(2010,10,10)),IF(V4>=160,L7,IF(P4>=12,L6,"NA")))
 
Upvote 0
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.
 
Last edited:
Upvote 0
Maybe this....UNTESTED

Code:
=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)
 
Upvote 0

Forum statistics

Threads
1,212,927
Messages
6,110,700
Members
448,293
Latest member
jin kazuya

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top