Skip to content
Adaptam Docs
Search
Ctrl
K
Cancel
Select theme
Dark
Light
Auto
Why Adaptam?
Features
Overview
Intake
Spreadsheet
Visualizer
Chart
Table Tab
Where is...? (Excel)
Functions
Overview
Regular
Overview
ABS
ACOS
ACOSH
ACOT
ACOTH
AND
ARABIC
ASIN
ASINH
ATAN
ATANH
AVERAGE
BIN_TO_HEX
CEILING
CHAR
CLEAN
CODE
CONCAT
COS
COSH
COT
COTH
COUNT
CSC
CSCH
DATE
DAY
DAYS_BETWEEN
DAYS_WORK
DEC_TO_BIN
DEC_TO_HEX
DEC_TO_OCT
DEGREES
EVEN
EXP
FACT
FACT_DOUBLE
FLOOR
HEX_TO_BIN
IF
INT
IRR
IS_BLANK
IS_DATE
IS_ERROR
IS_EVEN
IS_LOGICAL
IS_NOT_BLANK
IS_NUMBER
IS_ODD
IS_TEXT
ISO_WEEK_NUM
LEN
LN
LOG_10
LOWER
MAX
MEDIAN
MIN
MODE
MONTH
MONTH_END
MONTH_START
NOT
NPV
ODD
OR
PROPER
QUARTER
RADIANS
RAND
RAND_BETWEEN
ROMAN
ROUND
ROUND_DOWN
ROUND_UP
SEC
SECH
SIGN
SIN
SINH
SQRT
SQRT_PI
SUM
TAN
TANH
TRIM
TRUNC
UPPER
WEEKDAY
YEAR
Regular Plus
Overview
AVERAGE_DATE
COUNT_BLANK
COUNT_DATE
COUNT_DATE_UNIQUE
COUNT_ERROR
COUNT_FALSE
COUNT_NOT_BLANK
COUNT_TEXT
COUNT_TEXT_UNIQUE
COUNT_TRUE
COUNT_UNIQUE
MAX_DATE
MAX_TEXT
MEDIAN_DATE
MIN_DATE
MIN_TEXT
New
Overview
AVERAGE_DATE_IF
AVERAGE_IF
BLANK
COUNT_BLANK_IF
COUNT_DATE_IF
COUNT_DATE_UNIQUE_IF
COUNT_ERROR_IF
COUNT_FALSE_IF
COUNT_IF
COUNT_NOT_BLANK_IF
COUNT_TEXT_IF
COUNT_TEXT_UNIQUE_IF
COUNT_TRUE_IF
COUNT_UNIQUE_IF
FORMULA_TEXT
MAX_AVERAGE
MAX_COUNT
MAX_DATE_IF
MAX_IF
MAX_SUM
MAX_TEXT_IF
MEDIAN_DATE_IF
MEDIAN_IF
MIN_AVERAGE
MIN_COUNT
MIN_DATE_IF
MIN_IF
MIN_SUM
MIN_TEXT_IF
MODE_IF
NA
SATISFY_ALL
SATISFY_ANY
SHOW
SUM_IF
VALUE_IF
Pivot Tables
Overview
DROPDOWN
DROPDOWN_MANY
WRITE_2D
WRITE_CALC_2D
WRITE_CALC_H
WRITE_CALC_V
WRITE_H
WRITE_V
Select theme
Dark
Light
Auto
HEX_TO_BIN
Converts a hexadecimal number to binary.
Examples
HEX_TO_BIN(“F”)
- Returns
1111
.
HEX_TO_BIN(“45”)
- Returns
1000101
.