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
globalval(). asin(). radians(). orgname(). pi(). utcnow(). Excel Financial Functions. useremail(). Contextual Functions. tan(). Repeats. format-num(). Create a Formula. round(). logarithm(). format-date(). degrees(). today(). userfirstname(). number().