The And Function is used to display True or False depending on certain conditions.
To begin, let’s take a look at the syntax below.
And( condition1, condition2, … ) : The condition is what we would like Excel to determine True or False.
Take a look at the example below.
10 =AND(A1>1, A1<20) : True
Ohio State =AND(A1=30, A2=”Michigan”) : False
It becomes a powerful command with the combination of “=IF” statement.