View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
glenn glenn is offline
external usenet poster
 
Posts: 122
Default 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.