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
Please post this in the excel community as this is not related to Microsoft Teams.
Kind regards,
Mitchell Bakker