Multiple If/then Statement Formula

[squeakums]

I need to have a field mark as "Yes" if e6 is =yes, and if not, if f6 is = yes and y6 is = direct, or if z6 = yes, or if aa6 is = yes

So, saying if e6 is yes, then yes, otherwise if f6 is yes and the fields y6, either equals direct, or z6 equals yes or aa6 equals yes. Is it possible to write this type of if/then statement in one formula? Otherwise if none of them meet the parameters, then the field is "No".

Thank you.

 

[Nine Zero]

Re: Multiple If/then Statement Formula Help

try this out

=IF(E6="yes","yes",IF(AND(F6="yes",Y6="direct"),"yes",IF(OR(Z6="yes",AA6="yes"),"yes","no")))

 

[squeakums]

Re: Multiple If/then Statement Formula Help

Almost works how I need it, thank you for sending.

I need it to be if e8= "yes", "Yes", if not, if f8= "yes", and v8 = "direct" then yes, otherwise, if f8 = "yes" and w8 is also "yes" then "yes", or if f8 = "yes", and x8 is "yes", then yes, otherwise, "No" I tried to write below but it isn't working right. Could you please help? Thanks so much

=IF(E8="yes","Yes",IF(AND(F8="yes",V8="direct"),"Yes",IF(OR(F8="yes",w8="yes"),"Yes",(F8="yes",x8="yes"),"Yes","No")))

 

[Joe4]

Re: Multiple If/then Statement Formula Help

[COLOR=#333333]=IF(E8="yes","Yes",IF(AND(F8="yes",V8="direct"),"Yes",IF(OR(F8="yes",w8="yes"),"Yes",[/COLOR][COLOR=#ff0000](F8="yes",x8="yes"),"Yes","No")[/COLOR][COLOR=#333333]))[/COLOR]

You have an issue with the part in red. You are missing your IF(AND or IF(OR part before that.

 

[Nine Zero]

Re: Multiple If/then Statement Formula Help

Yeah like @Joe4 said above, you are missing the AND statement

=IF(E8="yes","Yes",IF(AND(F8="yes",V8="direct"),"Yes",IF(OR(F8="yes",w8="yes"),"Yes",[COLOR=#ff0000]IF(AND[/COLOR](F8="yes",X8="yes"),"Yes","No")))

I put AND according to your statement in post number 3