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?

On Sep 5, 11:42*am, sross002
wrote:
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?