Forum Discussion
Mike Peebles
Jun 17, 2017Copper Contributor
Need help with a conditional formula
I need to crerate a formula that will add $100 everytime an account increases $10,000. So, basically, if I have an account with $5,000, the fee is $100. As soon as the account grows to $10,000, the f...
Dirk Becker
Jun 26, 2017Copper Contributor
Could you describe this more in detail?
Maybe making an example?
Mike Peebles
Jun 26, 2017Copper Contributor
I am working on a spreadsheet for an investment. What I want to do be able to do is start withdrawing an amount (% of monthly earnings) with the rest staying in the account to grow. But once I reach a certain amount, I want to stop having that amount increase every month with the rest staying in the account. I am attaching the spreadsheet and you can se that in 'B5', I set the cap on what I want to withdraw at $15,000/month. I want this to be so anyone who looks at this will have the ability to set this amount at any number they wish. Does this help?