nest

Excel IF Formula: Simple to Advanced (multiple criteria, nested IF, AND, OR functions)

0:00
Toggle fullscreen Fullscreen button

Sharing buttons:

Today's video is about Excel's IF function.

How can we use it alone?

How do we know if we need more than one IF?

How can we combine it with other logical functions such as AND or OR functions?

Whenever you need a formula that's based on a condition, such as you need to mark or flag

entities separately if their value's above 200 in revenue, an IF can do a good job here.

The way you know if you need a nested if, that means you need to use another IF inside

an IF, is when you use buts in your sentences.

Let's say we need to mark entities if their value is above 200, but if their value is

below 50, we need to follow up on them.

Let's take a look at some examples.

In this example, I have a list of apps, and I have the revenue that's associated with

each app.

I've been asked to solve for these.

For the first case, I need to mark apps with the word Good if the revenue is above 15,000.

We're going to start off with IF.

The first argument is our logical test.

What is our logical test in this case?

Is this value, right?

That's our revenue, and if this is greater than 15,000 ... I can either type it in like

this or if I have these values in other cells, I can reference those cells.