## What Is FALSE In Excel?

The

FALSEExcel Functionreturns the Boolean logical valueFALSE. We can with or without the parenthesis. The function is useful withIF()andIFERROR()functions than on its own. TheExcelFALSE functionis an inbuilt Logical function, so we can insert the formula from the “Function Library” or enter it directly in the worksheet.

For example, the table below shows scores out of 100, and we will determine the status of the full marks using the** FALSE in Excel **and the **IF Excel** function**.**

Select cell **B2**, enter the formula **=IF(A2=100,”Full Marks”,FALSE()), **press** “Enter”, **and drag the formula from cell **B2** to **B11** using the Excel fill handle.

We get the output shown above. Here, if the given score equals 100, the **IF()** function returns the output as “**Full Marks**”, otherwise, updates the status as **FALSE**. Column C is for our reference.

##### Table of contents

###### Key Takeaways

- The function
**FALSE in Excel**output is the logical value**FALSE**. Users can apply the**FALSE**function in a cell or formula to display the value**FALSE**. - The
**FALSE**function does not take any arguments as input. So, we can enter the formula with or without the brackets. - We can use the
**FALSE()**as a standalone function. However, since it is a compatibility function, it is best to use it with other Excel logical functions, such as**IF**,**IFERROR**,**SUMIF,**and**COUNTIF**.

### FALSE() Excel Formula

The syntax of the **FALSE in Excel** is,

The **FALSE()** does not take any arguments as input.

### How To Use FALSE Excel Function?

We can use the **FALSE Excel Function **in 2 ways, namely,

**Access from the Excel ribbon.****Enter in the worksheet manually.**

#### Method #1 – Access from the Excel ribbon

First, choose an empty cell for output → select the “**Formulas**” tab → go to the “**Function Library**” group → click the “**Logical**” option drop-down → select the “**FALSE**” function, as shown below.

The “**Function Arguments**” window appears. Since the function doesn’t accept any argument, just click “**OK**”, as shown below.

#### Method #2 – Enter in the worksheet manually

