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