Formula to create points

[asyamonique]

Good Day,
This formula works for adding a ticket for every full 1000

[COLOR=#333333]=IF(A1<=1000,INT(A1/100),10+INT((A1-1000)/1000))[/COLOR]

Is it possible to change above formula base on below rules?
Many Thanks

Every 100= 1point
Between 100 to 1.000= 10point
Every 1,000= 1point
Between 1.000 to 10.000= 10point
Every 10.000= 1point
Between 10.000 to 100.000= 10point
Every 100.000= 1point

Sample:
345600= "3+4+5+6+30= 48 point"
54700= "5+4+7+20= 36 point"
6700= "6+7+10= 23 point"

 

[Legacy 143009]

Ok, could you please provide me all the points range from 0 to 21 like:
0 = 0-999
10 = 1000-1999
11 = 2000-2999
.
.
20 = 11000-14999
21 = 15000-19999

 

[asyamonique]

0	0-999
11	1000-1999
12	2000-2999
13	3000-3999
14	4000-4999
15	5000-5999
16	6000-6999
17	7000-7999
18	8000-8999
19	9000-9999
20	10000-14999
21	15000-19999
22	15000-24999

<colgroup><col><col></colgroup><tbody>
</tbody>

Sorry,
I should give more details.
Cheers.

 

[Legacy 143009]

0	0-999
11	1000-1999
12	2000-2999
13	3000-3999
14	4000-4999
15	5000-5999
16	6000-6999
17	7000-7999
18	8000-8999
19	9000-9999
20	10000-14999
21	15000-19999
22	15000-24999

<colgroup><col><col></colgroup><tbody>
</tbody>

Sorry,
I should give more details.
Cheers.

Ok. No 10 points, then..
=if(a1<1000,0,if(a1<10000,11+floor((a1-1000)/1000,1),20+floor((a1-10000)/5000,1)))

 

[asyamonique]

Thats perfect it works very well.
If you don't mind incase I needed could you please give me one more if I'm going to consider 100's as 1point each?
so every 100 will be 1 point "0-999=1point"
Many Thanks

 

[Legacy 143009]

Again your logic is wrong. If every 100 will be 1 point then;
0-99=0
100-199=1
200-299=2
300-399=3
400-499=4
500-599=5
600-699=6
700-799=7
800-899=8
900-999=9

Or;

0-999 only 1 point?!

 

[asyamonique]

Yes,
Please.

100	199	1
200	299	2
300	399	3
400	499	4
500	599	5
600	699	6
700	799	7
800	899	8
900	999	9

<colgroup><col width="64" span="3" style="width:48pt"> </colgroup><tbody>
</tbody>

 

[Legacy 143009]

Yes,
Please.

100	199	1
200	299	2
300	399	3
400	499	4
500	599	5
600	699	6
700	799	7
800	899	8
900	999	9

<colgroup><col width="64" span="3" style="width:48pt"> </colgroup><tbody>
</tbody>

And again no 10 points?!

 

[Legacy 143009]

OK try;
=IF(A1<1000,FLOOR(A1/100,1),IF(A1<10000,11+FLOOR((A1-1000)/1000,1),20+FLOOR((A1-10000)/5000,1)))

There will be no 10 points.

 

[asyamonique]

Thats great...
So the limit is till 100.000
Can we put up to 500.000 wich after 100.000 every 10.000 will be considered 1 point.
With last formula the result is below:
100,000 = 38
120,000 = 42

I want and that will be the last request

39 Point	100.000-109.999
40 Point	110.000-119.999
41 Point	120.000-129.999

<colgroup><col span="2"></colgroup><tbody>
</tbody>

Cheers,

 

[Legacy 143009]

Thats great...
So the limit is till 100.000
Can we put up to 500.000 wich after 100.000 every 10.000 will be considered 1 point.
With last formula the result is below:
100,000 = 38
120,000 = 42

I want and that will be the last request

39 Point	100.000-109.999
40 Point	110.000-119.999
41 Point	120.000-129.999

<tbody>
</tbody>

Cheers,

=IF(A1<1000,FLOOR(A1/100,1),IF(A1<10000,11+FLOOR((A1-1000)/1000,1),IF(A1<100000,20+FLOOR((A1-10000)/5000,1),39+FLOOR((A1-100000)/10000,1))))

Byeee