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 6 years ago 2 Posts 2 Users 0 Reactions 53 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: 837 Member Moderator The basic gist is: =MIN(sales,1000)*50+MAX(0,sales-1000)*100 Posted : 11/04/2019 9:41 am Share: Super Globals Requests: Server: Options and Features route: excel-forum use_home_url: url: https://www.myonlinetraininghub.com/excel-forum pageid:87422 default_groupid: 3 2022
Any help appreciated