jgthtrotih
Well-known Member
- Joined
- Aug 28, 2009
- Messages
- 568
- Office Version
- 365
- Platform
- Windows
- Mobile
Hi All,
i have a "Game Points Bank Account" that keeps track of the points users earn or spend in the game...what i need help is creating a running total for the bank..ive tried everything nothing works..
(this is actually like a traditional bank account)
each player starts with 10,000 points
*Row 8 is the only row to have formulas*
*Rows 9-11 are typed in to show my desired results*
Here is the point value "Ranking System" for Column T
Please ask for further questions!
Thanks!
Excel Workbook | |||||||||
---|---|---|---|---|---|---|---|---|---|
R | S | T | U | V | W | X | |||
5 | Your Points | Points Needed To Level Up | Current Level | Your Credit | Withdrawal | Deposit | Credit | ||
6 | |||||||||
7 | |||||||||
8 | 0 | You Need 18,000 Pts. | Intermediate | Your Credit is 0 Pts | |||||
9 | 11,500 | 6,500 | Beginner | Your Credit is 0 Pts | 2500 | 4000 | |||
10 | 10,454 | 7,546 | Beginner | Your Credit is 454 Pts | 454 | ||||
11 | 12500 | 5,500 | Beginner | Your Credit is 1000 Pts | 2000 | 3500 | 1000 | ||
Sheet6 |
i have a "Game Points Bank Account" that keeps track of the points users earn or spend in the game...what i need help is creating a running total for the bank..ive tried everything nothing works..
(this is actually like a traditional bank account)
each player starts with 10,000 points
*Row 8 is the only row to have formulas*
*Rows 9-11 are typed in to show my desired results*
Here is the point value "Ranking System" for Column T
Excel Workbook | ||||
---|---|---|---|---|
AG | AH | |||
5 | Tier 1 | |||
6 | Beginner | 18000 | ||
7 | Beginner | 36000 | ||
8 | Beginner | 54000 | ||
9 | Intermediate | 72000 | ||
10 | Intermediate | 90000 | ||
11 | Intermediate | 108000 | ||
12 | ||||
13 | Tier 2 | |||
14 | Advanced | 126000 | ||
15 | Advanced | 144000 | ||
16 | Advanced | 162000 | ||
17 | Expert | 180000 | ||
18 | Expert | 198000 | ||
19 | Expert | 216000 | ||
20 | ||||
21 | Tier 3 | |||
22 | Elite | 234000 | ||
23 | Elite | 252000 | ||
24 | Elite | 270000 | ||
25 | Superior | 288000 | ||
26 | Superior | 306000 | ||
27 | Superior | 325000 | ||
Sheet6 |
Please ask for further questions!
Thanks!