Need one formula in excel

This query is : Resolved

Navin M Patel (Querist)
Follow

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.

CA Siddhartha Bhardwaj

CA Siddhartha Bhardwaj (Expert)
Follow

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)

Navin M Patel

Navin M Patel (Querist)
Follow

27 December 2011 My e-mail ID is "tavaspatel@yahoo.co.in"

Incentive to be paid only excess entries.

CA Siddhartha Bhardwaj

CA Siddhartha Bhardwaj (Expert)
Follow

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

Join the CA Students WhatsApp Community for ICAI Updates, Trending Courses & Notes!

Similar Resolved Queries

Unanswered Queries

Popular
Recent

Trending Online Classes

Direct Tax Laws & International Taxation May 26,Sept 26 & Jan 27

CA Arvind Tuli

Enroll Now
Audit Fast Track Recorded Batch For May 26,Sept 26 & Jan 27

CA Aarti Lahoti

Enroll Now
DT & Audit (Exam Oriented Fastrack Batch) - For May 26 Exams and onwards Full English

CA Bhanwar Borana & CA Shubham Keswani

Enroll Now

view all classess

Meet our CAclubindia PRO Members

RAGHUNATH KASIBHOTLA

raval umesh

Rameshkumar Jain

DSK TMC

Hemkumar

Subscribe Now

Need one formula in excel

Similar Resolved Queries

Trending Online Classes

Meet our CAclubindia PRO Members

Quick Links

Browse by Category

Latest Job Openings

Senior Executive

Manager- Finance and Compliance

GST CONSULTANT

GST CONSULTANCY

Accountant

CA Final

Article Assistant

Associate CA