Forum Discussion

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

Yury Tokarev

Iron Contributor

Jun 17, 2017

Hi Mike,

if you had the account balance in C2, incremental fee base (10,000) in C3, incremental fee in C4, then your can use the formula =ROUNDUP((C2+0.01)/C3,0)*C4

Thanks

Yury

Mike Peebles

Copper Contributor

Jun 17, 2017

Thank you so much - heading to the spreadsheet now!