Imran Azam
Board Regular
- Joined
- Mar 15, 2011
- Messages
- 103
Hi Guys
I have a task at work where i need to create a function based on the data below ( this is made up example data i)
i am struggling with this task and was wondering if anyone can help?
please note this is in sheet 1 from A4-d9
The function needs to allow a user to type a student name via an input box and then do the following
I have a task at work where i need to create a function based on the data below ( this is made up example data i)
i am struggling with this task and was wondering if anyone can help?
please note this is in sheet 1 from A4-d9
student | grade | average % | status |
James | 55 | 52 | pass |
Ian | 38 | 35 | fail |
Mike | 80 | 74 | high pass |
Jane | 65 | 67 | pass |
Will | 10 | 23 | none |
The function needs to allow a user to type a student name via an input box and then do the following
- If the typed student in the input box isn't in the student list then message should returns 'Student does not exist'
- If the typed student name grade is between 16 and 40 OR the Average is 35 % OR the status is 'fail' then message should return 'undecided'
- if the typed student name grade is between 5 and 15 and % is less or equal to 24% AND status is 'none' then message should return 'Student hasn’t progressed'
- else message should return ' student has progressed'