excel - Multiple Criteria -

is possible use if statement multiple criteria? or best using... have tried amend question i'm looking code isnt correct in may highlight more im looking achieve.

if(a3="dog","dog green","dog blue"),matches,doesn’t match)

for reason wont let me upload picture....

any help/advice appreciated

there many ways test multiple criteria in excel. easiest either to:

use , / or boolean operaters. and(test1,test2...) checks see whether each of test1 & test2 true (can hold many arguments need). ie:

=if(and(a1="dog",b1="cat"),"there cat , dog", "there not both cat , dog") 

or(test1,test2) checks see whether either test1 true, or test2 true, or if both true. ie:

=if(or(a1="dog",b1="cat"),"there either cat, or there dog, or both","there neither cat nor dog") 

another broad option 'nest' 1 if statement inside of another. ie:

=if(a1="dog","there dog. have not checked cats",if(b1="cat","a1 not dog, , b1 cat","there neither cat nor dog")) 

if have more specific questions should update question possible details have.