How many conditions can be used in excel

Skip to content Home Terms of Service. To add an IF formula with multiple conditions in Excel: 1. Open Excel. Launch your workbook. Enter the If formula in one of the cells. Save changes. Easy, isn't it? Otherwise, the formula returns "Fail". The avoid this, you should use a nested IF function :. Column E will have the "Pass" mark if either the first score is equal to or greater than 20 OR the second score is equal to or greater than As you see in the screenshot below, our students have a better chance to pass the final exam with such conditions Scott being particularly unlucky failing by just 1 point :.

The formula might seem tricky, but in a moment, you will see that it is not! You just have to express two conditions as AND statements and enclose them in the OR function since you do not require both conditions to be met, either will suffice:. The screenshot below indicates that we've got the formula right:.

You can use as many logical functions as your business logic requires, provided that:. These multiple IF functions are called nested IF functions and they may prove particularly useful if you want your formula to return 3 or more different results. For instance:. To begin with, you can add an additional column E with the following formula that sums numbers in columns C and D:. And now, let's write a nested IF function based on the above conditions. It's considered a good practice to start with the most important condition and make your functions as simple as possible.

If the data set has a predefined structure that will not allow any of the modifications. Then you can add values with this If formula:. If you want to find out the highest scores, using the Max function. You can also find the lowest scores using the Min function. You can also call it as nested if functions with other excel functions.

To get a result, you can use these if functions with various different functions that are used in excel. If you use the Evaluate Formula Wizard from the Formula tab you'll see how Excel evaluates the formula.

You can always ask an expert in the Excel Tech Community or get support in the Answers community. Learn how to use nested functions in a formula. IF function. AND function. OR function.

NOT function. Overview of formulas in Excel. How to avoid broken formulas. Detect errors in formulas. Keyboard shortcuts in Excel.