H
Harvey
I wonder if anyone can help me with a problem I have. I
am trying to add points for a league based on indivdual &
aggregate scores for a bowls program I have made, which
goes like this. Each team consist of say 10 players & the
games are 21 up, so in theory, a team could win 210-0 &
finnish up with 12 points, 1 point for each player
winning and 2 points for the aggregate. Up to this point
I have worked out how to do it. My main problem is, &
what I need help with, is that in 2 of the leagus if you
win away from home, you get 3 points for the aggregate.
This is what I have at the moment but can't get it to add
the 3 points for an away win for them 2 leagues. =IIf
([Sum Of AwayScore]>[Sum Of HomeScore],0,IIf([Sum Of
HomeScore]>[Sum Of AwayScore],IIf([HomeOrAway]
="Home",2,3)))
Thank's in anticipation
Harvey
am trying to add points for a league based on indivdual &
aggregate scores for a bowls program I have made, which
goes like this. Each team consist of say 10 players & the
games are 21 up, so in theory, a team could win 210-0 &
finnish up with 12 points, 1 point for each player
winning and 2 points for the aggregate. Up to this point
I have worked out how to do it. My main problem is, &
what I need help with, is that in 2 of the leagus if you
win away from home, you get 3 points for the aggregate.
This is what I have at the moment but can't get it to add
the 3 points for an away win for them 2 leagues. =IIf
([Sum Of AwayScore]>[Sum Of HomeScore],0,IIf([Sum Of
HomeScore]>[Sum Of AwayScore],IIf([HomeOrAway]
="Home",2,3)))
Thank's in anticipation
Harvey