Manuals/calci/TRUEVALUE
TRUEVALUE(Value)
- where is the value to be checked.
Description
- TRUEVALUE() function checks whether the entered value is 'true value' or not.
- Output is returned as true when is not 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
- =TRUEVALUE(0) = false
- =TRUEVALUE(103) = true
- =TRUEVALUE((2+7)>8) = true
- =TRUEVALUE(-6.6) = true
- =TRUEVALUE("*")= true
- =TRUEVALUE(true) = true
Related Videos
See Also
References