Excel False Function

This post will guide you how to use Excel FALSE function with syntax and examples in Microsoft excel.

Table of Contents

Description

The Excel FALSE function returns the logical value “FALSE”.

The FALSE function is a build-in function in Microsoft Excel and it is categorized as a Logical Function.

The FALSE function is available in Excel 2016, Excel 2013, Excel 2010, Excel 2007, Excel 2003, Excel XP, Excel 2000, Excel 2011 for Mac.

Syntax

The syntax of the FALSE function is as below:

=FALSE()

Example

The below examples will show you how to use Excel FALSE Function to return the logical value FALSE.

#1 To get False value in B1 Cell, just using the following excel formula: =FALSE()

excel false function example1


Related Functions

  • Excel TRUE function
    The Excel TRUE function return the logical value TRUE. And you can use the TRUE function when you want to return the TRUE value. For example, the formula: =IF(B1>5, TRUE()).The syntax of the TRUE function is as below:=TRUE ()…
Related Posts

Excel OR Function

This post will guide you how to use Excel OR function with syntax and examples in Microsoft excel. Description The Excel OR function used to test multiple conditions and returns TRUE if any of the conditions are TRUE. Otherwise, it ...

Excel NOT Function

This post will guide you how to use Excel NOT function with syntax and examples in Microsoft excel. Description The Excel NOT function returns the opposite of a given logical or Boolean value. For example, if you supplied with the ...

Excel IF function check if the cell is blank or not-blank

If you want to check the value in one cell if it is blank or empty cell, then you can use IF function in combination with ISBLANK function or logical operator (equal to) in excel. Excel IF function check if ...

Excel IF Function With Dates

If you have a list of dates and then want to compare to these dates with a specified date to check if those dates is greater than or less than that specified date. You can use the IF function in ...

Excel IF function with text values

Normally, If you want to write an IF formula for text values in combining with the below two logical operators in excel, such as: “equal to” or “not equal to”. Excel IF function check if a cell contains text(case-insensitive) By default, ...

Comments

So empty here ... leave a comment!

Leave a Reply

Sidebar