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.