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. |
All times are GMT +1. The time now is 12:28 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com