Calculating sales incentives

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: 178 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.

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Company
ARTICLESHIP 16 September 2026
Article Assistant

MANUJ SHARMA AND COMPANY

Noida

CA Inter

View Details
Company
20 September 2026
Semi Qualified CA

Navin & Associates

Mumbai

CA Inter

View Details
Company
15 September 2026
Client-site CA associate

Aditya Muley and Co

Mumbai

CA

View Details
Company
30 September 2026
Senior Accounts Executive

Codeboard Technology

Chennai

MBA

View Details
Company
26 September 2026
Chartered Accountant

pushpganga ventures

Pune

CA

View Details
Company
ARTICLESHIP 21 September 2026
CA Article Assistant

KK & Company Chartered Accountant

Pune

CA Inter

View Details
Company
ARTICLESHIP 15 September 2026
Freelance Taxation Content Writer Intern

Interactive Media Pvt Ltd.

New Delhi

CA Inter

View Details
Company
30 September 2026
Senior Accountant

Codeboard Technology

Chennai

B.Com

View Details