Forum Discussion
B_Garaio
Dec 20, 2023Copper Contributor
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 they write:
136 - 139 --> -1 points
132 - 135 --> -2 points
127 - 131 --> -3 points
≤ 126 ------> Fail
I would like to insert a formula that automatically tells me how many points I have to subtract from each exam and the truth is that I don't know how to do it.
Therefore, I would greatly appreciate if someone could help me by telling me the formula I need.
Thank you very much in advance and kind regards,
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
- NikolinoDEGold Contributor
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
- B_GaraioCopper Contributor
sas efcharisto, NikolinoDE, it really helped 🙂
- NikolinoDEGold Contributoryw, eyxaristisi mou 🙂