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.
2 Replies
Suresh
(Learning)
(155 Points)
Replied 28 March 2016
What Should be the Incentive if the achieved target is 70% or Less?
Prodip Das
(xx)
(427 Points)
Replied 30 March 2016
Pranjal, pls find attached herewith the file and formula in E5 cell.
Attached File : 82690 20160330130812 promise incentive.xlsx downloaded: 193 times
Recent Topics
- GST RCM PAID UNDER WRONG HEAD
- Regarding E invoice amendment
- Source of money for purchase of plots 1000 sq yard
- Shops and Establishmemt
- Income Tax Refund for previous years in current ye
- TDS to individuals Tax audit Applicability
- Professional change in partnership firm
- 44ada and business code 14009
- Interest on fd gst-9
- If providing GTA services under RCM where ITC isn&
Related Threads
Trending Online Classes
-
Excel Mastery Program
CA Rishabh Pugalia
CAclubindia
