How to use AND Function in excel

How to use AND Function in excel2018-11-19T11:23:25+00:00
Content Protection by DMCA.com

3 Comments

  1. henry 14 Nov, 18 at 3:15 am - Reply

    Hi Puneet, what is the syntax if A2 is blank and B2=”apple” then put “blank apple” in C2

  2. David González 30 Mar, 16 at 11:08 am - Reply

    Exactly, you can use … =if(or(a=b;b=c;c=x);true;false) or =if(and(a=b;b=c;c=x);true;false)

    • Puneet Gogia 30 Mar, 16 at 11:14 am - Reply

      Right David.

Leave A Comment