Different logical operations can be applied on Google Sheets with the help of formulas. Conditional operations can be performed with the **“IF THEN”** formula. This formula works **“IF”** the specified condition is fulfilled, then it will perform the action specified after **“THEN”**.

This blog will demonstrate the usage of the “IF THEN”** **function in Google Sheets with the help of the example.

**Why the IF THEN Formula is used in Google Sheets?**

The IF THEN formula in Google Sheets is used for different purposes and some of these purposes are mentioned below:

**Data Analysis:**The given data can be analyzed with the help of the**“Pass”**or**“Fail”****Calculation:**This function can be used to calculate different parameters, for example, a commission is awarded to those salesman who complete the target sales**Decision-making:**This function can also be used to make some decisions. For example, on the basis of the revenue we can predict the budget for the next year

**What is the General Usage Syntax of IF THEN in Google Sheets?**

The general usage syntax of the “**If then”** in Google Sheets is:

```
=IF(Condition, Value return if condition is TRUE, Value return if condition is FALSE)
```

The explanation of the above general syntax of the formula is:

- Use the
**IF**Formula - Define the condition of the
**IF** - Write the value which should be returned if the condition is true
- Write the value which should be returned if the condition is false

**How to Use Google Sheets IF THEN Formula?**

To use the **IF THEN** formula in Google Sheets follow the mentioned-below steps:

- Simply open Google Sheets and choose the cell where the formula is supposed to be applied
- Apply the formula following the above-given general syntax

To understand these steps, we will consider an example of the **“Students Result”**. In the provided data of the students, we will select the cells of the column **“Result Status”**:

Now apply the formula as given below in the formula bar:

```
=IF(D3>33, “Pass”, “Fail”)
```

Then press **ENTER** and to apply the same formula in all cells, use the shortcut key of **“CTRL+ENTER”**:

The status of the Student’s result has been updated in the **“Result Status”**.

**Conclusion**

To use the Google Sheets **IF THEN** formula, select the cell where the formula should apply. Then define the formula according to** “=IF(Condition, return if its true, return if it’s false)”**. This blog will make the understanding of using the IF THEN Formula in Google Sheets with the help of a simple example.