Thread: Using "IF" with "AND"and "OR" function
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Richard Freist Richard Freist is offline
external usenet poster
  
Posts: 10
Default Using "IF" with "AND"and "OR" function
A company has both full time and part time employees and fulltime employees
recieve 5 days family leave if they have been employed for 1 year or more,
oterwise they get 3 days. Part time employees recieve 3 days if employed 2
years or more. How can I construct a single formula incorporating both full
time and part time employees?
--
Frustrated
Reply With QuoteReply With Quote