Calculating sales incentives

Pranjal (Student CA IPC / IPCC) (531 Points)

27 March 2016  

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.