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.
Syntax
=FALSE()
Input Arguments
- It does not take any input arguments.
Additional Notes
- 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(AND(A1>0,A1<100),”Approve”,FALSE())
- 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 – Live Example
Excel FALSE Function – Video Tutorial
Related Excel Functions: