My equation in Google Sheets doesn’t add up to the same total in Yahoo?

by Lizzie C   Last Updated October 19, 2019 05:03 AM - source

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.



Related Questions



Help Please - My mail was ached

Updated July 26, 2019 16:03 PM


How to retrieve yahoo security questions and answers

Updated October 06, 2017 10:03 AM

Account recovery of my Gmail account

Updated November 06, 2015 09:01 AM