And & Or Statement Assistance

[Disarmonious]

I need cell Z8 to equal "1" if cell C8 = "Dog" or 'Cat" and H8 = "Animal". If not, then cell Z8 = "0"

 

[Fluff]

What version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

How about

=IF(AND(H8="animal",OR(C8={"dog","cat"})),1,0)

 

[Disarmonious]

What version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

How about

=IF(AND(H8="animal",OR(C8={"dog","cat"})),1,0)

Thank you, Fluff. I appreciate your response and have updated my Excel version in Account Details. Have a good day! Thanks again!

 

[Fluff]

You're welcome & thanks for the feedback.