Forum Discussion
Deleted
Dec 15, 2017calculating a sliding scale percentage based on value of a sum
for one of my customers I need to return a rebate on sales. however we have two sales funnels to consider and the rebate amount is a sliding scale based on total sales. I need to sum 2 cells and dep...
SergeiBaklan
Dec 16, 2017MVP
As variant
=LOOKUP(A1,{-1,500000,1000000,2000000},{0,0.05,0.06,0.07})
and added to Peters' file