Calculating sales incentives

Excel 445 views 2 replies

Kindly help me out in creating the formula with IF function in calculating the sales incentive for different percentages of achivement against target set. I have uploaded the worksheet and requires the formula for coloumn D. The range of rates per car has been provided along with the worksheet.


Attached File : 3169 20160327131258 h promise incentive.xlsx downloaded: 123 times
Replies (2)

What Should be the Incentive if the achieved target is 70% or Less?

Pranjal, pls find attached herewith the file and formula in E5 cell.


CCI Pro

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register