SOLVED

I cannot find the formula I need

Copper Contributor

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

@B_Garaio 

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 :smile:

sas efcharisto, @NikolinoDE, it really helped :) 

yw, eyxaristisi mou :)
1 best response

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

@B_Garaio 

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 :smile:

View solution in original post