All resources related to IF for Excel and Google Sheets.

If cell contains this or that

Excel allows a user to check if a range of cells contains any of two selected values using the COUNTIF, SUM and IF functions. This step by step tutorial will assist all levels of Excel users in checking if cells contain this or that. Figure 1. The result of the...

Force negative numbers to zero

There is a simple method in Excel that forces negative numbers to zero through the use of the MAX function. This tutorial will walk through how to do it. Figure 1. Final result: Forcing negative numbers to zero using MAX function Setting up the Data Below is a table of...

Tax rate calculation with fixed base

Excel allows a user to calculate a tax rate with fixed base using the IF function. This step by step tutorial will assist all levels of Excel users in calculating a tax rate with fixed base. Figure 1. The result of the IF function Syntax of the IF Formula The...

If this AND that OR that

While working with Excel, we are able to evaluate two or more conditions and customize the actions by using the IF, AND and OR functions. This step by step tutorial will assist all levels of Excel users in marking items in a database that satisfy specific sets of conditions. ...

How to Use the IFERROR Function in Excel

When you apply a formula in Excel it may return an error. Excel formulas return various error types due to a variety of reasons. You can use the IFERROR function to manage what happens when a mistake occurs. Possible Error Messages in Excel The possible error messages from a formula...

How to Use the IF and OR Functions in Excel

While evaluating a dataset, you might come across to a situation where you need to test multiple conditions or logical tests. Excel's IF function allows users to logically compare values by testing condition(s) and returning a value if that condition(s) is TRUE or FALSE. If you have multiple conditions to...

How to Determine IF a Cell is Blank or Not Blank in Excel

You may have a range of data in Excel and need to determine whether or not a cell is Blank. This article explains how to accomplish this using the IF function. Determine if a cell is blank or not blank Generally, the Excel IF function evaluates where a cell is...

Learn How to Use Nested IF Statements in Excel

As per syntax, a basic IF statement handles one logical test, and based on its TRUE and FALSE values, it specifies one value_if_true argument’s value and one value_if_false argument’s value. But there are some cases where there are multiple logical tests and multiple value_if_true arguments’ values, having a separate value...

Learn How To Use an IF AND Function in Excel

In Excel's IF statement formula, you face a situation when you need to apply more than one logical test and want to return a value when all the applied logical tests or conditions are TRUE. This is the situation where IF and AND functions come into action as a combined...

How to Write an IF Statement in Excel

The IF function is one of the most popular and widely used functions in Excel. This function is used to test logical comparisons or conditions on a value. This is a powerful feature once you've learned the basics of constructing a statement. How to Write an IF statement in Excel...