IF Function

How to use the IF Function in Excel:

The IF function is one of the most used functions in Excel. It is used to perform a logical test to determine if your criteria is TRUE or FALSE. For example, if we want to check to see if cell B5 is greater than or equal to 100, then our formula would look something like this:
=IF(B5>=100,”YES”,”NO”)
The above formula checks to see if cell B5 is greater than or equal to 100, if it is greater than or equal to 100 then “YES” will be returned. If cell B5 is not greater than or equal to 100 then “NO” will be returned. You can see the example displayed below. The answer will appear in cell D5.

If using the Function Arguments box, the below image shows how it would look based on our criteria:

 

We can also work with criteria that is not number based.  For example, if we want to see if cell B7 contained the value Dog, then our formula would like:
=IF(B7=”Dog”,”YES”,”NO”)

The above formula is checking to see if cell B7 = “Dog”, if it does then “YES” is returned.  If not, “NO” is the returned result.  The results are returned to cell D7 in the below example.