Forum Discussion

B_Garaio's avatar
B_Garaio
Copper Contributor
Dec 20, 2023

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,

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

  • NikolinoDE's avatar
    NikolinoDE
    Gold Contributor

    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:

Resources