excel 足球 积分_Excel功能星期五：足球乐趣

excel 足球 积分

Excel功能星期五：足球乐趣 (Excel Function Friday: Football Fun)

Apparently there is a big football game this weekend in the USA. They're using Excel for the game -- XLV. That's a really old version, but at least it has multiple sheets and VBA!

显然，本周末在美国有一场大型足球比赛。 他们在游戏中使用Excel-XLV。 那是一个很旧的版本，但至少它有多个工作表和VBA！

The officials probably used the Excel ROMAN function to figure out how to show the game number -- 45:

官员们可能使用了Excel ROMAN函数来弄清楚如何显示游戏号码-45：

=ROMAN(A2)

=罗马(A2)

While you're watching the game, you can use an Excel function to convert the field size from yards to metres. You'll see that the American field is smaller than the Canadian field, no matter what measurement system you use!

在观看比赛时，可以使用Excel函数将字段大小从码转换为米。 您会发现，无论使用哪种测量系统，美国领域都比加拿大领域小！

将米转换为码 (Convert Metres to Yards)

There is a CONVERT function in Excel, that you can use to convert measurements from one system to another.

Excel中有一个CONVERT函数，可用于将测量从一个系统转换为另一个系统。

=CONVERT(number,from_unit,to_unit)

= CONVERT ( number ， from_unit ， to_unit )

For example, cell B3 has the length of a Canadian field in metres. In cell D3, the following formula converts that measurement to yards, and rounds the result:

例如，单元格B3的加拿大字段长度为米。 在单元格D3中，以下公式将该度量转换为码，并将结果四舍五入：

=ROUND(CONVERT(B3,B$2,D$2),0)

=圆(转换(B3，B $ 2，D $ 2)，0)

Unfortunately, the CONVERT function does not get you an extra point.

不幸的是，CONVERT函数并不能给您额外的好处。

其他差异 (Other Differences)

Besides the size of the fields, there are other key differences between Canadian and American football.

除了场地的大小外，加拿大和美国橄榄球之间还有其他主要差异。

No stripes? Fewer players? More downs? You call that a game? 😉

没有条纹吗？ 更少的球员？ 更多跌落？ 你叫那场比赛吗？ 😉

说到Excel 5.0 (Speaking of Excel 5.0)

Do you remember when printed manuals came with the software? I still have my Excel 5.0 User Guide, so maybe I can read it while watching the big game!

您还记得软件随附印刷手册时的情况吗？ 我仍然有《 Excel 5.0用户指南》，因此也许我可以在观看大型游戏时阅读它！

There were tons of new features in that version, so there will be lots of interesting stuff to read.

该版本中有很多新功能，因此将有很多有趣的东西可供阅读。

翻译自: https://contexturesblog.com/archives/2011/02/04/excel-function-friday-football-fun/

excel 足球 积分