Check sibling questions

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


if not fulfilled,there is separate value


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


Example 1

If And Command in Excel - Practice with examples - If Command

  Download Excel File And Try


Example 2



Example 3

Davneet Singh's photo - Teacher, Engineer, Marketer

Made by

Davneet Singh

Davneet Singh is a graduate from Indian Institute of Technology, Kanpur. He has been teaching from the past 12 years. He provides courses for Maths and Science at Teachoo.