Nested IF statements – how do I create a nested IF statement? Watch the video to learn more

This week’s hint and tip is about how to use nested IF statements within Excel. This is on our Advanced Excel course and covers how to create a nested IF statement. The example is also looking at how you can use other functions alongside nested IF statements. Nested if statements: Excel icon We are going to go through it now below.

 

Nested IF statements in Excel

We have already looked at IF statements and the parts to it in a previous hint and tip. A nested IF statement is where instead of having a ‘value if false’, you nest in another IF statement. This can be done multiple times for however many ‘outcomes’ you are wanting for your logical test. We are going to have a look below at how they can be used alongside other functions.

 

Triathlon Excel challenge

Quite often Excel worksheets need to be developed in order to gain a final answer and here is a case in question.

The workbook ‘Triathlon Nested IF’ has multiple columns which show individual functional formulas across the columns.

In this example we use the following functions:

    • VLOOKUP
    • SUM
    • RANK
    • IF
    • IFS
    • XLOOKUP

Each one is explained in the video and the final answer (what medal) is shown at the far right hand side.

This method allows you to see how each formula works in isolation before the cell containing that formula is then used in the next function.

We have given 3 ways of showing the medal:

    • Nested IF
    • IFS
    • XLOOKUP

Clearly all work but we like to think the new XLOOKUP is the most versatile and shortest to generate.

Take a look below at the video to find out more!

We hope you have enjoyed this hint and tip, why not take a look at our previous one on sorting?

Excel is used heavily in businesses across the world and we engage with our customers both locally in Worcestershire and Herefordshire and further afield in the UK and abroad.

For more details please see out web site www.jplcomputer.co.uk or contact us at johnlegge@jplcomputer.co.uk

 

Cookie Control

Cookie control

We have placed cookies on your device to help make this website better.

I'm fine with this

We have placed cookies on your device to help make this website better.

You can use this tool to change your cookie settings. Otherwise, we’ll assume you’re OK to continue.

Some of the cookies we use are essential for the site to work.

We also use some non-essential cookies to collect information for making reports and to help us improve the site. The cookies collect information in an anonymous form.

To control third party cookies, you can also adjust your browser settings.

I'm fine with this
(One cookie will be set to store your preference)
(Ticking this sets a cookie to hide this popup if you then hit close. This will not store any personal information)
Information and Settings Cookie policy