fx help - add deposit amount, remove %, running balance

[STS-Thomas]

Hi,

I am playing a game and will try to assume the role of banker.

I think the easiest way for me to track numbers is via a spreadsheet formula.

each day, each member will send me a value. as banker i get to keep a 15% fee per deposit.

here are a few values for each cell:

blank cell to add the actual value each day - C3

a remaining balance after percentage, each daily deposit into one cell - C2

the percentage cut, added into another cell - C1

the actual percentage value of 15% - B1

if this makes sense, in plain english, i need a deposit cell (no formula in C3), less the percentage in B1, the percentage amount added to a final cell C1 and the principal added to C2.

Does this make sense?

All for a game - lol

Thanks,

Thomas


if i enter a value of 20, i want


Is this possible and what would the formulas look like?

[Pepe Le Mokko]

Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

[STS-Thomas]

Here is my example of a very basic spreadsheet.

bank tax is 20% and i need a cumulative total cell from all members

each member needs 2 cells. one for cumulative total and one for value entry daily

trying to keep it small on my iphone for spreadsheet display.

can this be done like i envision?

thanks,

thomas