asyamonique
Well-known Member
- Joined
- Jan 29, 2008
- Messages
- 1,284
- Office Version
- 2013
- Platform
- Windows
Good Day,
This formula works for adding a ticket for every full 1000
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"
This formula works for adding a ticket for every full 1000
Code:
[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"