Excel FALSE function returns the Boolean value FALSE. The main purpose of False Function is to generate a Logical value FALSE. The FALSE function is classified as a “compatibility function”, needed only for compatibility with other spreadsheet applications. There is no need to use FALSE() if you are creating a spreadsheet in Excel. We Shall see in detail about the Syntax, and Output of the FALSE function with an example and any other relevant details.
Excel False Function
The FALSE function is classified as a “compatibility function”, needed only for compatibility with other spreadsheet applications. There is no need to use the FALSE function if you are creating a spreadsheet in Excel. Note that logical expressions will automatically generate TRUE and FALSE results.
Syntax
= FALSE()
False Function Example
=IF(A1>100,”YES”,FALSE())
=IF(A1>100,”YES”,FALSE)
=IF(A1>100,”YES”)
All three formulas return FALSE if the value in A1 is not greater than 100. All three formulas above based on the IF function are functionally equivalent.