Calculation formula
I am trying to create a formula to calculate quaterly bonus for my employees.
1. Suposse a person has earned $200 for the Qtr for meeting the company
standards but this doubles if they meet the controllable income of 40% for
each month in the quarter. If one or more months fall below 40% they only
qualify to get $200 for meeting the standards.
I am not that good at excel so pls if it can be possible to give me formula
explaining step by step.
I would be really grateful for this help from any one.
|