I have been trying for sometime to get an equation to work with no luck.
I have 7 columns
1)Game 1, 2)Game 2, 3)Game 3, 4)Total, 5)Grand Total, 6)Average, 7)Handicap
Game 1,2 & 3 are pretty self explanatory as is total
Grand total is a sum of all weekly totals
Average is the average of all games
and handicap is based on 80% of 125
the equation that I am using for handicap is
first check to see if game 1 is blank, if it is, I want to show nothing
second check to see if Game 1,2, &3 are all equal, if they are I want to show the handicap from the previous week
third check to see if average is greater or less then 125
This is what I have come up with
=IF(ISBLANK(A6),""),IF(AND(A6=B6,B6=C6),G5),IF(F6>125,0,(125-F6)*80%)
with this formula I get a #value in the cell, I don't know if there are too many arguments for this formula to work or what, I think it is close but just cant seem to get it work properly
Any help or suggestions are great
Thanks in advance
I have 7 columns
1)Game 1, 2)Game 2, 3)Game 3, 4)Total, 5)Grand Total, 6)Average, 7)Handicap
Game 1,2 & 3 are pretty self explanatory as is total
Grand total is a sum of all weekly totals
Average is the average of all games
and handicap is based on 80% of 125
the equation that I am using for handicap is
first check to see if game 1 is blank, if it is, I want to show nothing
second check to see if Game 1,2, &3 are all equal, if they are I want to show the handicap from the previous week
third check to see if average is greater or less then 125
This is what I have come up with
=IF(ISBLANK(A6),""),IF(AND(A6=B6,B6=C6),G5),IF(F6>125,0,(125-F6)*80%)
with this formula I get a #value in the cell, I don't know if there are too many arguments for this formula to work or what, I think it is close but just cant seem to get it work properly
Any help or suggestions are great
Thanks in advance