How to write a nested IF in Excel

Thanks! Share it with your friends!


A nested IF statement is an IF statement that sits inside of another IF statement and this video shows you how to created a nested IF statement.

I have to be honest here – in this video you will learn how to use the insert Function dialogue to insert nested functions and I did not know you could do.  In fact over the 5 years I have been teaching Excel to my classes I have told them this is not possible!  Opps I had better change that!

It just goes to show you that no matter how long you have been using Excel you will always find something that surprises you (and that you never stop learning).

It looks like this video is a teacher’s reply to her students I hope you enjoy it.  Please let me know using the comment box below.


Rayna says:

Thank’s, very useful and really enjoy it.

Alejandra says:

Small quibbles with two of the awrness. 1) CHOOSE could be an option, depending on how your original nested IFs were done, but there are other options too. VLOOKUP or HLOOKUP spring to mind, and possibly also INDEX/MATCH. The right choice depends on the nature of the problem2) CEILING is the right choice if you always want to round up, but that’s not quite what you asked. If you want to round to the nearest, then MROUND might be a better choice, although it requires the Analysis ToolPak for Excel 2003 and earlier, and cannot handle negative numbers. You could also use:=ROUND(18/25,0)*25

Write a comment


Skip Ad
Skip Panel
Skip Survey
It would be awesome to hit "like" or "share" and start playing.