help me for the salecommision formula

[binoyfalcon]

commision based on daily sale, <100=nil,>101 <125=.25,>125<150=0.50,>150=1.00, but in some area(route) they will get double commision,(>125=2.00,>15=3.00) sale entry in same cell commision value only change how its work?


day1 day2 day3 commision

suresh 200 150 120 15.00

martin 190 200 187 10.00

thomas 150 500 157 50.00

ram 100 100 200 25.00

angiel 125 152 500

sam 101 105 300

 

[dan_l]

You may need to post sample data. I get the first part, the second part I'm not getting "but in some area(route) they will get double commision,(>125=2.00,>15=3.00) sale entry in same cell commision value only change how its work?"

 

[SirJB7]

Hi, binoyfalcon!

Would you explain in detail how did to get each value of the commission of your example?

Regards!