IF formula to create status based on multiple conditions

[MTC2016]

Hi all,


I thought this one would be simple but I cant seem to figure it out. I have attached a test workbook which outlines the requirements. I have tried several different formulas but haven't had any joy so I would appreciate some assistance if you may

[Pete_UK]

Try this formula in G5:

=IF(B5&C5&D5="","Opportunity for Trainging",IF(COUNTIF(B5:D5,">1")=3,IF(F5<=$A$2,"Training Required","Fully Trained"),IF(COUNTIF(B5:C5,">1")=2,"Under Supervision","Trining Initiated")))

Hope this helps.

Pete