It is used if All  of 2 or more conditions fulfilled ,there is separate value

and

if not fulfilled,there is separate value

 

=if(AND(Condition1,Condition 2),Yes value,No Value)

 

Example 1

If + And Command - If Command

  Download Excel File And Try

 

Example 2

 

 

Example 3

  1. Accounts Tax
  2. Excel
Ask Download

About the Author

CA Maninder Singh's photo - Expert in Practical Accounts, Taxation and Efiling
CA Maninder Singh
CA Maninder Singh is a Chartered Accountant for the past 8 years. He provides courses for Practical Accounts, Taxation and Efiling at teachoo.com .
Jail