Forum Discussion
Solved
I cannot find the formula I need
Dear community members, I am scoring some exams and I am obliged to subtract points if they do not reach a certain number of words. The points that are subtracted depend on the number of words th...
Here is a simple solution approach following your task.
=IF(A1 >= 136, 0, IF(A1 >= 132, -1, IF(A1 >= 127, -2, IF(A1 >= 126, -3, "Fail"))))
Here one would ask the question what if it is over 139?
Anyway hope it helped you
Here is a simple solution approach following your task.
=IF(A1 >= 136, 0, IF(A1 >= 132, -1, IF(A1 >= 127, -2, IF(A1 >= 126, -3, "Fail"))))
Here one would ask the question what if it is over 139?
Anyway hope it helped you
sas efcharisto, NikolinoDE, it really helped 🙂
- yw, eyxaristisi mou 🙂