Ozgrid, Experts in Microsoft Excel Spreadsheets
Javascript DHTML Drop Down Menu Powered by dhtml-menu-builder.com

Active DataXL - Download


AnalyserXL - Download


DownloaderXL - Download


Smart VBA - Download


TraderXL - Download

Excel Multiple IF Functions/Formulas

Microsoft Excel - From Beginner to Expert in 6 Hours/ EXCEL DASHBOARD REPORTS


Back to Excel Model Builder Start

Multiple IF    
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.
The question is: If Cell D2 is greater than 10, the message will be "It is greater than 10"; otherwise, the message will be "It is lower than or equal to 10".

After entering all the data, we will press the OK button.
You have just created your first IF formula, in the simplest possible manner.

Now let us take a look at a more elaborate example:
We will work on the same cell from the previous example. We will ask:
Is Cell D2 greater than 5? If true, let it ask again: Is Cell D2 greater than 10?
If Cell D2 is lower than 5, then let it ask again: Is Cell D2 lower than or equal to 3?

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

View Demos

Excel Model Builder  Secure Payment Options

1 License $129.95 USD
2 - 5 Licenses $110.95 USD
6 - 10 Licenses $97.95 USD
11+ Licenses $64.95 USD

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.
Contact Us