How do I do this? Do I use IF and AND together???
thanks
How do I do this? Do I use IF and AND together???
thanks
=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" <[email protected]> wrote in message
news:[email protected]...
> How do I do this? Do I use IF and AND together???
>
> thanks
Yes,
=if(and(a1=true, b1=true),"It's True","Not quite there")
"janeyt" <[email protected]> wrote in message
news:[email protected]...
> How do I do this? Do I use IF and AND together???
>
> thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks