IF Articles: Excel and Google Sheets

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

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

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

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

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

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

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

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

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

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