**Let’s take it up a notch**

You can replace any element of an IF statement with another Function or formula.

So instead of saying IF 10 is greater than 5. You could say if the result of this VLOOKUP is greater than 5. That formula would look like this:

=IF(VLOOKUP(A2,A8:B15,2,0)>5,”Y“,”N“)

Any text inputs need to be within quotation marks, as with other functions, or the formula will result in an error.

The result if true and the result if false doesn’t have to be a text input. They can also be formulas.

=IF(VLOOKUP(A2,A8:B15,2,0)>5,VLOOKUP(A2,C8:D15,2,0)*10,VLOOKUP(A2,C8:D15,2,0)/10)

It all depends on what you want the outcome to be.

You can string multiple IF statements together. This is something called a nested if. But we will cover that in a different post as it takes quite a lot of brain power to get your head around.

Until next time

Ax

## 3 replies on “Getting started with IF statements”

[…] hand, will typically make up part of the formula to test. It’s frequently nested inside of an IF statement like […]

[…] IF statements are one of the most useful tools in Excel. Whether they are used on their own, nested together or alongside other functions such as the AND/OR Functions. You are guaranteed to get clearer data insights. And be able to quickly identify your data categories. […]

[…] nested IF is a formula that combines two or more IF statements. More specifically, one, or more, IF statements are contained inside of another IF statement. And […]