need help with this formula

A

AET

im needing an AND and OR function to get this to work right. i have it
working almost but it is not showing any 0 answers. im sure the OR functionj
is medded up. if

=IF(AND(Leave[[#This Row],[Status]]="FT",Leave[[#This Row],[Years
Employed]]>=1),5,IF(AND(Leave[[#This Row],[Status]]="FT",Leave[[#This
Row],[Years Employed]]<1),3,IF(OR(Leave[[#This Row],[Status]]="PT",
Leave[[#This Row],[Years Employed]]>1.5),3,0)))
 
F

Francis

Hi
would you post a sample of your data and the result you want

--
Hope this is helpful

Pls click the Yes button below if this post provide answer you have asked

Thank You

cheers, francis

Am not a greek but an ordinary user trying to assist another
 
S

Sheeloo

You are right...
Change the OR to AND

With what you have ALL with Status = "PT" will get 3
also ALL with Years Emplyed > 1.5 will get 3
 

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

"IF" with "AND" and "OR" 10
Help with a nested IF statement containing AND and OR funtions 1
MS Project Import Error Row 1 Column 5 2
Template with fields and premade texts.. 0
IF, AND & OR 3
Nested IF and AND formula 3
Using "IF" with "AND"and "OR" function 4
DSUM function 8

Top