Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
XL calculation formula | Excel Discussion (Misc queries) | |||
formula calculation | Excel Discussion (Misc queries) | |||
Calculation / Formula HELP | Excel Worksheet Functions | |||
Calculation vs formula | Excel Worksheet Functions | |||
calculation in an if formula | Excel Worksheet Functions |