IF and AND Function

First things first. Sir Tom said you should pronounce AND function as /ahnd/, not /ehnd/. It will prevent confusion.

Now, the IF Function returns one value if a specified condition evaluates to TRUE, or another value if it evaluates to FALSE.

 The Syntax (the formula to be followed) is:

=IF( logical_test, [value_if_true], [value_if_false] )

It only returns two values: True and False.

Meanwhile, AND Function returns TRUE if all conditions are TRUE. It returns FALSE if any of the conditions are FALSE.

The Syntax is:

=AND( condition1_condition2...)

It returns a number of values.