## How to use the FALSE function

The FALSE function returns the logical (boolean) value FALSE.

#### Table of Contents

## 1. FALSE Function Syntax

=FALSE()

## 2. FALSE Function Arguments

The FALSE function has no arguments.

## 3. FALSE Function Example

Excel interprets the boolean value FALSE exactly the same as =FALSE(), you most often don't need the FALSE function. It exists primarily for compatibility with other software.

Formula in cell C3:

### Explaining formula

#### Step 1 - Logical expression

The equal sign lets you compare value to another value.

1=2

returns FALSE.

#### Step 2 - Evaluate IF Function

The IF function returns one value if the logical test is TRUE and another value if the logical test is FALSE.

IF(*logical_test*, [*value_if_true*], [*value_if_false*])

IF(1=2, TRUE(), FALSE())

becomes

IF(FALSE, TRUE(), FALSE())

and returns FALSE(). FALSE() returns FALSE.

### 'FALSE' function examples

The following 28 articles contain the FALSE function.

Introduction In this post I am creating a spreadsheet that will calculate stock portfolio performance. To do this I am […]

The drop down calendar in the image above uses a "calculation" sheet and a named range. You can copy the drop-down […]

I read an interesting blog post Is A Particular Word Contained In A Text String? on Spreadsheetpage. That inspired me […]

Question: I want a unique distinct list to be created from a column where an adjacent column has text cell […]

AJ Serrano asks: I have a column where each rows contains different values and I wanted to obtain the duplicate […]

Murlidhar asks: How do I search text in cell and use a date range to filter records? i.e st.Dt D1 […]

This blog post describes how to create a list of unique words from a cell range. Unique words are all […]

Unique values are values occurring only once in cell range. This is what I am going to demonstrate in this blog […]

This article demonstrates how to apply Conditional Formatting formula to a cell range, it finds cells that are in close […]

The above picture shows you two formulas that extract names (column B) and date ranges (column C and D) based […]

This article demonstrates a worksheet that highlights lookups across relational tables. I am using Excel defined Tables, if you add […]

The chart above is built using the NORM.DIST function and is called Normal Distribution or Bell Curve chart. This curve is often […]

Nested IF statements in a formula are multiple combined IF functions so more conditions and outcomes become possible. They all are […]

I recently discovered an interesting technique about using a user defined function in a HYPERLINK function. Jordan at the Option […]

The asterisk character allows you to multiply numbers and boolean values in an Excel formula. It can also be used […]

I will in this article demonstrate how to use the VLOOKUP function with multiple conditions. The function was not built […]

This article demonstrates different formulas based on if a cell contains a given text. Formula in cell C3: =B3=$E$3 The […]

The AND function allows you to have multiple conditions in an IF function, you can have up to 254 arguments. […]

This article demonstrates how to use INDEX and MATCH functions to lookup and return multiple results. The lookup value is […]

This article demonstrates techniques on how to merge or combine two data sets using a condition. The top left data […]

I will in this article demonstrate a calendar that automatically highlights dates based on date ranges, the calendar populates names […]

This article demonstrates formulas that rearrange values in a cell range to a single column. Table of Contents Rearrange cells […]

This article explains how to repeat specific values based on a table, the table contains the items to be repeated […]

Table of Contents Sum unique numbers Get Excel *.xlsx file Sum unique distinct numbers Get Excel *.xlsx file Sum number […]

You don't need to use the IF function in a SUMPRODUCT function, it is enough to use a logical expression. […]

Mark G asks in Create a random playlist in excel: Can this example be modified to create a true round-robin […]

This article demonstrates how to sort records in a data set based on their count meaning the formula counts each […]

What's on this page Reverse text Insert random characters Convert letters to numbers How to shuffle characters in the alphabet […]

## Functions in this article

### Functions in 'Logical' category

The FALSE function function is one of many functions in the 'Logical' category.

## How to comment

How to add a formula to your comment<code>Insert your formula here.</code>

Convert less than and larger than signsUse html character entities instead of less than and larger than signs.

< becomes < and > becomes >

How to add VBA code to your comment[vb 1="vbnet" language=","]

Put your VBA code here.

[/vb]

How to add a picture to your comment:Upload picture to postimage.org or imgur

Paste image link to your comment.

Contact OscarYou can contact me through this contact form