EDUCBA Logo

EDUCBA

MENUMENU
  • Explore
    • EDUCBA Pro
    • PRO Bundles
    • Featured Skills
    • New & Trending
    • Fresh Entries
    • Finance
    • Data Science
    • Programming and Dev
    • Excel
    • Marketing
    • HR
    • PDP
    • VFX and Design
    • Project Management
    • Exam Prep
    • All Courses
  • Blog
  • Enterprise
  • Free Courses
  • Log in
  • Sign Up
Home Excel Excel Resources Logical Functions in Excel Tutorial FALSE Function in Excel
 

FALSE Function in Excel

Madhuri Thakur
Article byMadhuri Thakur

FALSE Function in Excel

FALSE Function in Excel (Table of Contents)
  • Introduction to FALSE Function in Excel
  • Examples of FALSE Function

Introduction to FALSE Function in Excel

The FALSE function in Microsoft Excel is widely used. It is categorized under logical function/logical expression. The reason because it provides logical output. The one is the same as YES, NO, or 1, 0. It is a logical value for all such scenarios where the absence of anything or the non-possibility of any event occurs. FALSE is a compatibility function in Excel; therefore, it does not need to be called explicitly. It represents the Boolean value 0 (As in Boolean logic, TRUE =1 and FALSE = 0). This function can be widely used within conditional statements like IF, IFERROR, etc.

 

 

The syntax for the FALSE function is as below:

Watch our Demo Courses and Videos

Valuation, Hadoop, Excel, Mobile Apps, Web Development & many more.

False function syntax

  • This function does not have an argument and provides a logical FALSE value in a given Excel sheet. It is added under Excel primarily for maintaining compatibility with other worksheets as well as spreadsheet programs. This is similar to writing FALSE in any cell of your Excel worksheet. This means you do not even need to call this function. It can just be typed.

You can also find this function under the Logical category inside the Functional Library present in the Formulas tab in the Excel ribbon.

False - Function

Examples of FALSE Function

Let’s take some examples to get going with the Excel FALSE function.

You can download this FALSE Function Excel Template here – FALSE Function Excel Template

Example #1 – Using Logical Function’s Library

Step 1: Inside the given Excel sheet, click on the “Formulas” tab, and you will see a list of different Functional Libraries. Out of those, navigate to Logical and click on the drop-down arrow. A list of logical functions will appear. From there, select “FALSE” or click on “FALSE”.

False function in excel 1-1

Step 2: As soon as you select and click on the FALSE function in your active cell formula FALSE will appear automatically, and with that, there will be a “Functional Arguments” window popping up, which consists of all the info associated with the FALSE function. Click OK in that pop-up window. It will return the logical FALSE as output in your working cell.

False function in excel 1-2

Step 3: You can directly type FALSE in your active sheet or =FALSE() to get the logical FALSE value. See the screenshot below.

False function in excel 1-3

All these three methods are equivalent to each other for getting a logical FALSE value.

Example #2 – Using Logical Conditions in FALSE Function

We can use the FALSE function as an output to the logical conditions. Ex. Whether or not the given number is less than or greater than a particular number. We will see it step by step in the example below:

Step 1: Type any number in cell A2 of your working sheet. I will choose the number 32 and type it under cell A2.

False function in excel 2-1

Step 2: In cell B2, put a logical condition that checks whether 32 is less than 20 or not. You can type the following code under D2. =A2 < 20

False function in excel 2-2

Step 3: Press Enter key to see the output of this formula. As we can see, the value present in cell A2 (i.e. 32) is not less than 20; therefore, the system will return logical FALSE as an output.

False function in excel 2-3

Similarly, you can get the output as FALSE when you check whether a value in cell A2 is greater than 50. I will leave it up to you to give it a try for this.

Example #3 – Using Mathematical Operations in FALSE Function

