Formula Help

S

sross002

I am building a ledger for finanacial transactions.

I have Windows, Office Professional 2003.

Each individual has $50 to spend. Once the $50 threshold is spent their
transactions double in price.

Ex) If I use $50 one one transaction. My limit is reached.
Then I spend $10 the next week but it's doubled to $20 because it's doubled
once the limit of $50 is reached.

For now the formula I have is (=50-A1)
*Cell A1 represents the total of their transactions.
I just need to compute a formula that will double what I put in a cell once
$50 is reached.

How can I double the transactions after the $50 threshold is reached?

Thank you in advance.






Can someone please help me with a formula for this?
 
R

Reeza

I am building a ledger for finanacial transactions.

I have Windows, Office Professional 2003.

Each individual has $50 to spend.  Once the $50 threshold is spent their
transactions double in price.

Ex) If I use $50 one one transaction.  My limit is reached.
Then I spend $10 the next week but it's doubled to $20 because it's doubled
once the limit of $50 is reached.

For now the formula I have is (=50-A1)
*Cell A1 represents the total of their transactions.
I just need to compute a formula that will double what I put in a cell once
$50 is reached.

How can I double the transactions after the $50 threshold is reached?

Thank you in advance.

Can someone please help me with a formula for this?

What happens if a transaction goes from 40 to say 65 in a transaction?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top