How to Do IF THEN in Google Sheets (3 Ideal Examples)

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:

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.

Steps:

• 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.

Steps:

• 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.

We discover that just two of our patients, Alyssa and Morgan, meet the requirements, thus we can deduce that they have diabetic nephropathy.

Read More: How to Use AND Function in Google Sheets (4 Useful Examples)

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.

Steps:

• 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.

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)

Similar Readings

• How to Highlight Row If Cell Is Not Empty in Google Sheets
• Google Sheets: Conditional Formatting Row Based on Cell
• How to Use ARRAYFORMULA with IF Function in Google Sheets
• Use REGEXMATCH Function for Multiple Criteria in Google Sheets
• How to Use VLOOKUP for Conditional Formatting in Google Sheets

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.

Steps:

• Select cell D6 first.
• The formula that we’ll employ is as follows:

• Finally, press ENTER to learn the outcome.

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 Statements in Google Sheets (3 Examples)

Final Words

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.

Related Articles

• How to Use Nested IF Function in Google Sheets (4 Helpful Ways)
• Conditional Formatting with Multiple Conditions Using Custom Formulas in Google Sheets
• Filter Values that Contains Multiple Text Criteria in Google Sheets (2 Easy Ways)
• If Cell Contains Text Then Return Value in Another Cell in Google Sheets
• Highlight Row Based on Date in Google Sheets (2 Suitable Ways)
• Match Multiple Values in Google Sheets (An Easy Guide)