# How to use the FALSE function

**What is the FALSE function?**

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

**What is a Boolean value?**

A Boolean value in Excel is a value that can only be TRUE or FALSE. It represents binary logic and is the result of a logical expression using logical operators or a result of a few Excel functions that I'll discuss below.

Mastering Boolean logic and logical expressions is key to manipulating data and controlling workflow in Excel.

**What is binary logic?**

Binary logic refers to values having one of two states, TRUE or FALSE. This allows Boolean algebra in Excel using logical operators.

**What is a logical expression?**

A logical expression is a statement that evaluates to TRUE or FALSE. For example:

=A1<4

These expressions use comparison operators to evaluate a condition and produce a Boolean result.

**What are the comparison operators?**

= - equal sign

< - less than sign

> - greater than sign

These operators let you build more operators like this:

<> - not equal to

<= - less than or equal to

>= - greater than or equal to

These comparison operators let you create logical expressions like: A2<>5 meaning if the value in cell A2 is not equal to 5, the result is either TRUE or FALSE.

**What are the logical operators?**

The main logical operators in Excel are:

- AND - Returns TRUE if all conditions are true
- OR - Returns TRUE if any condition is true
- NOT - Negates a logical expression
- XOR - Returns TRUE if only one condition is true

**Which functions returns the Boolean value TRUE or FALSE?**

Excel Function and Arguments | Description |
---|---|

AND(logical1, logical2, ...) | Returns TRUE if all arguments are TRUE |

OR(logical1, logical2, ...) | Returns TRUE if any argument is TRUE |

NOT(logical) | Reverses the logic of its argument |

XOR(logical1, logical2, ...) | Returns TRUE if an odd number of arguments are TRUE |

ISEVEN(number) | Returns TRUE if number is even |

ISFORMULA(value) | Returns TRUE if value is a formula |

ISLOGICAL(value) | Returns TRUE if value is logical value |

ISNA(value) | Returns TRUE if value is #N/A error |

ISNONTEXT(value) | Returns TRUE if value is not text |

ISNUMBER(value) | Returns TRUE if value is number |

ISODD(number) | Returns TRUE if number is odd |

ISREF(value) | Returns TRUE if value is reference |

ISTEXT(value) | Returns TRUE if value is text |

ISBLANK(value) | Returns TRUE if value is blank |

ISERR(value) | Returns TRUE if value is error except #N/A |

ISERROR(value) | Returns TRUE if value is any error |

**What is the difference between FALSE and the FALSE() function?**

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.

#### 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

Table of Contents How to graph a normal distribution How to build an arrow chart How to graph an equation […]

Table of Contents Automate net asset value (NAV) calculation on your stock portfolio Calculate your stock portfolio performance with Net […]

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

### Functions in 'Logical' category

The FALSE function function is one of 17 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