Excel FALSE function

Summary

The Excel FALSE function is a simple and direct way to return the logical value FALSE. While a logical expression automatically returns TRUE or FALSE, using the FALSE function or FALSE value explicitly can enhance readability and clarity, especially in complex formulas.
Syntax
				
					=FALSE()
				
			
This function does not take any arguments.
Return value
The logical value FALSE.

How to use

The FALSE function can be used anywhere you need a clear and explicit FALSE value, such as in logical tests within other functions. It’s particularly useful in IF functions or similar logical constructs. It serves the same purpose as directly using the FALSE value or allowing a logical expression to evaluate to FALSE.

Examples

FALSE and IF
The FALSE function returns the Boolean value FALSE. Therefore, the following three formulas, which utilize the IF function, are essentially the same in functionality:
				
					=IF(A1 > 10, "Greater than 10", FALSE())
=IF(A1 > 10, "Greater than 10", FALSE)
=IF(A1 > 10, "Greater than 10")
				
			

These formulas check if the value in A1 is greater than 10. If true, they return “Greater than 10”. The first two use FALSE() and FALSE explicitly for the false value, while the third omits the value_if_false argument, implicitly using FALSE.

Additional Notes

  • Using FALSE() is functionally identical to using the logical value FALSE.
  • Logical expressions in Excel inherently return either TRUE or FALSE.
  • The explicit use of FALSE or FALSE() can make logical formulas easier to understand.

Related Functions

Excel TRUE function

The Excel TRUE function returns the logical value TRUE, enhancing formula clarity and readability without requiring arguments.

Excel IF function

The Excel IF function checks a condition to return values for TRUE or FALSE outcomes, ideal for dynamic decision-making.

Content Navigation