Create a function to return text if two logical functions are true

janeyt · Mar 19, 2005

How do I do this? Do I use IF and AND together???

thanks

Ken Wright · Mar 19, 2005

=IF(AND(xx=??,yy=??),"Both True","Nope")

Gary Brown · Mar 19, 2005

Yes,
=if(and(a1=true, b1=true),"It's True","Not quite there")