How To Use FALSE Function | Microsoft Excel

how to use false function in excel

FALSE Function is used to show you the value you enter is FALSE or is not a value in applied criteria.

FLASE is randomly used function.
FALSE Function is used with other logical functions 

Syntax of FALSE Function

=FALSE()

Arguments of FALSE Function

It is a return value on the parameters used in formula or function

Behavior of FALSE Function


Here we have taken an example of the months and its figures to evaluate the FALSE Function

Here we have taken condition if the value is greater than 70 then valid otherwise it will return FALSE Function
Here JANUARY has 55 which is less than 70 so it returns FALSE Function
And APRIL has 75 which is greater than 70 so it returns VALID.

Usage of FALSE Function

FALSE Function is used with other logical functions and Generate the FALSE value

Returns of FALSE Function

FALSE Function returns the FALSE

Note

Instead of using FALSE Function you can directly write FALSE in the argument to get the FALSE value.

No comments:

Post a Comment