How To Use Nested IF Functions In Excel-Simple Tutorial

Date:2021-7-5 Author:Sandra

IF function is perfectly used in our daily work. And the nested IF is just two more IF statements in a formula. When you have multiple conditions to meet, nested IF is powerful. Let’s take a simple example to show you how to use it well.

Here’s a transcript of math and chemistry. If the math score is more than 60, and at the same time, the Chemistry score is more than 70. The Rating would be Pass. If not, there would be a blank cell in the Rating.

How To Use Nested IF Functions In Excel-Simple Tutorial

Now we type =IF(B2>60,IF(C2>70,”Pass”,” ”),” ”) in cell D2 and press Enter.

How To Use Nested IF Functions In Excel-Simple Tutorial

Use fill handle to quickly fill these cells. Now, you got all the pass and blank cells at once.

How To Use Nested IF Functions In Excel-Simple Tutorial

You can actually think of this process as the figure below.

How To Use Nested IF Functions In Excel-Simple Tutorial
How To Use Nested IF Functions In Excel-Simple Tutorial

When you understand it deeply, you’ll feel comfortable using it. Hope this can help you. See you next time~

Copyright Statement: Regarding all of the posts by this website, any copy or use shall get the written permission or authorization from Myofficetricks.

Leave a Reply

Your email address will not be published. Required fields are marked *