View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
FLATRATE FLATRATE is offline
external usenet poster
 
Posts: 3
Default A UNIQUE FORMULA

EXAMPLE: I want to multiply one cell with a dollar amount in it, by a cell
that has a quantity of employees in it. I want the dollar amount to remain
the same for the first two employees and only increase after the 3rd employee
is entered. If the amount is $4000, I want it to remain at $4000 until the
3rd employee is entered making it $8000 and then each additional employee
would add $4000. 10 employees would be $36,000. Can it be done? Appreciate
any help.