J
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
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