IF OR AND in same conditional formula

[chrono2483]

Hi There,

Does excel accept OR & AND within the same if statement?

I'm trying to state the following: =IF(OR($A$2="YES",$A$2="MAYBE",AND($A$4="English"),"Level 1",""))

Would anyone be able to provide a sample of an IF statement using OR & AND?

Thank you!

 

[snjpverma]

Is this what you are after ?

=IF(AND(OR($A$2="YES",$A$2="MAYBE"),$A$4="English"),"Level 1","")

P.S. whenever you ask a question, describe it in words because the wrong formula won't be helpful in knowing what exactly you want.

 

[chrono2483]

Is this what you are after ?

=IF(AND(OR($A$2="YES",$A$2="MAYBE"),$A$4="English"),"Level 1","")

P.S. whenever you ask a question, describe it in words because the wrong formula won't be helpful in knowing what exactly you want.

Great, thank you snjpverma - that example worked! (And will remember to describe the ask in words too! )

 

[snjpverma]

Glad to see it working for you