Forum Discussion

Mike Peebles's avatar
Mike Peebles
Copper Contributor
Jun 17, 2017

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...
excel
Formulas and Functions
office 365
Mike Peebles's avatar
Mike Peebles
Copper Contributor
Jun 23, 2017

Thank you! This worked PERFECTLY!!! I am also in need of help with another formula. Basically I have a number that increases every month based on using 50% of another increasing number - but I need the final number to stop once it meets a certain level with the rest then remaining in the first number. Any ideas?

  • Dirk Becker's avatar
    Dirk Becker
    Copper Contributor
    Jun 26, 2017

    Could you describe this more in detail?

    Maybe making an example?

    • Mike Peebles's avatar
      Mike Peebles
      Copper Contributor
      Jun 26, 2017

      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?

Resources