Google Sheets formula isn't adding up to the same total from the Yahoo Fantasy app?

by Lizzie C   Last Updated October 19, 2019 20:03 PM

I tried posting this yesterday and didn't get many responses

So, I do sports spreadsheets for fantasy sports. I’m filling out my baseball spreadsheet right now and I'm 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 formula. This helps shave 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 formula is:

=M3*5+N3*5+O3*-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.

Screenshot of spreadsheet



Related Questions


Updated September 13, 2019 03:03 AM

Updated June 04, 2015 23:01 PM

Updated November 19, 2018 18:03 PM

Updated June 19, 2016 08:01 AM

Updated July 26, 2019 16:03 PM