I have the following formula
=IF(H6="","",VLOOKUP(H6,$N$21:$O$26,2))
can anyone help me add a contraint IF statement that lets me have a PT is a student fails their exam and do not pass above 50% & PC if they pass there exam and do not pass above 50%?! Cna anyone help?!
=IF(H6="","",VLOOKUP(H6,$N$21:$O$26,2))
can anyone help me add a contraint IF statement that lets me have a PT is a student fails their exam and do not pass above 50% & PC if they pass there exam and do not pass above 50%?! Cna anyone help?!