snowsurfer
New Member
- Joined
- Feb 15, 2002
- Messages
- 18
I was helped in other posts create a formula that evaluates your finish in a race and assigns points based on finish. Well I have run into a road block
We award points down to 20th place. I calculate it using the following code
That works great. We also assign BUMP points that tells us when a racer needs to be moved to the next level of competition. You get 3 points for 1st, 2 for 2nd, and 3 for third. When I evaulate the finish and they got 4th or higher than the #VALUE is returned. This is the code I am using. How can I hide the #VALUE error if they get 4th or higher?
Should I just extend the code out like this
We a
We award points down to 20th place. I calculate it using the following code
Code:
=IF(N43="","",CHOOSE(N43,25,22,20,18,16,15,14,13,12,11,10,9,8,7,6,5,4,3,2,1))
That works great. We also assign BUMP points that tells us when a racer needs to be moved to the next level of competition. You get 3 points for 1st, 2 for 2nd, and 3 for third. When I evaulate the finish and they got 4th or higher than the #VALUE is returned. This is the code I am using. How can I hide the #VALUE error if they get 4th or higher?
Code:
=IF(N43="","",CHOOSE(N43,3,2,1))
Should I just extend the code out like this
Code:
=IF(N43="","",CHOOSE(N43,3,2,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0))
We a