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
acos(). number(). format-date(). Location Functions. string(). utctoday(). cos(). Excel Financial Functions. today(). asin(). globalval(). param1(). Mathematical Functions. ‘.’ (dot). utcnow(). Logic. counter(). pi(). Contextual Functions. Date/Time Functions.