Formula Help

[Rick S]

I am working on a formula that calculates team district points

If team A has a score of cell a1 = 20
if team B has a score of cell a2 = 10

Team a gets 10 district points and team B gets -10 points
The maximum points allowed is 15 points and minimum of -15 points.

The formula that I have is =max(-15,min(a1-a2,15))

This works great but now if the game goes into overtime, the winnin
team gets 1 point and the losing team gets -1 point.

If I put "OT" in cell c2 to indicate overtime, how do I make th
formula to equal only 1 point?

Any help or suggestions would be appreciated, Thanks Ric

 

[Dave Peterson]

Maybe...

=IF(c2="OT",SIGN(A1-A2),MAX(-15,MIN(A1-A2,15)))

 

[Rick S]

Perfect! Thanks Dav