Forum

Notifications
Clear all

Reward increasing once certain level hit

2 Posts
2 Users
0 Reactions
53 Views
(@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
(@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: