banner_ad

Calculating sales incentives

Excel 527 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: 158 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  

Company
Featured 27 May 2026
Lead Conversion Executive / Sales Closing Executive

SMJ global advisors pvt ltd

New Delhi

B.Com

View Details
Company
11 May 2026
Post office

Post office

Anakapalle

Others

View Details
Company
04 June 2026
Semi Qualified CA

Goyal Puneet & Associates

New Delhi

CA Final

View Details
Company
16 May 2026
Account & Audit Asst

RAHUL KHANDEBHARAD & ASSOCIATES

Nashik

B.Com

View Details
Company
ARTICLESHIP 15 May 2026
Audit Assistant / Article Trainee / Intern

SSGS and Associates

Chennai

CA Inter

View Details
Company
19 May 2026
Article, CA & Paid Assistant Positions

Aggarwal Sarawagi and Co

New Delhi

CA

View Details
Company
Featured 26 May 2026
Account Executive

SMJ global advisors pvt ltd

New Delhi

B.Com

View Details
Company
14 May 2026
Financial Analyst - Remote Finance Expert

HiringBridge

Ahmedabad

CA

View Details