Home » Forums » Open Source Learning Center » Question and Answer

Help with a Formula

Submitted by littlete on 15 October, 2010 - 18:55

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?

‹ Copy a range of cells from worksheet in workbook a to worksheet in workbook b Convertir dos rangos verticales en un solo rango vertical ›
»
JPH's picture

yardline solution

Submitted by JPH on 18 October, 2010 - 11:00.

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

 

 

»