Game Points Bank Account

jgthtrotih

Well-known Member
Joined
Aug 28, 2009
Messages
568
Office Version
  1. 365
Platform
  1. Windows
  2. Mobile
Hi All,
Excel Workbook
RSTUVWX
5Your PointsPoints Needed To Level UpCurrent LevelYour CreditWithdrawalDepositCredit
6
7
80You Need 18,000 Pts.IntermediateYour Credit is 0 Pts
911,5006,500BeginnerYour Credit is 0 Pts25004000
1010,4547,546BeginnerYour Credit is 454 Pts454
11125005,500BeginnerYour Credit is 1000 Pts200035001000
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

There is more info to be posted but i dont know if its helpful or not

Please ask for further questions!

Thanks!

*Row 8 is the only row to have formulas*

*Rows 9-11 are typed in to show my desired results*

Thanks!
 

Excel Facts

Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.
Hi,

Here is the point value "Ranking System" for Column T

Excel Workbook
AGAH
5Tier 1
6Beginner18000
7Beginner36000
8Beginner54000
9Intermediate72000
10Intermediate90000
11Intermediate108000
12
13Tier 2
14Advanced126000
15Advanced144000
16Advanced162000
17Expert180000
18Expert198000
19Expert216000
20
21Tier 3
22Elite234000
23Elite252000
24Elite270000
25Superior288000
26Superior306000
27Superior325000
Sheet6


Thanks!
 
Upvote 0
Any Help? even the smallest of help.

Would Be Greatly Appreciated!

Thanks!
 
Upvote 0

Forum statistics

Threads
1,221,579
Messages
6,160,616
Members
451,658
Latest member
NghiVmexgdhh

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top