Hello!
So I am trying to create a formula that will help determine what are the greatest sports playoff series of all-time using factors such as total games played, percentage of points scored late in the games, percentage of one-score games, etc. So I create some IF statements like ...
=IF(E2<6,"0",IF(E2=6,"1",IF(E2=7,"2")))
This says that any series that is less than six games long earns zero points, a six-game series earns one point, and a seven-game series earns two. I then created similar formulas for a few other instances; including a few that don't require an IF formula. All looks good ... until I go to sum up the values of these cells and none of the values of the cells with IF statements get included.
Sooooooo ... help lol! Clearly I either botched something with the IF statement and/or should be using some other formula.
And I made sure they are all cells are set to NUMBER and not anything else. Thank you guys very much.
So I am trying to create a formula that will help determine what are the greatest sports playoff series of all-time using factors such as total games played, percentage of points scored late in the games, percentage of one-score games, etc. So I create some IF statements like ...
=IF(E2<6,"0",IF(E2=6,"1",IF(E2=7,"2")))
This says that any series that is less than six games long earns zero points, a six-game series earns one point, and a seven-game series earns two. I then created similar formulas for a few other instances; including a few that don't require an IF formula. All looks good ... until I go to sum up the values of these cells and none of the values of the cells with IF statements get included.
Sooooooo ... help lol! Clearly I either botched something with the IF statement and/or should be using some other formula.
And I made sure they are all cells are set to NUMBER and not anything else. Thank you guys very much.
