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