Excel FALSE function
In Excel, the FALSE function is a build-in function, it is categorized as logical function. It returns the value FALSE. It is as the same as to entering the Boolean value FALSE directly in a formula.
Syntax:
The syntax for the FALSE function in Excel is:
Notes:
- 1. There are no parameters or arguments in the FALSE function.
- 2. It can be applied at Excel 2000 and later version.
- 3. For calculation purpose, TRUE is a number 1 and False is a number 0, they can be used for calculation, such as:
-
TRUE+TRUE=2 FASE+TRUE=1 FALSE+FALSE=0
Return:
Returns the logical value FASLE.
Usage:
The FALSE function in Excel is a compatibility function, it always be used with other logical functions such as IF, IFERROR, etc.
Supposing, you want to check if the numbers in column A is greater than 100, if the number greater than 100, Yes returns, if not, FALSE returns.
Please apply the below formula, you will get the result as screenshot shown:
Tip: In the above formula, you can enter FALSE directly to instead the FALSE(), like this:
The Best Office Productivity Tools
Kutools for Excel - Helps You To Stand Out From Crowd
Kutools for Excel Boasts Over 300 Features, Ensuring That What You Need is Just A Click Away...
Office Tab - Enable Tabbed Reading and Editing in Microsoft Office (include Excel)
- One second to switch between dozens of open documents!
- Reduce hundreds of mouse clicks for you every day, say goodbye to mouse hand.
- Increases your productivity by 50% when viewing and editing multiple documents.
- Brings Efficient Tabs to Office (include Excel), Just Like Chrome, Edge and Firefox.
