Masters of Excel please help. urgent
For example
Salary = 7000
Break evn point =7000*3
Let incentive earn=500000
The incentive has to be passed with this 3 stages.
Stage1
63,000-1.00Lac=17%
Stage2
1.00-1.50Lac=22% of remained amount
Stage3
1.50L -Above = 27% of remained amount
Pls suggest the formula for excel.
for further
Pls contact 9977266555.
please contact so that i can further explain
From India, Bhopal
9For example
Salary = 7000
Break evn point =7000*3
Let incentive earn=500000
The incentive has to be passed with this 3 stages.
Stage1
63,000-1.00Lac=17%
Stage2
1.00-1.50Lac=22% of remained amount
Stage3
1.50L -Above = 27% of remained amount
Pls suggest the formula for excel.
for further
Pls contact 9977266555.
please contact so that i can further explain
From India, Bhopal
Community Support and Knowledge-base on business, career and organisational prospects and issues - Register and Log In to CiteHR and post your query, download formats and be part of a fostered community of professionals.
EXCEL FORMULA.xls