Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 | |
|
|
![]() |
||||
Thread | Forum | |||
count duplicate (or, inversely, unique) entries, but based on a condition | Excel Worksheet Functions | |||
Subtracting based on number of miles | Excel Discussion (Misc queries) | |||
Dynamic Column VlookUps Based on Week Number | Excel Worksheet Functions | |||
EZ Q 4 U: How do I change a number to text, based on the number | Excel Worksheet Functions | |||
returning a text cell based on a number cell | Excel Worksheet Functions |