Forums Public Forums - For... General Excel Quest... Reward increasing o... Notifications Clear all Reward increasing once certain level hit General Excel Questions & Answers Last Post by Velouria 7 years ago 2 Posts 2 Users 0 Reactions 534 Views RSS Darren Hill (@dazles) Posts: 1 New Member Topic starter After a bit of help, need to do a formula where, once the total hits a certain level the rate increases. So I pay a company $50 on the first 1000 sales, then all sales after that are paid $100. Need a running total of $’s earned. Any help appreciated Posted : 10/04/2019 4:58 pm Velouria (@debaser) Posts: 841 Member Moderator The basic gist is: =MIN(sales,1000)*50+MAX(0,sales-1000)*100 Posted : 11/04/2019 9:41 am Share:
Any help appreciated