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 - source

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:


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

Google Sheets ImportXML() - Imported Content Empty Error

Updated September 13, 2019 03:03 AM

Sports Betting Web Application

Updated November 19, 2018 18:03 PM

Help Please - My mail was ached

Updated July 26, 2019 16:03 PM