In a previous blog posting, I showed you how to set up an If statement in Excel. In this blog posting, I am going to show you how to nest an OR function into an IF function (the technique can be used equally well with a NOT, AND, TRUE, FALSE functions). Essentially the OR function specifies that if any of certain conditions are met, something else will happen.
[flowplayer src=’https://s3-eu-west-1.amazonaws.com/the-excel-expert/If_and_or_functions.m4v’]
Here is the file with an additional exercise for you to practise on.