A FALSE function is a logical function equivalent to its Boolean value numeric zero (0). Therefore, all mathematical operations are possible with the FALSE function like we do those with numeric zero (0).

Step 1: Type the formula below in cell A2 of your active Excel sheet and press the Enter Key.

=FALSE() + 12

FALSE example 3-1

You get answer equivalent to (0 + 12).

FALSE example 3-2

Step 2: In cell A3 of the active Excel sheet, type the following formula and press Enter.

=FALSE() – 12

FALSE example 3-3

You’ll get output equivalent to (0 – 12).

FALSE example 3-4

Step 3: In cell A4 of the active Excel worksheet, put the following formula and press the Enter key.

=FALSE() * 12

FALSE example 3-5

Since FALSE is equivalent to numeric zero, any number multiplied to it will be returning zero.

FALSE example 3-6

Step 4: In cell A5 of your active Excel sheet, use the formula below and press the Enter key.

=FALSE() / 12

FALSE example 3-7

Again the same logic. As FALSE is equivalent to a numeric zero, the division of FALSE and any number would return a value of zero.

FALSE example 3-8

Example #4 – Using FALSE Function Under Logical Statements or Conditions

We frequently use the FALSE function under logical statements or conditions such as IF under Excel.

Step 1: In cell A2 of the active Excel sheet, put the number we want to check under the logical IF condition.

false example 4-1

Step 2: Use the logical IF condition to check whether this number is less than 1. If it is less than 1, the output should be TRUE. Else, the output should be FALSE. Use the following conditional formula under cell C2 of the active worksheet. =IF(A2 < 1, TRUE, FALSE)

false example 4-2

Press Enter key to see the output.

false example 4-3

Since the condition A2 < 1 does not meet in this example, the system will generate an output as FALSE, equivalent to the FALSE function in Excel. Now, suppose we wanted the result as FALSE when A2 > 1; then, we can do it directly in the IF condition without using the else part with the help of the FALSE function.

In cell B3 of the active Excel sheet, put the following formula. =IF(A2 > 1, FALSE())

false example 4-4

Press the Enter key.

false example 4-5

Here we have checked that if the value under cell A2 is greater than 1, it will give the output as FALSE directly. This example emphasizes that we can use the FALSE function within conditional outputs.

This is from this article. Let’s wrap things up with some points to be remembered.

Things to Remember About FALSE Function in Excel

  • FALSE is equivalent to a numeric zero.
  • The FALSE function does not require any argument to be called under Excel.
  • This function does not even need parentheses to be added under it. This means FALSE and FALSE() are identical.

Recommended Articles

This is a guide to FALSE Function in Excel. Here we discuss How to use the FALSE Function in Excel, practical examples, and a downloadable Excel template. You can also go through our other suggested articles –

  1. EOMONTH Function Excel
  2. COUNTA Function in Excel
  3. MAX Formula in Excel
  4. Logical Functions in Excel

Primary Sidebar

Footer

Follow us!
  • EDUCBA FacebookEDUCBA TwitterEDUCBA LinkedINEDUCBA Instagram
  • EDUCBA YoutubeEDUCBA CourseraEDUCBA Udemy
APPS
EDUCBA Android AppEDUCBA iOS App
Blog
  • Blog
  • Free Tutorials
  • About us
  • Contact us
  • Log in
Courses
  • Enterprise Solutions
  • Free Courses
  • Explore Programs
  • All Courses
  • All in One Bundles
  • Sign up
Email
  • [email protected]

ISO 10004:2018 & ISO 9001:2015 Certified

© 2025 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA
Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

By continuing above step, you agree to our Terms of Use and Privacy Policy.
*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you

EDUCBA

Download FALSE Function Excel Template

EDUCBA Login

Forgot Password?

EDUCBA

Download FALSE Function Excel Template

EDUCBA

डाउनलोड FALSE Function Excel Template

🚀 Limited Time Offer! - 🎁 ENROLL NOW