hi team
looking to improvise on the formula mentioned below:
=IFERROR(IF(CJ16<100%,"N",IF(CK16<84.999%,"N",IF(CL16<84.999%,"N","Y"))),"")
this lets me know if a candidate has passed or not, what i want is that if there is no test data then the cell with this formula should be blank.
any ideas
looking to improvise on the formula mentioned below:
=IFERROR(IF(CJ16<100%,"N",IF(CK16<84.999%,"N",IF(CL16<84.999%,"N","Y"))),"")
this lets me know if a candidate has passed or not, what i want is that if there is no test data then the cell with this formula should be blank.
any ideas