How To Add Multiple Conditions In If Statement Sheets

IF Function

Tests a given status and returns one value for a Truthful issue, and another for a Simulated result

What is an Excel IF Statement?

The Excel IF Statement tests a given condition and returns i value for a TRUE result and some other value for a FALSE result. For example, if sales total more than than $five,000, and then return a "Yes" for Bonus – Otherwise, return a "No" for Bonus. We tin can also use the IF function to evaluate a single function, or we can include several IF functions in one formula. Multiple IF statements in Excel are known as nested IF statements.

Excel IF Statement Definition

Every bit a financial annotator, the IF function is used often to evaluate and clarify information by evaluating specific conditions.

The office tin be used to evaluate text, values, and even errors. It is not limited to only checking if 1 thing is equal to another and returning a single result. We tin can besides utilise mathematical operators and perform additional calculations, depending on our criteria. We tin likewise nest multiple IF functions together to perform multiple comparisons.

IF Formula

=IF(logical_test, value_if_true, value_if_false)

The function uses the following arguments:

Logical_test (required argument) – This is the status to be tested and evaluated equally either Truthful or FALSE.
Value_if_true (optional argument) – The value that will be returned if the logical_test evaluates to TRUE.
Value_if_false (optional argument) – The value that will be returned if the logical_test evaluates to FALSE.

When using the IF part to construct a exam, we tin use the following logical operators:

= (equal to)
> (greater than)
>= (greater than or equal to)
< (less than)
<= (less than or equal to)
<> (not equal to)

How to utilise the Excel IF Function

To empathize the uses of the Excel IF statement function, let's consider a few examples:

Case i – Simple Excel IF Statement

Suppose nosotros wish to do a very unproblematic examination. Nosotros want to test if the value in cell C2 is greater than or equal to the value in cell D2. If the statement is truthful, then nosotros want to return some text stating "Yes it is", and if information technology's non truthful, then we want to display "No it isn't".

You lot can see exactly how the Excel IF statement works in the simple example below.

Consequence when true:

Result when false:

Download the uncomplicated XLS template.

Example 2 – Excel IF Statement

Suppose we wish to exam a cell and ensure that an action is taken if the jail cell is not bare. We are given the data below:

IF Function

In the worksheet in a higher place, we listed AGM-related tasks in Column A. Remarks contain the date of completion. In Cavalcade B, we will use a formula to check if the cells in Column C are empty or not. If a cell is blank, the formula will assign the condition "open up." Still, if a cell contains a date, then the formula will assign a status of "closed." The formula used is:

IF Function - Example 2

We get the results below:

IF Function - Example 2a

Instance 3 – Excel IF Statement

Sellers often provide a discount based on the quantity purchased. Suppose nosotros are given the following data:

IF Function - Example 3

Using multiple IF functions, we can create a formula to check multiple conditions and perform different calculations depending on what amount range the specified quantity falls in. To calculate the total price for 100 items, the formula will be:

IF Function - Example 3a

Nosotros go the result below:

IF Function - Example 3b

Things to remember about the IF Office

The Excel IF function will work if the logical_test returns a numeric value. In such a case, any non-zero value is treated as TRUE and zero is treated as FALSE.
#VALUE! error – Occurs when the given logical_test argument cannot be evaluated as True or Imitation.
When any of the arguments are provided to the function every bit arrays, the IF function will evaluate every chemical element of the assortment.
If we wish to count conditions, nosotros should use the COUNTIF and COUNTIFS functions.
If we wish to add upward weather condition, nosotros should use the SUMIF and SUMIFS functions.

Reasons to employ an Excel IF Argument

At that place are many reasons why an analyst or anyone who uses Excel would want to build IF formulas.

Common examples include:

To examination if an argument is truthful or false
To output a NUMBER
To output some TEXT
To generate a conditional formula (due east.g., the result is C3+B4 if true and N9-E5 if simulated)
To create scenarios to be used in financial modeling
To calculate a debt schedule or a stock-still asset depreciation schedule in bookkeeping

Click here to download the sample Excel file

Additional resource

Thanks for reading CFI's guide on how to employ an Excel IF Statement. By taking the time to acquire and master these functions, you'll significantly speed upward your financial analysis. To learn more than, cheque out these additional CFI resources:

Gratuitous Excel Fundamentals Course
Advanced Excel Grade
Advanced Excel Formulas Guide
Excel Shortcuts Listing
Financial Modeling Program