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"

 

[asyamonique]

1400=10
2400=12
5400=15

Should be,

 

[Legacy 143009]

1400=10
2400=12
5400=15

Should be,

Also here why you added2? Only 1 times 5000 added?! When should it be 20?
[TABLE="class: cms_table, width: 368"]
<tbody>[TR]
[TD]10000=[/TD]
[TD]19[/TD]
[TD]Increase 1 for every 1000 after 1000[/TD]
[/TR]
[TR]
[TD]15000=[/TD]
[TD]21[/TD]
[TD]Increase 1 for every 5000 after 10000[/TD]
[/TR]
</tbody>[/TABLE]

 

[Legacy 143009]

Is this ok?

=IF(A1>1400,IF(A1>10000,20+FLOOR((A1-10000)/5000,1),11+FLOOR((A1-1400)/1000,1)),10)

 

[asyamonique]

OK,
Lets clear this,

When the values increased the given prome tickets will reduce.For me important first 10000.Thats the reason!
Like below sample:

It starts from 1000
so if 1000 total points 10
if 1400 still 10
if 2000 (1000 was 10 + 2*100 = 12)
if 5400(10+ "5*1000" = 15)
So after 10.000 for every 5.000 is 1 point..If 17000: "for 1000=10 + for "10.000=10" + "for 5000=1" so total earned points are 21
Hope its clear now

 

[asyamonique]

[COLOR=#333333]=IF(A1>1400,IF(A1>10000,20+FLOOR((A1-10000)/5000,1),11+FLOOR((A1-1400)/1000,1)),10)[/COLOR]

My last sample was a bit late then your post but thats quite ok for me.
Cheers.
Sorry for keeping you busy.

 

[Legacy 143009]

OK,
Lets clear this,

When the values increased the given prome tickets will reduce.For me important first 10000.Thats the reason!
Like below sample:

It starts from 1000
so if 1000 total points 10
if 1400 still 10
if 2000 (1000 was 10 + 2*100 = 12)
if 5400(10+ "5*1000" = 15)
So after 10.000 for every 5.000 is 1 point..If 17000: "for 1000=10 + for "10.000=10" + "for 5000=1" so total earned points are 21
Hope its clear now

Have a nice day

=IF(A1>1400,IF(A1<10000,11+FLOOR((A1-1400)/1000,1),20+FLOOR((A1-10000)/5000,1)),10)

 

[asyamonique]

Can we prevent to issue the points below 1000?
if 1000 = 10
if 900 = 0

 

[Legacy 143009]

can we prevent to issue the points below 1000?
If 1000 = 10
if 900 = 0

=if(a1<1000,0,if(a1<10000,10+floor((a1-1000)/1000,1),20+floor((a1-10000)/5000,1)))

I am not in front of the computer but I think this should work.

 

[asyamonique]

Below 1000 corrected
But, others changed
Should be;
if 2000 (1000 was 10 + 2*100 = 12)
if 5400(10+ "5*1000" = 15)

Became;
2000=11
3000=12
5000=14

 

[Legacy 143009]

Below 1000 corrected
But, others changed
Should be;
if 2000 (1000 was 10 + 2*100 = 12)
if 5400(10+ "5*1000" = 15)

Became;
2000=11
3000=12
5000=14

Your logic setup is wrong. Then howcome 11 can be possible?