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: 197 times
Recent Topics
- Gst on hired vehicle repair maintenance
- Return defective due to turnover mismatched with I
- Ineligible ITC availed and later reversed under wr
- Temples GST HSN
- Tax filing for the belated payment credit
- Legal service RCM
- OUT OF STATE ADDITIONAL PLACE OF BUSINESS
- Excess claim and paid with DRC03
- Upload of qualified audit report on MCA portal
- Form 26QB on multiple installment
Related Threads
Trending Online Classes
-
25 Hours GST Scrutiny of Return and Notice Handling(With Recording)
Industry Expert14 February 2025 -
Survey, Search and Seizure under Income Tax Act 1961
CA Hari Agarwal
CAclubindia
