Help with a nested IF statement containing AND and OR funtions

T

Trip

Attention smarter people:
I am taking an Excel class and they are calling for a Nested IF, AND, and OR
functions. This is the basic premise
Fulltime emplyoees with 1 or more years service are entitled to 5 days leave
fulltime employees with < 1 yr and part time employees w/ > 1.5 yrs get 3 days
this is what I have sans the OR function but I'm told I need to incoroporate
the OR??
=IF(AND([Status]="ft",[Years Employed]>=1),5,IF(AND([Status]="ft",[Years
Employed]<1),3,IF(AND([Status]="pt",[Years Employed]>1.5),3,0)))

Help
 
S

Sheeloo

Use this for the condition of second IF
OR(AND([Status]="ft",[Years Employed]<1),AND([Status]="pt",[Years
Employed]>1.5))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Nested "IF" With "And"and "OR" functions 3
need help with this formula 2
"IF" with "AND" and "OR" 10
Nested IF and AND formula 3
Nested IF function 4
Using "IF" with "AND"and "OR" function 4
Nested If/And/Or statements 4
IF, AND & OR 3

Top