quick question

[zorg2780]

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

 

[Andrew Poulsom]

How about?

=IF(COUNTA(CJ16:CL16),IFERROR(IF(CJ16<100%,"N",IF(CK16<84.999%,"N",IF(CL16<84.999%,"N","Y"))),""),"")

 

[zorg2780]

Hi Andrew

thanks for the quick reply, however the blank cells where test scores havent been updated still show as N, this brings down my certification percentage...

any other ideas

 

[Andrew Poulsom]

Maybe:

=IF(COUNT(CJ16:CL16)=3,IFERROR(IF(CJ16<100%,"N",IF(CK16<84.999%,"N",IF(CL16<84.999%,"N","Y"))),""),"")

 

[zorg2780]

well I did try that as well but it doesnt seem to work...i'm puzzled

im not so sure how to proceed

 

[Andrew Poulsom]

Can we see some sample data and the expected results please?

 

[zorg2780]

could you help me with how do i paste an image or a file so that it can help you

 

[Andrew Poulsom]

You can try copying the data in Excel and pasting it into the body of a reply.