Easy Explanation Notes with Examples

FALSE function in Excel

Use

The FALSE function categorized as a Logical function and primarily used for compatibility with other spreadsheet programs. The function returns the Boolean value FALSE.

What is the Boolean value?

The Boolean data type is rooted from the idea of binary logic i.e. the numeric system uses only two digits – 0 or 1. In Excel, the Boolean values are either False or True.

Syntax

FALSE()

The FALSE function’s syntax has no argument. You can also use the word False directly into a cell, instead of adding the syntax of the function. The Excel returns the same resutls.

Example

Suppose, you want the result False if A1 is not greater than 10. By using the following formula =F(A1>10,TRUE,FALSE).

The formula returns the logical value False because the value in A1 is not greater than 10.

Related Functions

AND function tests a number of logical conditions set by a user.

IF function checks whether a specified condition is met or not.

OR function tests multiple logical conditions at the same time.




Copyright © 2016 - 2019 Explainry.com | All Rights Reserved