IF function is one of the most widely used functions in Excel. It evaluates a given logical test and returns either a TRUE or a FALSE. In Google sheets, the syntax and usage of IF function is the same as in Excel.
While working with Google sheets, we are able to evaluate a criteria and set a corresponding action if TRUE, or another action if FALSE.
Figure 1. Final result: IF then statements in Google sheets
Syntax of IF function
An IF statement in Google sheets has the following syntax:
=IF(logical_test, [value_if_true], [value_if_false])
- The arguments “value_if_true” and “value_if_false” are optional. If left blank, the function will return TRUE if the logical test is met, and FALSE if otherwise.
Google sheets IF Then
IF Then statements in Google sheets consists of a condition that needs to be evaluated and a corresponding action if the condition is met. If the condition is not met, the function simply returns “FALSE”.
Suppose we have below list of Numbers in column B and column C. For the first two sets of values, we want to evaluate if the first number is equal to the second number. For the last two sets of values, we want to evaluate if the first number is greater than the second number.
Figure 2. Sample data for Google sheets IF then
Enter the following Google sheets IF then formulas in cells G3, G4, G5 and G6:
=IF(B5>C5,B5&" is greater than "&C5)
=IF(B6>C6,B6&" is greater than "&C6)
The Google sheets IF statements above evaluate the specified condition, then return the specified action if the condition is TRUE. Otherwise, the IF function returns “FALSE”, since there is no action specified in the formula once the condition is not met.
The resulting value in G3 is the word “MATCH”, since B3 “1” is equal to C3 “1”. On the other hand, the result in G4 is “FALSE”, since B4 “1” is not equal to C4 “2”.
In cell G5, the result is the THEN statement “2 is greater than 1” after the IF function evaluates the condition “B5>C5” to be TRUE. In cell G6, however, the result is FALSE since “2” in B6 is not greater than “2” in C6.
Figure 3. Output: Google sheets IF then
Google sheets IF Then Else
Google sheets IF Else statements consist of a condition that needs to be evaluated, a corresponding action if the condition is met, and another specified action if the condition is not met.
For the same list of numbers as in previous example, we want to:
- Return “MATCH” if the first two sets of values are evaluated as equal; Otherwise, indicate “No Match”
- Determine if the first number is greater than the second number; Otherwise, indicate that the first number is not greater than the second number
Enter the following formula in cells G3, G4, G5 and G6:
=IF(B5>C5,B5&" is greater than "&C5,B5&" is not greater than "&C5)
=IF(B6>C6,B6&" is greater than "&C6,B6&" is not greater than "&C6)
The difference between IF Then statements in Google sheets and IF Then Else statements is that in IF Then, the formula returns the word “FALSE” when a criteria is not met. While in IF Then Else, the formula returns a user-specified action if the criteria is not met.
Figure 4. Output: Google sheets IF then else
Instant Connection to an Excel Expert
Most of the time, the problem you will need to solve will be more complex than a simple application of a formula or function. If you want to save hours of research and frustration, try our live Excelchat service! Our Excel Experts are available 24/7 to answer any Excel question you may have. We guarantee a connection within 30 seconds and a customized solution within 20 minutes.