Forum Discussion
how to write Formula in excel
Hi, I need help regarding excel formula for incremental bonus value. Example: fix bonus is 1000 any Qtr x if 1st Qtr target fulfilment is more than 100 then x person get Rs.3000/-in 1st Qtr if ...
in other words
Fixed Incentive Quarterly Incremental Incentive Quarterly Increased
Earning
Q1 > 100% | Rs.1000 | Q1 > 100% | Rs.1000 | Nil |
Q2> 100% | Rs.1000 | Q2> 100% | Rs.1500 | Rs. 500 |
Q3> 100% Q4> 100% | Rs.1000 Rs.1000 | Q3> 100% Q4> 100% | Rs.2250 Rs. 3250 | Rs. 1250 Rs.2250 |
Thanks in advance
- Hi Prashant,
Please post this in the excel community as this is not related to Microsoft Teams.
Kind regards,
Mitchell Bakker
