Author Topic: Formula Validation Please  (Read 2109 times)

CruiseLite

  • Newbie
  • *
  • Posts: 47
    • View Profile
Formula Validation Please
« on: June 16, 2006, 07:51:31 PM »
Hi gang!

We are wanting to assign the following points:
1 point for playing
1 point for every player knocked out before you
1/2 point for every hit you give
Bonus to 1st, 2nd and 3rd positions of .3, .2 and .1 respectively times number of starting players.

Here is the formula I'm using which seems to work fine for the several tests I ran but was wondering if there is an easier or more elegant way to achieve the results.

((n-r)+1)+(if(r=1,n*.3,0)+if(r=2,n*.2,0)+if(r=3,n*.1,0))+nh*.5

Thanks for any input!!

Craig