Before we can compare 2 lists of items, we need to learn some new functions. One of them is the if Function. The syntax for the if function is “=if(define the condition, return a result if the condition is true, return another result if the condition is false).

For example if you have a list of 2 words,

(Cell A1) Excel

(Cell A2) SynergyWorks

In cell B1, enter the formula **=if(A1=”Excel”, “It is true that the cell contains the word Excel”, “This cell does not contain the word Excel”)**.

In this case, B1 will return the true statement and B2 will return the false statement.

That’s all for now. We will cover another function tomorrow.