1

**Help Me / check my formula pleeeeaaassse**

« **on:**January 28, 2009, 04:24:28 AM »

Hi ive been reading the forums trying to figure out my formula and im pretty close....dummy at this programming so desperatly need help if possible.

if(inLeague, (leagueRank < 37, 25, 0) + if(leagueRank < 31, 50, 0) + if(leagueRank < 25, 25, 0) + if(leagueRank < 19, 25, 0) + if(leagueRank < 13, 50, 0) + if(leaguerank < 7, 50, 0) + if(leagueRank < 6, 50, 0) + if(leagueRank < 5, 50, 0) + if(leagueRank = 3, 100, 0) + if(leaguerank = 2, 250, 0) + if(leagueRank = 1, 450, 0))

if I change a players membership status of player, the top points (750) will be awarded according to the 1st place member of a league, (we play with non league members also) exactly what I want, EXCEpt : it only works from ranking 2 thru X (doesnt matter how many ppl play). 1st ranked player only gets 300 if i make him a league member, but any other ranking gets correct points. eg...... after I save tourney, I remove all players from the league. Any player that I chose to be back in the league (as long as he was playing that game) and hes ranked 2 through say 24, the 750 will be awarded correctly. If I make the 1rst ranked player a league member, he only gets 300. Im assuming that theres a better shorter formula, but hey this is tough stuff for me...lol and there are some very clever ppl on this forum...great software ....thanks in advance

if(inLeague, (leagueRank < 37, 25, 0) + if(leagueRank < 31, 50, 0) + if(leagueRank < 25, 25, 0) + if(leagueRank < 19, 25, 0) + if(leagueRank < 13, 50, 0) + if(leaguerank < 7, 50, 0) + if(leagueRank < 6, 50, 0) + if(leagueRank < 5, 50, 0) + if(leagueRank = 3, 100, 0) + if(leaguerank = 2, 250, 0) + if(leagueRank = 1, 450, 0))

if I change a players membership status of player, the top points (750) will be awarded according to the 1st place member of a league, (we play with non league members also) exactly what I want, EXCEpt : it only works from ranking 2 thru X (doesnt matter how many ppl play). 1st ranked player only gets 300 if i make him a league member, but any other ranking gets correct points. eg...... after I save tourney, I remove all players from the league. Any player that I chose to be back in the league (as long as he was playing that game) and hes ranked 2 through say 24, the 750 will be awarded correctly. If I make the 1rst ranked player a league member, he only gets 300. Im assuming that theres a better shorter formula, but hey this is tough stuff for me...lol and there are some very clever ppl on this forum...great software ....thanks in advance