Apologies
My brain is not working this Monday morning!
Can someone please help and translate the following into a formula
IF B1 CONTAINS "cat" AND c14= "CR" then display "NA",
IF B1 CONTAINS "dog" AND c9 DOES NOT CONTAIN "dog", then display "NA"
Otherwise display "1"
Many thanks
My brain is not working this Monday morning!
Can someone please help and translate the following into a formula

IF B1 CONTAINS "cat" AND c14= "CR" then display "NA",
IF B1 CONTAINS "dog" AND c9 DOES NOT CONTAIN "dog", then display "NA"
Otherwise display "1"
Many thanks