Formula for Bonus & Penalty

[Jesse]

I have another dilema.
Need the formula for:

If credits are (12) or more, add (1) bonus point.
If credits are less than (12), subtract (2) penalty points.

In my head it would look like:

G4=Credits cell.(<>=12)
H4=Bonus/Penalty 'totals' cell.
E21=Bonus point (1) cell.
E20=Penalty point (2) cell.

=(IF((G4>12,+$E$21,H4)MIN(G4<12,-$E$20,H4)????

But it's not right. Can you help?
Thank you,
Jesse

 

[J.E. McGimpsey]

How about:

=G4 + (G4>=12) - 2*(G4<12)

or

=G4 - 2 + 3 * (G4>=12)