Question regarding the use of If Statement with multiple And/Or conditions

[Ublondgirl]

Hello,

I am trying to write a formula which encompasses all the following conditions, and am having trouble figuring out how to put them all into one formula with And/Or statements.

Here's the criteria:

If B2 = Full Time and F2 < 172
Or if B2 = Part Time and F2 > 160
Or if B2 = seasonal and F2 > 120

Then "Check"
otherwise "ok"

I can get two of the three in using And & OR, but can't figure out how to add the 3rd condition in there. Any assistance would be greatly appreciated!!!

 

[jtakw]

Hi,

Try:

=IF(OR(AND(B2="Full Time",F2<172),AND(B2="Part Time",F2>160),AND(B2="Seasonal",F2>120)),"Check","Ok")

 

[Fluff]

Hi & welcome to MrExcel.
How about
=IF(OR(AND(B2="Full Time",F2<172),AND(B2="Part Time",F2>160),AND(B2="seasonal ",F2>120)),"Check","ok")

Beaten2it

 

[Ublondgirl]

Terrific, thank you so much! Somehow that third 'And' kept tripping me up!!!

 

[Fluff]

Glad we could help & thanks for the feedback