EXCEL FALSE FUNCTION

The logical value FALSE is generated by this function.

Step By Step Guide of FALSE Function

There are no parameters to the FALSE function. To create the logical value FALSE, use FALSE.

To return FALSE if the value in A1 is less than zero, use the formula: =IF(A10, FALSE()).

  • Note that you may directly type the word FALSE into a cell or calculation, and Excel will treat it as the logical value FALSE.
  • These formulae, for example, are functionally identical:
    =IF(A10, FALSE()) =IF(A10, FALSE) =IF(A10, FALSE)
  • The FALSE function is largely included to provide compatibility with other spreadsheet applications.

Related Functions

HLOOKUP Function

HLOOKUP Function

Explore Now

VLOOKUP Function

VLOOKUP Function

Explore Now

INDEX Function

INDEX Function

Explore Now

MATCH Function

MATCH Function

Explore Now

DATE Function

DATE Function

Explore Now

IF Function

IF Function

Explore Now

OR Function

OR Function

Explore Now

AND Function

AND Function

Explore Now

RANK Function

RANK Function

Explore Now

SUMIF Function

SUMIF Function

Explore Now

XIRR Function

XIRR Function

Explore Now

WORKDAYS Function

WORKDAYS Function

Explore Now