An IF statement introduces decision-making into your workbooks. It is a ‘conditional statement’ that checks to see if a statement is true or false - and then does one of two things depending on the result.
Our Logic in Excel Foundation includes three short tutorials, which show you how IF statements can be used to provide different outcomes depending on the data entered, and how the number of outcomes can be exponentially increased by using 'nested' IF statements. They will also introduce you to some of the other logic functions in MS Excel such as AND, OR and NOT.
Once you have completed these tutorials and demonstrated your skill by completing the iCoach elements, you will receive a Certificate of Achievement.
This programme is one element in the 'Essential MS Excel' Diploma Programme.