If - Then - Else

saraha83081

I'm trying to create an If/Then/Else statement to determine if an employee is eligible for a pay increase.  Essentially, the formula needs to say 

IF Mandatory Training Requirements Met = YES

AND Corrective Action = NO

THEN Eligible for Increase = YES

ELSE Eligible for Increase = No

Any thoughts on how to accomplish this?

 

 

Dan Seidler

Here ya go!

=IF(AND([Mandatory Training Requirements Met]@row = "Yes", [Corrective Action]@row = "No"), "YES", "No")