I wish to increase commission of a person by 1000 with every increase in sales by 100000 after a certain point
eg
if sales is >=14k, commission is 3k
with every increase in sales by 1 k going fowd , commission increase by 1k so for eg if sales is 15 k , commission will be 4k and so on so forth. can anyone help create a formula for this
Attach A File.jpgAttach Sample Excel File with details and sample result
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
will do once solved . DO you need a sample file ?
Attach sample file with details sales and commissions structure details
here is the sample file
B2=IF(A2<140000,0,3000+FLOOR(A2-140000,10000)*0.1)
OR
B2=IF(A2<140000,0,3000+INT((A2-140000)/10000)*1000)
Try the above copy towards down
or another way...
=IF(A1<=140000,3000,3000+1000*ROUNDDOWN((A1-140000)/10000,0))
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
Thanks a lot it works marking as solved
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks