How to use the FALSE function
The FALSE function returns the logical (boolean) value FALSE.
Table of Contents
1. FALSE Function Syntax
=FALSE()
2. FALSE Function Arguments
The FALSE function has no arguments.
3. FALSE Function Example
Excel interprets the boolean value FALSE exactly the same as =FALSE(), you most often don't need the FALSE function. It exists primarily for compatibility with other software.
Formula in cell C3:
Explaining formula
Step 1 - Logical expression
The equal sign lets you compare value to another value.
1=2
returns FALSE.
Step 2 - Evaluate IF Function
The IF function returns one value if the logical test is TRUE and another value if the logical test is FALSE.
IF(logical_test, [value_if_true], [value_if_false])
IF(1=2, TRUE(), FALSE())
becomes
IF(FALSE, TRUE(), FALSE())
and returns FALSE(). FALSE() returns FALSE.
'FALSE' function examples
The following 28 articles contain the FALSE function.
Introduction In this post I am creating a spreadsheet that will calculate stock portfolio performance. To do this I am […]
The drop down calendar in the image above uses a "calculation" sheet and a named range. You can copy the drop-down […]
I read an interesting blog post Is A Particular Word Contained In A Text String? on Spreadsheetpage. That inspired me […]
Question: I want a unique distinct list to be created from a column where an adjacent column has text cell […]
AJ Serrano asks: I have a column where each rows contains different values and I wanted to obtain the duplicate […]
Murlidhar asks: How do I search text in cell and use a date range to filter records? i.e st.Dt D1 […]
This blog post describes how to create a list of unique words from a cell range. Unique words are all […]
Unique values are values occurring only once in cell range. This is what I am going to demonstrate in this blog […]
This article demonstrates how to apply Conditional Formatting formula to a cell range, it finds cells that are in close […]
The above picture shows you two formulas that extract names (column B) and date ranges (column C and D) based […]
This article demonstrates a worksheet that highlights lookups across relational tables. I am using Excel defined Tables, if you add […]
The chart above is built using the NORM.DIST function and is called Normal Distribution or Bell Curve chart. This curve is often […]
Nested IF statements in a formula are multiple combined IF functions so more conditions and outcomes become possible. They all are […]
I recently discovered an interesting technique about using a user defined function in a HYPERLINK function. Jordan at the Option […]
The asterisk character allows you to multiply numbers and boolean values in an Excel formula. It can also be used […]
I will in this article demonstrate how to use the VLOOKUP function with multiple conditions. The function was not built […]
This article demonstrates different formulas based on if a cell contains a given text. Formula in cell C3: =B3=$E$3 The […]
The AND function allows you to have multiple conditions in an IF function, you can have up to 254 arguments. […]
This article demonstrates how to use INDEX and MATCH functions to lookup and return multiple results. The lookup value is […]
This article demonstrates techniques on how to merge or combine two data sets using a condition. The top left data […]
I will in this article demonstrate a calendar that automatically highlights dates based on date ranges, the calendar populates names […]
This article demonstrates formulas that rearrange values in a cell range to a single column. Table of Contents Rearrange cells […]
This article explains how to repeat specific values based on a table, the table contains the items to be repeated […]
Table of Contents Sum unique numbers Get Excel *.xlsx file Sum unique distinct numbers Get Excel *.xlsx file Sum number […]
You don't need to use the IF function in a SUMPRODUCT function, it is enough to use a logical expression. […]
Mark G asks in Create a random playlist in excel: Can this example be modified to create a true round-robin […]
This article demonstrates how to sort records in a data set based on their count meaning the formula counts each […]
What's on this page Reverse text Insert random characters Convert letters to numbers How to shuffle characters in the alphabet […]
Functions in this article
Functions in 'Logical' category
The FALSE function function is one of many functions in the 'Logical' category.
How to comment
How to add a formula to your comment
<code>Insert your formula here.</code>
Convert less than and larger than signs
Use html character entities instead of less than and larger than signs.
< becomes < and > becomes >
How to add VBA code to your comment
[vb 1="vbnet" language=","]
Put your VBA code here.
[/vb]
How to add a picture to your comment:
Upload picture to postimage.org or imgur
Paste image link to your comment.
Contact Oscar
You can contact me through this contact form