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
- Post Office RD Interest
- CG Tax On residential property
- Applicable TDS for Purchase of Flat from NRI
- Eway bill for machinery reparing
- Building and other construction workers welfare cess act 1996
- ITR 3 FILING OF AN INDIVIDUAL (PARTNER IN A PARTNERSHIP fIRM)
- Bank Accounts in Balance Sheet for ITR 3
- Form 10BD Filling
- NRI ITR2 account in 2025-26 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,.
- Annual return of gst limit
- ESIC- Employee Registration
- Delisted shares sold in off market/ Rebate u/s87A
- In Exports Sales HSN details where to fill
- Opting out" of regime provided under subsection (1A) of Section 115BAC but Form 10IEA is not filed.
- Difference in tax comparison report
- Gst invoice numbering and delivery challan numbering
- Sales amount in Gstr1
- E Commerce GSTR1 & 3B how to file
- GST Cancellation without jurisdiction
- Legal Opinion on Registrar's Refusal to Investigate a Society for Non-Renewal and Non-Compliance
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
