In this article:

May 8, 2024

The IF ELSE function in Google Sheets can be used to set conditions that give an output depending on whether a given condition is fulfilled or not. It works as follows:

*If condition is true, then value if true; else, value if false*

The IF function can work without the ELSE value but it will display the value FALSE if the condition is not fulfilled. The same logic applies to the IFS function.

While there is no explicit ELSE function in Google Sheets, it does not mean that you cannot add the ELSE value to your IF function. In fact, the ELSE value is within the syntax of the IF function!

Read this guide to learn how to replace the FALSE value with something else and ensure your sheet looks neater than before.

**=IF(condition, value_if_true, else_value)**

Where

**condition **is the condition to fulfill

**value_if_true** is the value displayed if the condition is met

**else_value** is the value displayed if the condition is not fulfilled

**=IF(condition1, value_if_true1, IF(condition2, value_if_true2, value_if_false))**

Where

**condition1 **is the first condition to fulfill

**value_if_true1** is the value displayed if **condition1 **is met

**condition2 **is the condition to check if **condition1 **is not met

**value_if_true2** is the value displayed if **condition2 **is met but not **condition1**

**value_if_false **is the value displayed if both **condition1 **and **condition2 **are not met

We want to know whether the entry passed or failed the assessment by checking if the weighted score is at least 37. The resulting conditions and values are the following:

**Condition:** weighted score > 36

**Value_if_true:** “PASSED”

**Value_if_false:** “FAILED”

The function is now

**=if(E2>36,"PASSED","FAILED")**

You can opt to extend the function to the other rows of the column, giving you this result:

We want to know whether the entry passed or failed the assessment by checking if the weighted score is at least 37. For this example, we will store the values intoThe resulting conditions and values are the following:

**Condition:** weighted score >= 37

**Value_if_true**: “PASSED”

**Value_if_false**: “FAILED”

For this example, we will store these values to other cells, and then point to them.

Noting where the values are stored, the function for Row 2 is now

**=if(E2>=$G$2,$G$5,$G$6)**

We added the dollar signs since we plan to copy this to other rows in the same column.

You can opt to extend this to the other rows of the column, giving you this result:

You can set another IF statement as the ELSE value, converting it to ELSE IF.

At this time, we want to introduce a tiered assessment system. First, we want to check whether the entry passed or failed the assessment by checking if the weighted score is at least 37:

**Condition1**: weighted score > 36

**Value_if_true1**: “PASSED”

Next, we want to check if the score difference is less than 5:

**Condition2**: 36 - weighted score < 5

**Value_if_true2**: “CLOSE TO PASSING”

**Value_if_false**: “FAILED”

The function is now:

**=if(E2>36,"PASSED",if(36-E2<5,"CLOSE TO PASSING","FAILED"))**

You can opt to extend this to the other rows of the column, giving you this result:

Check out our IF ELSE Google Sheets sample sheet here.

IF: Allows you to check for specific conditions across a dataset

SUMIF: Use to sum numbers if they meet a certain condition..

SUMIFS: Sums data from cells that meet multiple criteria

COUNTIF: count data if it fulfils certain criteria

COUNTIFS: Count data that fulfils two or more criteria.

COUNT IF Not Null**: **Count cells if they contain data

IFERROR**:** Allows you to output values when an Error in a formula occurs

IFTHEN: Allows you tor write statements that use IF X Then Y Logic

IF AND**:** Combines the functionality of the IF and AND functions

Multiple IF**:** Learn how to use multiple if statements in a single formula

IF OR: Evaluates multiple conditions and produces a TRUE result when any of them are met.

IF Contains: Returns cells that contain a particular text.

AVERAGEIF: Calculate an average for numbers within a data range if they meet the provided criteria.

If you want to learn how to extract a domain from email in Google Sheets, we also suggest checking out our detailed guide.

Get Google Sheets productivity and automation tips delivered straight to your inbox

We'll email you 1-3 times a week — and never share your information.

Use Lido to connect your spreadsheets to email, Slack, calendars, and more to automate data transfers and eliminate manual copying and pasting. View all use cases ->