What is the FALSE Function in MS Excel?

The FALSE function in MS Excel is used as a logical function. It is a sub-category of logical functions in Excel.

Purpose of FALSE Function in MS Excel

The purpose of this function in Excel is to return the logical value ‘FALSE’ when written in an empty cell. This function does not use any arguments. It is combined with other functions, such as ‘IF ‘or ‘TRUE’.

 In financial analysis data, this function becomes very useful when used in combination with the ‘TRUE’ function in Excel. It is then used for comparison as well. This function is available in Excel 2000 and all versions after that.                                                                                            

Syntax of FALSE Function

The syntax of the FALSE function in Excel is written as follows.

=FALSE ( )

Arguments

There are no arguments in the FALSE function in MS Excel.

Examples

=FALSE ()

In this example, the value returned will be ‘FALSE’. This is a Boolean value. The FALSE function can also be written directly into the cell.