Masters of Excel, please help. This is urgent.
For example:
Salary = 7000
Break-even point = 7000*3
Let incentive earn = 500000
The incentive has to be passed through these 3 stages:
Stage 1
63,000 - 1.00 Lac = 17%
Stage 2
1.00 - 1.50 Lac = 22% of the remaining amount
Stage 3
1.50 Lac and above = 27% of the remaining amount
Please suggest the formula for Excel.
For further assistance, please contact 9977266555. Please contact so that I can further explain.
From India, Bhopal
Acknowledge(0)
Amend(0)
9For example:
Salary = 7000
Break-even point = 7000*3
Let incentive earn = 500000
The incentive has to be passed through these 3 stages:
Stage 1
63,000 - 1.00 Lac = 17%
Stage 2
1.00 - 1.50 Lac = 22% of the remaining amount
Stage 3
1.50 Lac and above = 27% of the remaining amount
Please suggest the formula for Excel.
For further assistance, please contact 9977266555. Please contact so that I can further explain.
From India, Bhopal
Acknowledge(0)Amend(0)
Madam,
I will help. Please clarify the points below:
1. What is Break Even Point?
2. What does it mean - 3 months or years?
3. The stages you have mentioned in [%], are they standard or subject to change?
4. How can we identify the values mentioned in the stages?
Thank you.
From India, Hyderabad
Acknowledge(0)Amend(0)
I will help. Please clarify the points below:
1. What is Break Even Point?
2. What does it mean - 3 months or years?
3. The stages you have mentioned in [%], are they standard or subject to change?
4. How can we identify the values mentioned in the stages?
Thank you.
From India, Hyderabad
Acknowledge(0)Amend(0)Join Our Community and get connected with the right people who can help. Our AI-powered platform provides real-time fact-checking, peer-reviewed insights, and a vast historical knowledge base to support your search.
EXCEL FORMULA.xls