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

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Create a function to return text if two logical functions are true (https://www.excelbanter.com/excel-worksheet-functions/18427-create-function-return-text-if-two-logical-functions-true.html)

janeyt

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

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

thanks

Ken Wright

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

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

"janeyt" wrote in message
...
How do I do this? Do I use IF and AND together???

thanks

Gary Brown

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

"janeyt" wrote in message
...
How do I do this? Do I use IF and AND together???

thanks

All times are GMT +1. The time now is 02:08 PM.