# How to Use the IF THEN Formula in Google Sheets

You can use the IF THEN formula in Google Sheets if you need to make logical comparisons.

When evaluating records in Google Sheets, the `IF THEN`, or simply `IF` formula is the go-to technique of many users. You can use this formula to perform a logical test on a record and return a specific value depending on whether the test result is TRUE or FALSE.

There are various situations where you can find the `IF THEN` formula useful. For example, in Accounting, you can use `IF THEN` to evaluate whether a particular expense record falls within the budget or not. You can also use it to rate numerical datasets, like assessing whether a score passed or failed.

In this article, you’ll learn how to write the `IF THEN` formula in Google Sheets, as well as how to use it.

Let’s get started!

## The Anatomy of the IF THEN Formula

The `IF THEN` formula is quite easy to implement as it has a very simple syntax. Here’s how you should write it:

=IF(logical_expression, value_if_true, value_if_false)
• = like in other formulas, the equal sign is the first character you should type in to initiate the `IF THEN` formula.
• IF() this is the `IF THEN` formula.
• logical_expression is the first parameter of `IF THEN`. This parameter will hold the condition or logical expression you need to test.
• value_if_true holds the value that the `IF THEN` formula will return if the condition is true.
• value_if_false if the condition is not met, the formula will return the value in this parameter instead.

## A Real Example of Using the IF THEN Formula

Having learned about the syntax of `IF THEN` formula, let’s now look at how we can utilize it in a real-world scenario. Listed above are the final grades of students in Mathematics. Let’s say we want to determine the students who passed and failed in that subject. Although we can just scan through the data and distinguish the records one by one, it would be inefficient to do this, especially for large datasets.

Here’s where the `IF THEN` formula can help you. With this formula, you can automate what could otherwise take you so long to do. You can use this formula to instantly evaluate the numerical values in your spreadsheet, just like this one: That’s pretty cool, right? Let’s find out how it’s done in the next section.

## How to Use IF THEN Formula in Google Sheets

In order to gain a better understanding of the `IF THEN` formula, let’s try out a simple activity. Click on the link below to have a copy of the spreadsheet that we’ll use.

Once you have a copy of the dataset, open it and follow the steps below.
1. As you can see, the spreadsheet contains the same dataset in our earlier example. Our objective is to display “Passed” in the Remarks column if the grade is greater than or equal to 75. Otherwise, we’ll mark it as “Failed” instead. 2. Let’s start with the first record. Select the cell where you need to display the remarks of the first student. In our case, it’s cell C2, so click it on your spreadsheet. 3. At this point, we are now ready to initiate the `IF THEN` formula. To do so, type in ‘=IF(’. You’ll notice that the formula suggestions box will appear as you type in the formula. According to it, we’ll need to supply three parameters for the formula, namely, logical_expression, value_if_true, and value_if_false. 4. For the first parameter (logical_expression), let’s specify the condition of our formula. We want to test if the value in cell B2 is greater than or equal to 75, so, type in ‘B2>=75’. 5. After the condition, we can already indicate the values we need to display if the condition is met or not. For the value_if_true parameter, type in ‘“Passed”’. As for value_if_false, type in ‘“Failed”’. 6. Finalize the `IF THEN` formula by typing close parenthesis ‘)’. Once that’s done, hit Enter on your keyboard. You should see the spreadsheet update as follows: 7. This time, let’s use the autofill feature of Google Sheets to complete the rest of the dataset. Select cell C2, then click and drag the small blue box on the bottom right corner over the succeeding cells. Perfect! Now you know how to use the `IF THEN` formula in Google Sheets. A great thing about `IF THEN` is that you can utilize it along with other features of Google Sheets. Check out the next section to see how the `IF THEN` formula works with conditional formatting.

## Using the IF THEN Formula with Conditional Formatting

The `IF THEN` formula of Google Sheets can be combined with other functions or features to give your spreadsheet presentation a boost. For instance, you can use Conditional Formatting Rules to change the color of the cells depending on the value returned by your `IF THEN` formula.

You can then use Conditional Formatting with `IF THEN` formula in your spreadsheet to achieve this look, or even better: In the example above, I added conditional format rules to the Remarks column to fill the cell with green if the text contains “Passed”, and red otherwise.

That’s it when it comes to using the `IF THEN` formula in Google Sheets. It’s a very simple formula with so many useful applications. Make sure to use this formula whenever you need to evaluate conditional statements.

Do you want to learn more tricks and functions in Google Sheets? Check out our other articles. Our goal this year is to create lots of rich, bite-sized tutorials for Google Sheets users like you. If you liked this one, you'd love what we are working on! Readers receive ✨ early access ✨ to new content.

##### You May Also Like ## How to Create Candlestick Chart in Google Sheets

A candlestick chart is a visualization tool available in Google Sheets that helps track movements in the value… ## How to Use AVERAGEA Function in Google Sheets

The AVERAGEA function in Google Sheets is used to calculate the numerical average value of a dataset.  AVERAGEA… ## How To Use CHIDIST Function in Google Sheets

The CHIDIST function in Google Sheets is useful when you need to calculate the right-tailed chi-squared distribution of… ## How to ROUND Numbers in Google Sheets

The ROUND function in Google Sheets is useful if you want to reduce a value by a specific…  