What is the IF statement

The IF statement is an extremely powerful function in excel. It is probably one of the most used functions in excel

The below is an example of an IF statement. What I’m saying here is, if the cell to the left is less than 1.5, then show me what is in the left cell, if it’s not less than 1.5 then show me the number 3.

The below are the results of the IF statement, and I have copied the formula down to other cells in column B.

You can even replace the result to show a word. In the below example I have used the word “Hello”. You can however use it to show “True” or “False”, etc.

Combining functions

In excel, you can even combine functions together. For the below example, I have combined the + operation with the IF statement.