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.