This 5 minute video tutorial provides instruction in how to create an IF Function. If you are using this tutorial with the resource "Creating a Financial Model", you should consider watching tutorial 22 first.
The video shows one application of an IF Function that is used in conjunction with Check Boxes (which is the subject of Tutorial 22). The video explains the three components essential to any IF Function:
The video tutorial shows one practical application of an IF Function but there many other ways to construct the logical test, and therefore many ways to use an IF Function. In the above example, the '= sign' is used but the signs that can be used include:
Operator | Description |
= | equals |
> | greater than |
< | less than |
< > | not equivalent |
<= | less than or equal |
>= | greater than or equal |
If you would like to have a go at a simple exercise that displays a different application of an IF Function, click on the following link: