Boolean

Syntax

Function:
  • BOOLEAN(val)
Parameters:
  • val = given value
Outputs:
  • a number
Description:
  • Convert a value to a boolean
Used:
in a Formula BuilderFormula Builder

 

Example
Result
Note
BOOLEAN(20) 0.91294525072
BOOLEAN(val) -0.62988799427 val = 81
BOOLEAN(val) 0.35496653913 val = 547
random(). Generate a Unique ID Code. atan(). Functions Table. userfirstname(). asin(). Create a Formula. Advanced Math. Data Conversion. userlastname(). Excel Financial Functions. cos(). globalval(). ‘.’ (dot). sqrt(). utcnow(). counter(). cosh(). Repeats. logarithm().