|Have you ever tried to build a formula containing several
embedded IFs? Complicated, right?
We know that, too... But, as developers, we want to make things easier for you:
Multiple IF is the tool created to build formulas for you.
You just have to make sure you indicate the right parameters, and Multiple IF will do the rest.
Let us look at the following examples:
Let us start by building a
formula with a simple IF, in the selected cell.
|After entering all the data, we will press the OK button.|
|You have just created your first IF formula, in the simplest
Now let us take a look at a more elaborate
|Then we click on the Next button to continue building our formula.|
|Note that in the first part of the IF (is it greater than 10?)
there are two possible answers: if True: ">10", of False: "<=10"
Then, for the second part of the formula (is it lower than or equal to 3?), there are also two possible answers: if True: "<=3"; and if False: ">10"
Finally, we press the OK button to see the results.
|Notice how complex the formula is, and how difficult it would
have been to do it manually.
One more thing: note that the dialogue box has a Next button; this is for a higher level of complexity. Use it if you need it.
Use this tool and have fun building your formulas
Excel Model Builder Secure Payment Options
Choice of Complete Excel Training Course OR OzGrid Add-ins Collection on ALL purchases totaling over $70.00. ALL purchases totaling over $150.00 gets you BOTH! Purchases MUST be made via this site. Send payment confirmation to [email protected] 31 days after purchase.
Microsoft ® and Microsoft Excel ®
are registered trademarks of Microsoft Corporation. OzGrid is in no way
associated with Microsoft.