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 `0`

.

### >Solution :

What about:

IF(OR(B2<=44,B2>=50),0,50-B2)

Of course you could do this:

```
IF(abs(50-B2)>5,0,50-B2)
```

Based on the comment by User1122393 :

tested with more values: