software

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

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

quot;Ericquot; wrote:

gt; Delta = 1000;
gt; Points_______Units
gt; 0___________1
gt; 1000________2 [0 1*Delta = 1000]
gt; 3000________3 [1000 2*Delta = 3000]
gt; 6000________4 [3000 3*Delta = 6000]
gt; 10000_______5 [6000 4*Delta = 10000]
gt; 15000_______6 [10000 5*Delta = 15000]
gt; 21000_______7 [15000 6*Delta = 21000]
gt; 28000_______8 [21000 7*Delta = 28000]
gt;
gt; f(n) = Delta*[(n-1) (n-2) ... (n-n)]
gt; where n = number of units, and f(n) = the minimum points to achieve the
gt; number of units.
gt;
gt; Does anyone know what function in excel to determine the number of units
gt; based on certain point levels? such as if the points are 25600 in Cell A1,
gt; then the number of units will be 7 in Cell B1?
gt; Thank you for any suggestion
gt; Eric

See reply in .misc

Biff

quot;Ericquot; gt; wrote in message
...
gt; Delta = 1000;
gt; Points_______Units
gt; 0___________1
gt; 1000________2 [0 1*Delta = 1000]
gt; 3000________3 [1000 2*Delta = 3000]
gt; 6000________4 [3000 3*Delta = 6000]
gt; 10000_______5 [6000 4*Delta = 10000]
gt; 15000_______6 [10000 5*Delta = 15000]
gt; 21000_______7 [15000 6*Delta = 21000]
gt; 28000_______8 [21000 7*Delta = 28000]
gt;
gt; f(n) = Delta*[(n-1) (n-2) ... (n-n)]
gt; where n = number of units, and f(n) = the minimum points to achieve the
gt; number of units.
gt;
gt; Does anyone know what function in excel to determine the number of units
gt; based on certain point levels? such as if the points are 25600 in Cell A1,
gt; then the number of units will be 7 in Cell B1?
gt; Thank you for any suggestion
gt; Eric
Thank everyone for suggestion, could it be possible using a formula to
determine the number of units?
Thank you
Eric

quot;JudithJubileequot; wrote:

gt; Hello Eric,
gt;
gt; I think you want a VLOOKUP. Am I right in thinking if I put 8000 I would get
gt; 4 and if I had 17000 I get 6? If that is right then:
gt;
gt; You need to type the Point and Units into 2 adjacent columns in that order.
gt; Then highlight all the Points and Units figures and press Ctrl F3. Name the
gt; group of cell, eg. PointsTable. (No spaces are allowed).
gt;
gt; Type the points in cell A1 and in B1 :
gt;
gt; =VLOOKUP(A1,PointsTable,2)
gt;
gt; You can then copy the formula down as far as you wish.
gt;
gt; Post back if you have any problems
gt;
gt; Judith
gt;
gt; quot;Ericquot; wrote:
gt;
gt; gt; Delta = 1000;
gt; gt; Points_______Units
gt; gt; 0___________1
gt; gt; 1000________2 [0 1*Delta = 1000]
gt; gt; 3000________3 [1000 2*Delta = 3000]
gt; gt; 6000________4 [3000 3*Delta = 6000]
gt; gt; 10000_______5 [6000 4*Delta = 10000]
gt; gt; 15000_______6 [10000 5*Delta = 15000]
gt; gt; 21000_______7 [15000 6*Delta = 21000]
gt; gt; 28000_______8 [21000 7*Delta = 28000]
gt; gt;
gt; gt; f(n) = Delta*[(n-1) (n-2) ... (n-n)]
gt; gt; where n = number of units, and f(n) = the minimum points to achieve the
gt; gt; number of units.
gt; gt;
gt; gt; Does anyone know what function in excel to determine the number of units
gt; gt; based on certain point levels? such as if the points are 25600 in Cell A1,
gt; gt; then the number of units will be 7 in Cell B1?
gt; gt; Thank you for any suggestion
gt; gt; Eric