Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to determine the number of units?
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
vlookup with more than number to be retrieved | Excel Worksheet Functions | |||
Formula to determine whether number falls within range?? | Excel Worksheet Functions | |||
Formula to determine number of Standard Deviations based on % of population | Excel Worksheet Functions | |||
Count Number of Characters in a cell? | Excel Discussion (Misc queries) | |||
Need number of Saturdays and number of Sundays between 2 dates | Excel Worksheet Functions |