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