First, let’s get to grips with the dissecting the syntax above for a single IF function.Īs per Excel, it defines this part of the syntax as “any value or expression that can be evaluated to TRUE or FALSE.”.
When harnessed and nested (using multiple IF functions in one), you can have one very powerful multi levelled formula in ONE cell that performs an astonishing number of logical tests. This function is one of the most useful in Excel. Now, let me just explain the syntax of the IF statements in Excel, then I’ll come back to this. But if he doesn’t take the Red Pill he stays asleep. What this tree diagram is saying is, if he takes the Red Pill, he wakes up. We made the following tree diagram to explain this: In the most pivotal scene of the film, the main character Neo is faced with a dilemma, he can consume a Blue colored pill and continue to remain in the Matrix and live his normal life OR he can take the Red pill, leave the Matrix and see how far down the rabbit hole he can go.
Now, my favorite way to explain the concept of the IF Formula Excel is to talk about the film: The Matrix!
These actions can do many things, from displaying text to performing a simple calculation or even other logical IF tests. Why is this Function so Important?īriefly explaining, the IF function Excel performs a user instructed logical test, if that test is TRUE, it performs an action, if it is FALSE, it does another action. Let me start by saying that the IF Statements in Excel is my favorite Excel Function of all time! It is the purest form of Logic and in order to take our work to the next level, we need to be able to build logic.
0 kommentar(er)
