In order to reduce the number of hours reviewing resumes management receives the reports like the one below. They task you with creating a formula to identify qualified candidates for their job posting.

Return "Qualified" if both years of experience is five or more and years of education is greater than or equal to six. If only one criteria is met, return "Consideration". If none of the criteria are met return "Not Qualified".

$\backslash$table$[[$Last Name,First Name,Proficient with Excel,Years of Experience,Years of Education,Option $1,$Option $2,$Option $3,$Analysis$],[$Simpson$,$Thamar,No$,7,6,$Qualified,Consideration,Not Qualified,$],[$Quershi$,$Ali,Yes,$8,6,5$ Qualified,Consideration,Not Qualified,$],[$Deonarine$,$Rayon,No$,0,4,$Qualified,Consideration,Not Qualified,$],[$Hassanein$,$Amr,Yes,$4\mathrm{.}5,6,5$ Qualified,Consideration,Not Qualified,$],[$Saint$,$Claudie,Yes,$5,4,4$ Qualified,Consideration,Not Qualified,$],[$Alam$,$Sultana,No$,2,6,5$ Qualified,Consideration,Not Qualified,$],[$Jacques$,$Stefan,Yes,$3,8,3$ Qualified,Consideration,Not Qualified,$],[$Regis$,$Stacey,No$,4,4,4$ Qualified,Consideration,Not Qualified,$]]$