- First, select an empty cell for the output.
- Next, type
**=FALSE(**in the selected cell. [Alternatively, type**=F**and double-click on the**FALSE**function from the Excel suggestions.] - Finally, press
**Enter**to execute the formula.

Let us take a basic example to understand this function.

We will use the **FALSE in Excel **and find whether the given conditions are **True** or **False**.

The table below contains condition statements.

The steps to find the logical value using the** FALSE in Excel** are,

**We know the given condition statement in cell A2 is FALSE. So select cell B2, enter the formula =FALSE() as a standalone function, and press “Enter”. The result is FALSE, as shown below.**

[Alternatively, we can enter the**FALSE()**using the option available in the**Formulas**tab. And for that, we must select the target cell and click**Formulas**→**Logical**→**FALSE**.

The above action will open the**Function Arguments**window. But, as we do not need to enter any argument values, the window will provide the**FALSE in Excel**and show the expected result.

And once we click**OK**, the**FALSE()**gets executed in the target cell.]**As the second condition statement is a question, we will use the FALSE() within the IF() function.**So, select cell

**B3**, enter the formula, and press*=IF(SQRT(725)=25,”TRUE”,FALSE())***Enter**.

We get the above output.

[**Output Observation:**In the above formula, the**SQRT()**returns the square root of the value**725**,**26.925**. The**IF()**then checks if the value**26.925**equals**25**. And as the condition does not hold, the**false_value**or the**FALSE()**gets executed. And hence the**IF()**returns**FALSE**as the output in the target cell.]

### Examples

We will understand advanced scenarios using the **FALSE in Excel examples**.

#### Example #1

We will use the **FALSE() **with **IF Excel Function** for the data involving string values.

The table below shows the order and shipment data of a list of laptops, and we will determine the demand fulfillment status.

The steps to apply the **FALSE in Excel** within the **IF() **are,

**Step 1:**Select cell**E2**, enter the formula, and press*=IF(AND(B2<C2,D2=”Yes”),TRUE,FALSE())***Enter**. We will get the result as**TRUE**, as shown below.

[**Note:** The **IF()** checks two conditions. The first condition is that the units ordered should be more than the units required, and the second one is that the order shipped status should be **Yes**.]

**Step 2:**Drag the formula from cell**E2**to**E11**using the fill handle.

We get the output shown above.

[**Output Observation:** Let us consider the cell **E11** formula to see how the formula works. As the first condition does not hold, the function **FALSE in Excel** gets executed, and the **IF()** returns the demand met status as **FALSE**.]

#### Example #2

We will use the **FALSE() **with **COUNTIF Function in excel ** for the data where not all state-capital pairs are correct, and we will count the number of mismatches.

The following table contains a list of US states and capitals in columns A and B, and column C shows the match.

The procedure to apply the **FALSE in Excel** within the **COUNTIF()** is,

Select cell **B13**, enter the formula ** =COUNTIF(C2:C10,FALSE()), **and press

**Enter**.

The output is shown above.

[**Output Observation:** The given criteria is to match the **FALSE()** return value. So, the **COUNTIF() **counts the number of **FALSE **values in the specified range, **C2:C10**, and returns the count as **6**.]

#### Example #3

We will use the **FALSE() **within the **SUMIF **function in Excel and calculate the total quantity of fruits that are not Category A.

The below table contains a list of fruits, their category, and quantity details.

The procedure to apply the **SUMIF()** with the function **FALSE in Excel** is,

Select cell **B13**, enter the formula ** =SUMIF(B2:B11,FALSE(),C2:C11)**, and press

**Enter**.

We get the above output.

[**Output Observation:** First, the given criterion is **FALSE()**. So, the criterion in the above formula is the logical value **FALSE**. Next, the **SUMIF() **checks for the **FALSE **values in the range **B2:B11**. The cells **B3, B5, B6, B7, **and** B11** satisfy the condition. And thus, the function adds the quantity values in the corresponding column C cells to return the required total quantity as **9800**.]

### Important Things To Note

- The function
**FALSE in Excel**and the logical value**FALSE**is the same. - The numeric value of the
**FALSE()**output is**0**. - Though we can directly enter
**FALSE**in a cell or formula, the**FALSE**function affirms compatibility with other spreadsheet software packages.

### Frequently Asked Questions (FAQs)

**1. Where is the FALSE function in Excel?**

First, choose an empty cell for output → select the “**Formulas**” tab → go to the “**Function Library**” group → click the “**Logical**” option drop-down → select the “**FALSE**” function, as shown below.

**2. How to use the FALSE function with IFERROR()?**

We can use the **FALSE** function with **IFERROR() **to determine the price per unit in column C and display the result as **FALSE** in cells where the division of the two given values results in an error.

For example, the following table shows inventory data.

The steps to apply the **IFERROR()** with **FALSE()** are,**• Step 1: **Select cell **C2**, enter the formula ** =IFERROR(A2/B2,FALSE())**, and press

**Enter**. The result is

**27**, as shown below.

**• Step 2:**Drag the formula from cell

**C2**to

**C7**using the fill handle.

We get the output shown above.

[

**Output Observation:**As the total units are 0 in rows 4 and 5 and missing in row 6 data, the

**IFERROR() value**arguments in the respective target cells result in the

**#DIV/0!**error. And hence, the

**IFERROR()**returns the

**value_if_error**argument value as the output. So, the

**FALSE()**gets executed, and thus, we get the logical value

**FALSE**as the output in the target cells

**C4:C6**.]

**3. Can we perform arithmetic operations using the FALSE function in Excel?**

We can perform arithmetic operations using the **FALSE** **in Excel**, as the **FALSE()** numeric value is **0**.

For example, the below table contains a range of values in the **Value 1** column, and **Value 2** is the **FALSE()**. Column C shows the arithmetic operation to perform in the corresponding column D cells using the values 1 and 2.

The steps to apply the required formulas using the **FALSE() **in column D are,**• Step 1: **Select cell **D2**, enter the formula ** =A2+FALSE()**, and press

**Enter**. The result is

**10**.

**• Step 2:**Select cell

**D3**, enter the formula

**, and press**

*=A3-FALSE()***Enter**. The result is

**20**.

**• Step 3:**Select cell

**D4**, enter the formula

**, and press**

*=A4*FALSE()***Enter**. The result is

**0**.

**• Step 4:**Select cell

**D5**, enter the formula

**, and press**

*=A5/FALSE()***Enter**. The result is

**#DIV/0!**

**Output Observation**: The formula in each target cell takes the numeric value of the

**FALSE**function as

**0**. And hence, in cell D2, the formula performs the operation

**10+0**, resulting in the value

**10**. Likewise, in cells D3 and D4, the arithmetic operations performed are

**20-0**and

**30*0**, resulting in

**20**and

**0**in the respective target cells.

Finally, the expression executed in cell

**D5**is

**40/0**. And as the denominator is

**0**, the division operation results in the

**#DIV/0!**error.

### Download Template

This article must be helpful to understand the **FALSE In Excel**, with its formula and examples. We can download the template here to use it instantly.

### Recommended Articles

This has been a guide to FALSE Excel Function. Here we explain how to use FALSE formula along with examples & downloadable excel template. You can learn more from the following articles –

## Leave a Reply