EDUCBA

EDUCBA

MENUMENU
  • Free Tutorials
  • Certification Courses
  • 120+ Courses All in One Bundle
  • Login
Home Excel Excel Resources Logical Functions in Excel Tutorial FALSE Function in Excel
Secondary Sidebar
Excel Functions
  • Logical Functions in Excel
    • Excel IF AND Function
    • IFERROR Formula in Excel
    • SUMIF with Multiple Criteria
    • Excel SUMIFS with Dates
    • FALSE Function in Excel
    • Excel IF Function
    • Excel Logical Test
    • Excel XOR Function
    • Logical Functions Excel
    • IFERROR Excel Function
    • TRUE Function in Excel
    • OR Function in Excel
    • NOT in Excel
    • AND Function in Excel
  • Excel Functions (12+)
  • Excel Tools (114+)
  • Financial Functions in Excel (17+)
  • Lookup and Reference Functions in Excel (35+)
  • Maths Function in Excel (47+)
  • TEXT and String Functions in Excel (26+)
  • Date and Time Function in Excel (24+)
  • Statistical Functions in Excel (59+)
  • Information Functions in Excel (4+)
  • Excel Charts (56+)
  • Excel Tips (222+)
  • Workplace Productivity (4+)
  • Microsoft Office Tools (15+)
  • Excel Formula and Functions (22+)
  • MS Excel Shortcuts (4+)
Excel Functions Courses
  • Online EXCEL ADVANCED COURSE
  • Excel Data Analysis Certification
  • Excel for Marketing Certification

FALSE Function in Excel

By Madhuri ThakurMadhuri 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

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 which 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 more widely used within conditional statements like IF, IFERROR, etc.

Start Your Free Excel Course

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

The syntax for the FALSE function is as below:

False function syntax

  • This function does not have an argument and just 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.

All in One Excel VBA Bundle(120+ Courses, 30+ Projects)
Basic ExcelAdvanced ExcelVBA & MacrosExcel Dashboards
Pivot TablesStatistical FunctionsFinancial FunctionsCharts & Graphs
Price
View Courses
120+ Online Courses | 30+ Projects | 500+ Hours | Verifiable Certificates | Lifetime Access
4.9 (64,858 ratings)

False - Function

Examples of FALSE Function

Let’s take some examples to get going with 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, 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 for FALSE will appear automatically, and with that, there would 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: In cell A2 of your working sheet, type any number. I will choose a number as 32 and type it under cell A2.

False function in excel 2-1

Step 2: In cell B2, put a logical condition which 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 clearly 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 that is equivalent to its Boolean value numeric zero (0). Therefore, all mathematical operations are possible with FALSE function the same way we do those with numeric zero (0).

Step 1: In cell A2 of your active excel sheet, type the formula as below 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 the Enter key.

=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, put the formula mentioned below and press the Enter key.

=FALSE() / 12

FALSE example 3-7

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

FALSE example 3-8

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

We are frequently using 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 which we want to check under logical IF condition.

false example 4-1

Step 2: Now, use the logical IF condition to check whether this number is less than 1 or not. 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, which is 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 IF condition without using else part with the help of 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 if the value under cell A2 is greater than 1, then it will give the output as FALSE directly. This example emphasizes that we can directly 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 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 along with 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
Popular Course in this category
Excel Training (23 Courses, 9+ Projects)
  23 Online Courses |  9 Hands-on Projects |  110+ Hours |  Verifiable Certificate of Completion
4.9
Price

View Course

Related Courses

Excel Advanced Training (16 Courses, 23+ Projects)4.9
Excel Data Analysis Training (17 Courses, 8+ Projects)4.8
Excel for Marketing Training (8 Courses, 13+ Projects)4.7
1 Shares
Share
Tweet
Share
Primary Sidebar
Footer
About Us
  • Blog
  • Who is EDUCBA?
  • Sign Up
  • Live Classes
  • Corporate Training
  • Certificate from Top Institutions
  • Contact Us
  • Verifiable Certificate
  • Reviews
  • Terms and Conditions
  • Privacy Policy
  •  
Apps
  • iPhone & iPad
  • Android
Resources
  • Free Courses
  • Excel Charts
  • Excel Tips
  • All Tutorials
Certification Courses
  • All Courses
  • Excel VBA Course - All in One Bundle
  • VBA Course
  • Excel Data Analysis Course
  • Excel for Marketing Course
  • Excel for Finance Course
  • Excel for HR Training

ISO 10004:2018 & ISO 9001:2015 Certified

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

EDUCBA
Free Excel Course

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

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

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA Login

Forgot Password?

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA
Free Excel Course

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

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

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

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

By signing up, you agree to our Terms of Use and Privacy Policy.

Let’s Get Started

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

Download FALSE Function Excel Template

EDUCBA

Download FALSE Function Excel Template

EDUCBA

डाउनलोड FALSE Function Excel Template

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more