Hi folks,
I am working on a register for online students.
Over the course of a day (7 lessons), if a student has more than 3 'TRUE', 'R' or 'L' values between D4 and J4 a 'P' appears, if a student has more than 2 'AA' values between D4 and J4 a 'AA' appears, if neither of these apply a 'UA' appears.
The 'true', 'r' and 'l' must take preference over the 'aa'
I currently have this:
=IF(COUNTIF(D4:J4,TRUE)+(COUNTIF(D4:J4,"R")+(COUNTIF(D4:J4,"L")))>3,"P",IF(COUNTIF(D4:J4,"AA")))>2,"AA""UA"
It doesn't work
Thank you in advance,
I hope I'm making sense?
I am working on a register for online students.
Over the course of a day (7 lessons), if a student has more than 3 'TRUE', 'R' or 'L' values between D4 and J4 a 'P' appears, if a student has more than 2 'AA' values between D4 and J4 a 'AA' appears, if neither of these apply a 'UA' appears.
The 'true', 'r' and 'l' must take preference over the 'aa'
I currently have this:
=IF(COUNTIF(D4:J4,TRUE)+(COUNTIF(D4:J4,"R")+(COUNTIF(D4:J4,"L")))>3,"P",IF(COUNTIF(D4:J4,"AA")))>2,"AA""UA"
It doesn't work
Thank you in advance,
I hope I'm making sense?