Search

# Excel FALSE Function | Formula Examples + FREE Video

## Excel FALSE Function (Example + Video)

### When to use Excel FALSE Function

FALSE functionÂ returns the logical value FALSE. It does not take any input arguments.

### What it Returns

It returns the logical value FALSE.

=FALSE()

### Input Arguments

• It does not take any input arguments.

• FALSE function is best used when you are evaluating a condition, and ifÂ isn’t TRUE, you simply want to get the FALSE value in the cell. For example:
• =IF(AND(A1>0,A1<100),”Approve”,FALSE())
In this example, if the condition is not met, it simply returns FALSE as the result.
• If you type FALSE (without parenthesis) in a formula or in a cell, excel automatically takes it as the FALSEÂ logical value.
• FALSE and FALSE() both would return the same value.
• In terms of value, a FALSE is a 0 and a TRUE is a 1. These can be used in calculations
• For example:Â =FALSE+FALSE would be 0 andÂ =FALSE+TRUE would be 1.
• According to Microsoft Help, Excel FALSE function is provided primarily for compatibility with other spreadsheet programs.

## Excel FALSE Function – Video Tutorial

Related Excel Functions:

FREE EXCEL BOOK

## Get 51 Excel Tips Ebook to skyrocket your productivity and get work done faster

Hello there! I'm Sumit Bansal, founder of trumpexcel.com and an Excel MVP. I started this website in 2013 with a simple goal: to share my love for Excel through easy to follow tips, tutorials and videos. I'm here to help you get the best out of MS Excel to save time and boost your productivity.

FREE EXCEL E-BOOK

Get 51 Excel Tips Ebook to skyrocket your productivity and get work done faster

FREE EXCEL E-BOOK

Get 51 Excel Tips Ebook to skyrocket your productivity and get work done faster

FREE EXCEL E-BOOK

Get 51 Excel Tips Ebook to skyrocket your productivity and get work done faster

FREE EXCEL E-BOOK

Get 51 Excel Tips Ebook to skyrocket your productivity and get work done faster