# Football Fun in Excel

This Sunday is Super Bowl XLIX – the last one that will start with "XL".  Next year, it will be Super Bowl L – that doesn't exactly roll off the tongue!

In 2011, I showed how you can use the ROMAN function in Excel, to change a number into a Roman numeral. That year, they were playing for the 45th time, which was XLV.

=ROMAN(A2)

### Other Football Functions

There are other Excel functions that sound like they could be used in a football game. Here are a few, and I'm sure you can think of others:

• CONVERT
• RECEIVE
• YIELD
• SUBSTITUTE
• ISREF

Okay, that last one was a bit of a stretch, but I'll allow it. What functions did I miss?

### Close Football Games

While you wait for the game to start, you can look back at some historic games, with the data that Kevin Lehrbass compiled in an Excel file. You can download Kevin's workbook, which contains enough data to entertain you for a couple of days, while you try to decide which was the closest game.

Did Kevin think of all the factors that make a football game close, and exciting to watch?

You can even select a couple of Super Bowls, and compare them. Have fun, and enjoy Sunday's game!

_____________________

### 11 Responses

1. Tim Mayes says:

Deb,

I can’t believe that you missed Intercept. :-)

Actually, this is kind of a silly post, but very useful. It encourages one to scan through all of the functions and reminds you of the ones you have forgotten about. Good post!

• Thanks Tim, and I left that one for you! Plus, I didn’t notice it, while looking through the functions list earlier. ;-)

2. Terry says:

How about LOOKUP?

3. Rudra says:

What about Areas, Match,round etc.?

4. Elias says:

What about Choose?

A1=Choose(2,”Run-Win”,”Pass-Lose”)

Regards

• Ouch! Thanks Elias, that’s a good one, even if the Seahawks fans might not like it.

5. Randy emailed me with these excellent suggestions — thanks Randy!

Football function: Replace
Football function: Time (as in, call time-out)
Football function: INT (as in, intercept)
Football function: INTERCEPT
Football function: Replace

6. John says:

Call, Second, Match, Average, Intercept, substitute, space