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

  1. =TRUEVALUE(0) = false
  2. =TRUEVALUE(103) = true
  3. =TRUEVALUE((2+7)>8) = true
  4. =TRUEVALUE(-6.6) = true
  5. =TRUEVALUE("*")= true
  6. =TRUEVALUE(true) = true


Related Videos

TRUE function


See Also


References