PROVIDING ACCURATE, RELIABLE AND STRAIGHT TO THE POINT KNOWLEDGE ABOUT DIFFERENT IT TOOLS EXPLAINED WITH PRACTICAL EXAMPLES
Menu
CONTENTS
EXCEL FUNCTIONS-FALSE
INTRODUCTION
A special situation may arise in EXCEL while creating any condition or function or formula, when we need to directly pass the boolean FALSE to the function. For such conditions FALSE FUNCTION is given.
FALSE function is simply the binary false i.e. 0.
It can be said that FALSE FUNCTION returns the boolean FALSE.
They can be directly used in the sheet and can be directly given to any any variable.
PURPOSE OF FALSE IN EXCEL
FALSE FUNCTION RETURNS THE LOGICAL FALSE .
IT IS SIMPLY A BOOLEAN VALUE AND CAN BE USED DIRECTLY IN THE FUNCTIONS OR CAN BE PASSED TO ANY VARIABLE.
SYNTAX:FALSE FUNCTION
The Syntax for the FALSE function is
=FALSE() or FALSE
Both ways can be used
EXAMPLE:FALSE FUNCTION IN EXCEL
DATA SAMPLE
Suppose we have a set of questions which has binary answer that is TRUE or FALSE.
For such cases , we can make use of this function.
For example, we have a two part question.
Suppose two values are given in cell B5 and C5. The given values are random.
1. If the value in B5 is >=20.
2. If the value of C5 is =B5.
STEPS TO USE FALSE
The example shows the two conditional situations.
We have used the following functions.
1. If the value in B5 is >=20.
=IF(B5>=20,TRUE,FALSE)
Check the value of B5, if greater than 20, return TRUE else FALSE. This FALSE can be directly used as an input for another functions.
2. If the value of C5 is =B5.
=IF(C5=B5,TRUE,FALSE)
Check the value of C5, if equal to B5, return the TRUE else FALSE. The FALSE is a logical false, and can be used in function.
OTHER WAYS TO REACH THIS ARTICLE
WHAT IS EXCEL, HOW EXCEL WORKS, WRITE FORMULA IN EXCEL, EXAMPLE OF USING FORMULA IN EXCEL, ANIMATED EXAMLPE OF USING FORMULA IN EXCEL
YOU MAY LIKE
- HOW TO TROUBLESHOOT A FORMULA IN EXCEL?
- USE OF FONTS, FONT SIZE, INDENTATION, TEXT TO THE RIGHT, TEXT TO THE LEFT, TEXT IN THE MIDDLE ETC.
- how to insert table in excel?
- FOR MORE ARTICLES, CLICK EXCEL OR TYPE IN SEARCH BELOW.