Google Sheets has many formulas that make working considerably simpler. The IF THEN logical calculation in Google Sheets is one of the amazing features that make it easy to verify logical arguments, single or multiple criteria, or conditions, and return a value if they are TRUE or a different value if they are FALSE.
A Sample of Practice Spreadsheet
You can copy the spreadsheet that we’ve used to prepare this article.
3 Ideal Examples to Do IF THEN in Google Sheets
We can use the IF function by itself in a single logical test or nest numerous IF statements into one formula to create more complicated tests.
The IF Function has the following syntax:
=IF(logical_test, value_if_true, value_if_false)
There are multiple methods to use the IF statement followed by a THEN outcome in Google Sheets. In Google Sheets, we may combine several IF statements to run a longer and more complex logical test. To improvise calculations and logical tests, we can nest some other functions as well.
1. Utilizing IF THEN with Single Condition
Use the IF function in your Google Sheets formula if you want to conduct a logical test that returns different answers depending on whether the test is TRUE or FALSE. Use it in Google Sheets by following these steps.
Assume we have a dataset with a few patients’ most current pulse rates. We must ascertain the state of the patient’s blood pressure. If the rate exceeds 100, then the patient has excessive or high blood pressure.
- We will choose cell D6 initially.
- First and foremost, we’ll use the following formula as the first logical argument:
- After that, we’ll apply the following formula:
- The value to return in this case if the logical argument is TRUE is “Normal”.
- If the logical argument is FALSE, it will return “High”.
- To obtain the outcome with the final formula, press ENTER after closing parentheses.
At the conclusion of the day, we can say that Alyssa is the only patient with high blood pressure, and everyone else has normal BP.
Read More: How to Use IF Condition Between Two Numbers in Google Sheets
2. Using AND/OR Criteria
Since the IF THEN formula primarily performs a logical test with TRUE and FALSE outcomes, we can further enrich the criteria by integrating the AND and OR logical conditions into the formula. We are then able to conduct an initial test using multiple criteria.
2.1 IF THEN with AND Criteria
Let’s say we have a dataset of patients who have symptoms that can be used to determine if they have Nephropathic diabetes or Normal diabetes. Damage to the kidney occurs in patients with nephropathic diabetes. Loss of weight, Muscle cramps, and blurred vision are common symptoms.
- First, we must choose a cell, F6.
- Now we may say that the patient has nephropathic diabetes if they have checked Yes to all the conditions, including weight loss, muscle cramps, and blurred vision.
- To determine the outcome, we’ll utilize the formula below.
- Finally, press ENTER to see the findings.
- (C6=”Yes”,D6=”Yes”,E6=”Yes”) as to determine whether the cell values are equal to Yes or not.
- If all the conditions are met, the AND function will perform the logical test and return TRUE if all values are Yes; otherwise, it will return FALSE.
- “Diabetic Nephropathy” will be the result if the value is TRUE.
- If the AND function returns a FALSE value then it will be “Normal”.
We discover that just two of our patients, Alyssa and Morgan, meet the requirements, thus we can deduce that they have diabetic nephropathy.
2.2 IF THEN with OR Criteria
There is a different form of diabetes called Diabetic Retinopathy, which affects the blood vessels in the eyes. Patients with blurred vision frequently have this condition. Those who do not lose weight, however, stand the risk of developing diabetic retinopathy.
- Again, we must begin by selecting cell F6.
- To rule out all the patients having diabetic retinopathy, we can utilize the OR criterion since they must declare either a No for weight loss or a Yes for blurred vision.
- Therefore, we are going to use the following formula.
- Click ENTER at the end to view the outcome.
- The IF function executes the logical test using the OR function to satisfy the OR criterion of our objective.
- OR(C6=”No”,E6=”Yes”), here, OR criterion validates the arguments. If any of the parameters examined by OR are TRUE, it will return TRUE; If all parameters are FALSE, it will display a FALSE value.
- If the value is TRUE, then it will return “Diabetic Retinopathy”.
- “Normal” refers to the false value returned by the OR criterion.
We can see that, of the five individuals, three are either at risk for or have already developed diabetic retinopathy.
Read More: How to Use IF and OR Formula in Google Sheets (2 Examples)
- Highlight Row Based on Date in Google Sheets (2 Suitable Ways)
- How to Highlight Row If Cell Is Not Empty in Google Sheets
- Find if Date is Between Dates in Google Sheets (An Easy Guide)
3. Applying Nested Conditions
Although applying many conditions at once when using multiple IF statements in Google Sheets may seem complicated, it makes the process much simpler. Consider the following example.
Assume we have a dataset of a few patients that includes their most recent A1C Test results to check for diabetes. We must assess the level of diabetes they have. We can do this by nesting multiple IF functions inside one another to cover all given conditions.
- Select cell D6 first.
- The formula that we’ll employ is as follows:
=IF(C6<4,"Normal",IF(C6<8,"Prediabetes",IF(C6<11,"Diabetes Stage 1","Diabetes Stage 2")))
- Finally, press ENTER to learn the outcome.
- The IF function will test C6<4 as the first logical input.
- “Normal” is the value to display if the first argument returns TRUE.
- If the first logical argument returned FALSE, the IF function will verify the second logical argument, which is C6<8.
- It will display “Prediabetes” If the second parameter is TRUE.
- If the second argument is FALSE, the third argument to test is C6<11.
- It will output “Diabetes Stage 1” If the third logical argument is TRUE.
- If the third logical statement is FALSE then it will display “Diabetes Stage 2”.
We can see that the formula identified their level of diabetes based on the result of their test. Stewart, for instance, has Diabetes Stage 1 since his score is between 8 and 11.
Read More: How to Use Nested IF Function in Google Sheets (4 Helpful Ways)
You can also apply conditional formatting with the IF then function. This article made an effort to address every aspect of using IF THEN in Google Sheets. For more details, visit our website OfficeWheel or leave a comment below if you have any questions about the Google Sheets if-then formula.
- How to Use Multiple IF Statements in Google Sheets (5 Examples)
- If Cell Contains Text Then Return Value in Another Cell in Google Sheets
- How to Use ARRAYFORMULA with IF Function in Google Sheets
- Conditional Formatting with Multiple Conditions Using Custom Formulas in Google Sheets
- Google Sheets: Conditional Formatting with Multiple Conditions