IF Articles: Excel and Google Sheets

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

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

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

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

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

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

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

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

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

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