help with IF formula
Posted by Pat on August 15, 2000 6:29 PM
Can anyone help with writing the correct formula to accomplish the following...
I am trying to develop a spreadsheet in Excel to track fantasy football statistics. Each player scores points based on their performance each week. The better they do the more points they score. I would like to develop a spreadsheet where I can enter the players statistics and have excel compute their score.
An example is:
QB1 - 100 yards - 8 points
QB2 - 300 yards - 15 points
I cannot figure out the correct formula to accomplish this. I have tried nesting IF statements how ever excel only allows 7 nested IF statements and I need up to 20.
Can anyone help please. I am going nuts trying to figure this out.