How to use Excel FALSE Function

Introduction

FALSE in excel is a built in logical type function. This function is used to return logical FALSE value. It acts as a worksheet function and can be entered in cell of a worksheet.

Syntax

=FALSE( )

Arguments

There are no arguments for the FALSE.

Keynotes

  • FALSE function does not have any arguments and simply returns the Boolean FALSE value.
  • It is a compatibility function.

Examples

In this example, some numbers are entered in column A and in Column B FALSE is used with IF function to find number greater than 11, if number is greater than 11 OK is returned and if less than 11 than FALSE is returned.

Leave a Reply

Close Menu
×

Cart