Need one formula in excel
This query is : Resolved
14 December 2011
Dear all,
My question is excel related. Question is I have salary structure below;
1. Fixed Salary Rs.4000/- on 4500 entries done
2. 4501 to 7500 = 2999 entries done incentive 0.50 paisa on 2999 entries
3. If cross above 7500 then (4501 to 7501= 3000) incentive 0.75 paisa per entry instead of 0.50 paisa per entry.
4. 10000 onwards entry 0.85 paisa per entry.
I want one formula in excel to count the above.
My question is excel related. Question is I have salary structure below;
1. Fixed Salary Rs.4000/- on 4500 entries done
2. 4501 to 7500 = 2999 entries done incentive 0.50 paisa on 2999 entries
3. If cross above 7500 then (4501 to 7501= 3000) incentive 0.75 paisa per entry instead of 0.50 paisa per entry.
4. 10000 onwards entry 0.85 paisa per entry.
I want one formula in excel to count the above.
27 December 2011
Send me your mail id and I will mail you the excel file.
Also, clarify whether the incentive is to be paid on the TOTAL number of entries or only on the excess entries.
For instance, for 8000 entries, the incentive will be 8000*0.75 or (3000*0.5 + 1000*0.75)
Also, clarify whether the incentive is to be paid on the TOTAL number of entries or only on the excess entries.
For instance, for 8000 entries, the incentive will be 8000*0.75 or (3000*0.5 + 1000*0.75)
27 December 2011
My e-mail ID is "tavaspatel@yahoo.co.in"
Incentive to be paid only excess entries.
Incentive to be paid only excess entries.
28 December 2011
I have mailed you the file containing the formula.
You need to be the querist or approved CAclub expert to take part in this query .
Click here to login now
Click here to login now
Similar Resolved Queries
Unanswered Queries
- Taxable or Tax exempt
- CAPITAL GAIN BASE ON NOTIFICATION
- TDS Deducted AY-2013-14 Not Reflected in 26as
- ADVANCE PAYMENT OF ADVOCATE
- Demand Outstanding AY 2013-14 TDS Deducted not shown in 26as
- FAST-DS 2026 Under Tax Law - No recourse or support for person declaring via this scheme?
- GST rate and HSN code for sale of racing horses
- Eway bill generation from place other than registeted
- REGARDING ANNUAL RETURNS FILLINGS OF A COMPANY INCORPORATED ON 28.03.2025
- TDS Return Q1 FY 2026-27
- Goods sold but invoice not issued
- Tally: Imported bank entries do not show up in manual reconciliation
- Sales of goods of amount Rs97 lakhs to a party
- Confused About My Career After 12th — Cyber Security, AI or Finance? Need Guidance
- STATUTORY AUDIT OF A SMALL PRIVATE COMPANY INCORPORATED ON 28.03.2025
- Guidance Needed: Linking Multiple Form 26QB Payments and Responding to ITD Defaulter Notice
- How to pay remaining amount of TDS after due date?
- Resigning a auditor from the company for misconduct
- RCM @ 5% on Hamali charges, Transport Charges, Unloading charges we take ITC or not
- CALCULATION OF DEFFERED TAX - OP BL IS DTL & CURRET IT DTA
Trending Online Classes
-
DT & Audit (Exam Oriented Fastrack Batch) - For May 26 Exams and onwards Full English
CA Bhanwar Borana & CA Shubham Keswani
Subscribe to Pro
Join an elite circle of professionals
CAclubindia
