Combing IF statements

[DctheDC]

I am trying to return a value based on a cells contents but also based on certain conditions and I cannot work out how to run two IF statements in a single formula


If Cell A1 contains "Cat" return a value of "Y" else leave blank, this I can do with =if(A1="Cat","Y","")


but I need to append an additional IF formula so if Cell A1 Contains "Dog" and Cell A2 equals "Y" then return a value of "N" else leave blank

Cheers

 

[FormR]

Hi, you can nest the second if() for example:

=IF(A1="Cat","Y",IF(A1="Dog","N",""))

 

[philwojo]

Actually I think FormR missed part of your request, try this:

=IF(A1="Cat","Y",IF(And(A1="Dog",A2="Y"),"N",""))

 

[DctheDC]

Thanks FormR

It works as per your formula but it does not include the fact I need Cell A2 to have a "Y" in it to run the Dog part of the formula to return 'N' as the value

Cheers

 

[philwojo]

seems you may have been typing when I posted, did you try my suggestion?

 

[DctheDC]

"Crossed in the post" as they say

Yes I did see it and it worked perfectly thanks Philwojo

 

[philwojo]

Glad to help and thanks for the feedback.