SOLVED

I cannot find the formula I need

Copper 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,

3 Replies
best response confirmed by mathetes (Silver Contributor)
Solution

Re: I cannot find the formula I need

=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

Re: I cannot find the formula I need

sas efcharisto, @NikolinoDE, it really helped :)

Re: I cannot find the formula I need

yw, eyxaristisi mou :)
1 best response

Accepted Solutions
best response confirmed by mathetes (Silver Contributor)
Solution