Computing bonus/penalty points

[Diz]

I am trying to set up a formula where it would compute bonus or penalty
points based on the value in the previous cell eg. if G4<12 subtract 2
points, if G4<11 subtract 4 points. And on the reverse side if G4> 12 add 1
point, and so on. Does anyone have any suggestions?

 

[Max]

Maybe something along these lines ..

Assuming the specs to get a result in G5
based on what's in G4 were:

a. If G4 is either blank or <= 4 or
contains other than a number : leave it blank ""
b. If G4 is >4 and <=11 : subtract 4 from G4
c. If G4 is >11 and <=12 : subtract 2 from G4
d. If G4 is >12 : add 1 to G4

then try in G5:

=IF(OR(ISTEXT(G4),G4="",G4<=4),"",IF(G4<=11,G4-4,IF(G4<=12,G4-2,G4+1)))

 

[Ragdyer]

You should set up a data list containing your specs, and then refer to that
list for your results.

For example,
A1:A11 = 7 to 17
B1:B11 = -10,-8,-6,-4,-2,0,1,2,3,4,5

With your value in G4, enter this in H4:

=INDEX(B1:B11,MATCH(G4,A1:A11,0))

 

[Diz]

Thank you very much, that did it for me. I just hope that's what the teacher
wants.