So I do sports spreadsheets for fantasy sports. I’m filling out my baseball spreadsheet right now and im planning on doing this for football too if it works. A couple weeks ago I learned that you can make the spreadsheet calculate the number in a cell based on the numbers in other cells by making an equation. This helps shaves off a lot of my workload.

Right now i’m trying to get it to calculate fantasy points

A pitcher gets:

- 5 points for a Win
- 5 points for a Save
- -0.5 points for an earned run
- 1 point for an inning pitched
- 2 points for a strikeout

—————

- Wins are in the M column
- Saves are in the N column
- Earned runs are in the O column
- Innings pitched is in the L column
- Strikeouts are in the P column

**So my equation is:**

= M3 * 5 + N3 * 5 + O 3 * - 0.5 + L3 * 1 + P3 * 2

Some of them are right on the money. I’ve put in eight of them. 3 are exactly correct. 4 of them, the decimal is wrong, 1 of them is off by a whole ten points. I don’t know what i’m doing wrong.

- Serverfault Help
- Superuser Help
- Ubuntu Help
- Webapps Help
- Webmasters Help
- Programmers Help
- Dba Help
- Drupal Help
- Wordpress Help
- Magento Help
- Joomla Help
- Android Help
- Apple Help
- Game Help
- Gaming Help
- Blender Help
- Ux Help
- Cooking Help
- Photo Help
- Stats Help
- Math Help
- Diy Help
- Gis Help
- Tex Help
- Meta Help
- Electronics Help
- Stackoverflow Help
- Bitcoin Help
- Ethereum Help