Help with a Formula

Is there a formula or something that I can use to calculate yardage in a football game?

 

I would like to enter the yardline where the ball started and where the ball ended and it give me the total.

Example:  if the ball is on the 40 and goes to the other 40 it would tell me 20 yards.

 

Any Ideas?

JPH's picture

yardline solution

This one is easy.

Make a table with 2 columns.

In the first column you place the yardlines. Don't forget to add a symbol for which side off the field. For example use  "10 g" for yardline 10 guest side and "10 h" for home side.

In the second you place the lenght form the start. So you get:

 

"10 G"  10

"20 G"  20

"30 G"  30

"40 G"  40

"50 M"  50

"40 H"  60

"30 H"  70

"20 H"  80

"10 H"  90

Next you make 2 vlookups that look for the 2 lines you name. Then substract the 2 answers and place them inside =abs( ).

Voila you're answer.

It's not a formula but it is something.

 

Greetings,

JPH