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 IF THEN function. For example, on the results of students, this function can be used to categorize them as “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.
