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