Difference between revisions of "Manuals/calci/FALSEVALUE"
Jump to navigation
Jump to search
(Created page with "<div style="font-size:30px">'''FALSEVALUE(Value)'''</div><br/> *where <math>Value</math> is the value to be checked. == Description == *FALSEVALUE() function checks whethe...") |
|||
Line 1: | Line 1: | ||
− | + | =FALSEVALUE(Value)= | |
*where <math>Value</math> is the value to be checked. | *where <math>Value</math> is the value to be checked. |
Latest revision as of 17:18, 4 February 2020
FALSEVALUE(Value)
- where is the value to be checked.
Description
- FALSEVALUE() function checks whether the entered value is 'false value' or not.
- Output is returned as true only when is equal to zero. Else it returns the output as false.
- can be numeric or text value. Text or symbols should be entered in double quotes.
Examples
- =FALSEVALUE(0) = true
- =FALSEVALUE(42) = false
- =FALSEVALUE((2+7)>8) = false
- =FALSEVALUE(0.5) = false
- =FALSEVALUE("d")= false
- =FALSEVALUE(false) = true
Related Videos
See Also
References