Hi!

Build a 2 column table like the one you've posted that lists the points in
the left column and the units in the right column.

Assume this table is in the range A6:B13 eith A5 and B5 being the headers
Points, Units.

A1 = 25600

B1 = formula:

=IF(A1="","",VLOOKUP(A1,A6:B13,2))

Biff

"Eric" wrote in message
...
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