I’m a new teacher and i was trying to write a program in excel that helps students with a maximum of 5 marks if needed to pass.
As an example:
- if a student gets 46 I’d give him 4 marks.
- if the student gets 49 I’d give him 1 mark.
- if the student gets 44 or 50 he gets 0.
I want to write a formula in the column K that gives values from 0 to 5.
Not using excel before I tried
=IF((44<J3<50),50-J3,0) for student A but got
0 and everyone else got the same
Of course you could do this: