How to determine the number of units based on given condition?

[Guest]

Delta = 1000;
Points_______Units
0___________1
1000________2 [0+1*Delta = 1000]
3000________3 [1000+2*Delta = 3000]
6000________4 [3000+3*Delta = 6000]
10000_______5 [6000+4*Delta = 10000]
15000_______6 [10000+5*Delta = 15000]
21000_______7 [15000+6*Delta = 21000]
28000_______8 [21000+7*Delta = 28000]

f(n) = Delta*[(n-1)+(n-2)+...+(n-n)]
where n = number of units, and f(n) = the minimum points to achieve the
number of units.

Does anyone know what function in excel to determine the number of units
based on certain point levels? such as if the points are 25600 in Cell A1,
then the number of units will be 7 in Cell B1?
Thank you for any suggestion
Eric

 

[Guest]

Hello Eric,

I think you want a VLOOKUP. Am I right in thinking if I put 8000 I would get
4 and if I had 17000 I get 6? If that is right then:

You need to type the Point and Units into 2 adjacent columns in that order.
Then highlight all the Points and Units figures and press Ctrl + F3. Name the
group of cell, eg. PointsTable. (No spaces are allowed).

Type the points in cell A1 and in B1 :

=VLOOKUP(A1,PointsTable,2)

You can then copy the formula down as far as you wish.

Post back if you have any problems

Judith

 

[Biff]

See reply in .misc

Biff

 

[Guest]

Thank everyone for suggestion, could it be possible using a formula to
determine the number of units?
Thank you
Eric

Hello Eric,

I think you want a VLOOKUP. Am I right in thinking if I put 8000 I would get
4 and if I had 17000 I get 6? If that is right then:

You need to type the Point and Units into 2 adjacent columns in that order.
Then highlight all the Points and Units figures and press Ctrl + F3. Name the
group of cell, eg. PointsTable. (No spaces are allowed).

Type the points in cell A1 and in B1 :

=VLOOKUP(A1,PointsTable,2)

You can then copy the formula down as far as you wish.

Post back if you have any problems

Judith

Delta = 1000;
Points_______Units
0___________1
1000________2 [0+1*Delta = 1000]
3000________3 [1000+2*Delta = 3000]
6000________4 [3000+3*Delta = 6000]
10000_______5 [6000+4*Delta = 10000]
15000_______6 [10000+5*Delta = 15000]
21000_______7 [15000+6*Delta = 21000]
28000_______8 [21000+7*Delta = 28000]

f(n) = Delta*[(n-1)+(n-2)+...+(n-n)]
where n = number of units, and f(n) = the minimum points to achieve the
number of units.

Does anyone know what function in excel to determine the number of units
based on certain point levels? such as if the points are 25600 in Cell A1,
then the number of units will be 7 in Cell B1?
Thank you for any suggestion
Eric