Football Stats:
 

Hello anyone out there that can help me write a formula that covers things in
football The one thing that I would like to do is have it take away the
yardage for me if I use an input that the ball starts on the 40 yard line on
the home team and is ran back for a touchdown. A football gain of 60 yards.
How do I get this done? Thanks if you can help at all.