Thread: If function
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
potsie
 
Posts: n/a
Default If function

I have a new problem, how do I type the If formula for this one
the formula is to calculate 401K contributions for employees. The formula
should determine the number of years employed in column C is greater than or
equal to 1, then the contributions is equal to the contribution percentage of
3% located in column F4 multiplied by the employee salary in column D,
otherwise the contribution is zero.