I have an excel problem. I have a golf league formula that takes the best 5 scores out of the last 6 and calculates a handicap based on 90% of the average.....Howver, my problem is if a player has not played 6 weeks a differet forumula is used. How would I do that using one formula. Could I incorporate several if/then statements into one monster formula? Here's the formula I am using if the player has 6 rounds completed:

=(AVERAGE(SMALL(B2:G2,{1,2,3,4,5}))-36)*0.9

Here is what is used if they haven't:

5 scores - Used 5 scores subtracted 180 divided by 5 and took 90%
4 scores - Used 4 scores subtracted 144 divided by 4 and took 85%
3 scores - Used 3 scores subtracted 108 divided by 3 and took 80%
2 scores - Used 2 scores subtracted 72 divided by 2 and took 75%
1 score - Used 1 score subtracted 36 and took 70%