Hi all, I have been really struggling with this question I was wondering if anybody could help.
1). A student receives a UCPD award if they have completed 3 modules successfully and a UCAPD if they have completed 6 modules successfully. In column N enter a nested IF formula which determines whether a student gets a UCPD, UCAPD or neither.
The main bit which is confusing me is what if the number is more than 3 but less than 6, it needs to display UCPD but its not working. I am not sure what to do at the moment.
I have tried multiple IF statements however nothing seems to be working, this is what I have at the moment:
1). A student receives a UCPD award if they have completed 3 modules successfully and a UCAPD if they have completed 6 modules successfully. In column N enter a nested IF formula which determines whether a student gets a UCPD, UCAPD or neither.
The main bit which is confusing me is what if the number is more than 3 but less than 6, it needs to display UCPD but its not working. I am not sure what to do at the moment.
I have tried multiple IF statements however nothing seems to be working, this is what I have at the moment:
the column which the data is on:=IF(M3<3,"Neither",IF(AND(M3=3,M3>=5,"UCPD"),IF(M3>=6,"UCAPD")))
Number of modules Passed |
5 |
1 |
2 |
6 |
7 |
2 |
7 |
3 |