All resources related to IF for Excel and Google Sheets.

All articles
IF

If cell contains

We can check IF A CELL CONTAINS a specific term in a set of data with a combination of the IF, SEARCH and ISNUMBER functions. We can apply this to copy specific text in another location. The steps below will walk through the process. Figure 1 – Result of using...

Determine if a Cell is Not Blank in Excel

We can determine if a cell is not blank in Excel by either using the IF function or by using the IF and ISBLANK function combined. This tutorial will assist all levels of Excel users in both methods to identify non-blank cells Figure 1. Final result: Determine if a cell...

If Cell equals

We can use the IF function to do something specific if cell equals to a certain value. If the result of the IF function is TRUE, we can do something, and if FALSE, we can choose to do something else. This post provides a clear guide on how to use...

If this AND that

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

How to Use “IF CELL IS THIS OR THAT”

We can use a formula that combines the IF and OR functions to return a value if a cell contains either of two values. The formula returns a TRUE or FALSE or whatever we have specified. The steps below will walk through the process. Figure 1: Result for IF A...

If Cell is X or Y and Z

We can use a nested formula that combines the IF, AND, and OR functions to test for multiple conditions. Here, we will test if a cell value fulfills X OR Y conditions and Z CONDITION. The steps below will walk through the process. Figure 1: Result of If Cell is...

How to Check if a Cell is Greater Than

We can use the IF Function to check if a cell has a value that is greater than the specified criteria. The IF function returns TRUE if the condition is met and FALSE if otherwise. The steps below will walk through the process. Figure 1: How to Check if a...

If this AND that OR that

Many times, we have to consider 2 conditions collectively (if this and that or that). In such a case, we have only two alternatives, AND clause and OR clause. Both the clauses have only two possible results, i.e., TRUE or FALSE. If we make use of OR clause, then the...

If Else

Excel allows a user to use a logical expression in order to check if a condition is true. This is possible by using the IF function which returns Boolean TRUE or FALSE as a result. This step by step tutorial will assist all levels of Excel users in using the...

Nested IF Function Example

Excel allows a user to use a multiple nested logical expression in order to check if conditions are true. This is possible by using the nested IF function which returns Boolean TRUE or FALSE as a result. This step by step tutorial will assist all levels of Excel users in...