using AND Statements

[Guest]

Hi
I have AND statments in A1, and B1. In C1 I would like to use the results from these 2 cells like thi
A1 B1 C
TRUE TRUE CA
TRUE FALSE DO
FALSE TRUE DO
FALSE FALSE MOUS
What formula would I use in C1 to get this

Thanks!

 

[Frank Kabel]

Hi Wendy
try
=IF(A1*B1,"CAT",IF(A1+B1,"DOG","MOUSE"))

 

[Harald Staff]

Hi

=CHOOSE(1+A1+B1,"mouse","dog","cat")

HTH. Best wishes Harald

 

[Peo Sjoblom]

One way

=CHOOSE(A1+B1+1,"Mouse","Dog","Cat")

copy down