ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Calculation formula (https://www.excelbanter.com/excel-worksheet-functions/187532-calculation-formula.html)

glenn

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