Forum Discussion
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...
you can solve it by using the modulo function like this:
=A1+100+MOD(A1;10000)*100
where 100 is your fee and cell A1 contains the value to which the fee/fees should be added to.
Thank you! 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?