A little help please :)

macropod · #1 01-08-2012, 02:38 AM

To calculate the rank for a value in A1:
=INT(A1/5000)+1+(A1>=2500)

If the above formula is in B1, then the next increment is found by:
=(B1-1)*5000+(B1=1)*2500
and the % shortfall from the next increment is thus given by:
=1-A1/((B1-1)*5000+(B1=1)*2500)
whilst the % increase required to reach the next increment is thus given by:
=((B1-1)*5000+(B1=1)*2500)/A1-1
(do note that the last formula will fail if the value in A1 is 0).

hahaitwork · #2 01-08-2012, 03:29 AM

Quote:

Originally Posted by macropod

To calculate the rank for a value in A1:
=INT(A1/5000)+1+(A1>=2500)
If the above formula is in B1, then the next increment is found by:
=(B1-1)*5000+(B1=1)*2500
and the % shortfall from the next increment is thus given by:
=1-A1/((B1-1)*5000+(B1=1)*2500)
whilst the % increase required to reach the next increment is thus given by:
=((B1-1)*5000+(B1=1)*2500)/A1-1
(do note that the last formula will fail if the value in A1 is 0).

I'm sorry but I dont understand how this can find out what Rank i get next week etc?