[Solved] Employee confirmation upon achievement of 3 conditions

Susan

New member
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
 
Greetings mFaisal,
You can use the below formula for the problem you stated,
=IF(AND(B3>70%,C3="Yes",D3>=7), "Confirmed", "Not
1685952655332.png
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.
 

Attachments

  • Probation performance.xlsx
    11.6 KB · Views: 2

Online statistics

Members online
2
Guests online
4
Total visitors
6

Forum statistics

Threads
287
Messages
1,240
Members
508
Latest member
HaroldDyeme
Top