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:
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.