[Solved] Employee confirmation upon achievement of 3 conditions

[Susan]

I would like to create a logic for confirmation of trainees upon completion of probation. They are only confirmed if they meet all of the following criteria:

1. Pass rate for test 70%
2. Have a rider's license.
3. obtain an appraisal score of not less than 7

Kindly assist with the logic

 

[Rubayed Razib]

Greetings mFaisal,
You can use the below formula for the problem you stated,
=IF(AND(B3>70%,C3="Yes",D3>=7), "Confirmed", "Not

As you can see that the final verdict is showing whether the trainees are confirmed or not. based on the criteria .The excel sheet containing the formulas are attached below.

 

[Susan]

Thank you so much. This is helpful