What if statements in excel 2010

Using IF to check if a cell is blank. Video: Advanced IF functions. IFS function Microsoft , Excel and later. Advanced IF functions - Working with nested formulas and avoiding pitfalls. Training videos: Advanced IF functions.

AND function. OR function. Overview of formulas in Excel. How to avoid broken formulas. Detect errors in formulas. Logical functions. Excel functions alphabetical. Excel functions by category. Table of contents. Next: Common uses of functions. Need more help? You can always use the Evaluate Formula tool to step through your IF formula.

This Excel tool helps you understand a formula. Note: try it yourself. Download the Excel file and choose one of the IF formulas explained on this page. You can use this tool to step through all kinds of formulas. Simple If Examples The IF function checks whether a condition is met, and returns one value if true and another value if false.

For example, take a look at the IF function in cell B2 below. 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.

Our Excel nested IF formula is as follows:. As you see, just one nested IF function is sufficient in this case. Naturally, you can nest more IF functions if you want to.

For example:. The above formula adds one more conditions - the total score of 70 points and more is qualified as "Excellent". Like other Excel functions, IF can be used in array formulas. You may need such a formula if you want to evaluate every element of the array when the IF statement is carried out. The formula assigns a certain number of "points" to each value in column B - if a value is equal to or less than 1, it equates to 1 point; and 2 points are assigned to each value greater than 1.

And then, the SUM function adds up the resulting 1's and 2's, as shown in the screenshot below. Now, let's see what other Excel functions can be used with IF and what benefits this gives to you. When discussing nested IF functions , we wrote the formula that returns different ranking Excellent, Good, Satisfactory or Poor based on the total score of each student.

As you remember, we added a new column with the formula that calculates the total of scores in columns C and D. But what if your table has a predefined structure that does not allow any modifications? In this case, instead of adding a helper column, you could add values directly in your If formula, like this:.

Okay, but what if your table contains a lot of individual scores, say 5 different columns or more? Summing so many figures directly in the IF formula would make it enormously big. In a similar fashion, you can use other Excel functions in the logical test of your IF formulas:.