### Author Topic: Easy point formula help  (Read 186 times)

#### theeatbob

• Newbie
• • Posts: 12 ##### Easy point formula help
« on: April 26, 2018, 12:08:39 PM »
I don't know the first thing about setting up a points formula. I just need a formula that will give

21-24 = 0 pts
17-20 = 1 pt
13-16 = 3 pts
9-12   = 5 pts
5-8    =  7 pts
1-4    = 10 pts

Thanks for any help

Keith

#### efdenny

• Full Member
•   • Posts: 141 ##### Re: Easy point formula help
« Reply #1 on: April 26, 2018, 01:51:53 PM »
I'll take an attempt at this one:

if((r >= 17) and (r <= 20), 1) + if((r >= 13) and (r <= 16), 3) + if((r >= 9) and (r <= 12), 5) if((r >= 5) and (r <= 8 ), 7) + if((r >= 1) and (r <= 4), 10)

I'm sure there's an easier/cleaner way, but this should do the trick.

#### theeatbob

• Newbie
• • Posts: 12 ##### Re: Easy point formula help
« Reply #2 on: April 26, 2018, 02:33:01 PM »
That formula came up with errors.

#### theeatbob

• Newbie
• • Posts: 12 ##### Re: Easy point formula help
« Reply #3 on: April 26, 2018, 02:35:20 PM »
How can ido something like:
24th=0
23=0
22=0
21=0
20=1
19=1
18=1
etc.
I don't mind having to put in the value 24 times. I just don't know how to make a rank equal a certain point total. I'm sure it's easy I just don't know how.

Keith

#### efdenny

• Full Member
•   • Posts: 141 ##### Re: Easy point formula help
« Reply #4 on: April 26, 2018, 03:49:10 PM »
That formula came up with errors.

Sorry, typo... here's the corrected formula.

if((r >= 17) and (r <= 20), 1) + if((r >= 13) and (r <= 16), 3) + if((r >= 9) and (r <= 12), 5) + if((r >= 5) and (r <= 8 ), 7) + if((r >= 1) and (r <= 4), 10)

#### efdenny

• Full Member
•   • Posts: 141 ##### Re: Easy point formula help
« Reply #5 on: April 26, 2018, 03:52:05 PM »
for specifying which rank gets which points, use "switch". No need to specify "0" points. As per your example:

switch(r,18,1,19,1,20,1)

But, in this instance, I think my previous post is easier.

#### theeatbob

• Newbie
• • Posts: 12 ##### Re: Easy point formula help
« Reply #6 on: April 26, 2018, 05:22:01 PM »
Thank you very much.

Keith