Think of a function as a kind of built-in formula. Honeycode supports many common functions you may be familiar with. But, you'll also find some new ones that are totally unique to Honeycode.
To make formula writing even simpler, Honeycode provides suggestions as you type. This feature works anywhere you'd enter a formula, just activate it by typing the = sign.
Returns a rowlink to the selected cell in a table.
THISROW does not use arguments
Common functions
A
Function
Description
Parameters
ABS
Returns the absolute value of a number. The absolute value of a number is its value without the +/- sign.
number
ACOS
Returns the inverse cosine (the arccosine) of a number. The angle returned is between 0 and PI.
number
ACOSH
Returns the inverse hyperbolic cosine of a number. Number must be greater than or equal to 1.
number
ADDRESS
Returns a cell reference as text, given row and column numbers. Mode (optional) determines whether the cell address is absolute or relative. If omitted, it is assumed to be 1.
row, column, [mod], [type], [sheet]
AND
Logical AND operator. Returns TRUE if all the arguments are considered TRUE, and FALSE otherwise.
argument1, [argument2, ...]
ANY
Returns TRUE if first argument matches any subsequent arguments. ANY is case-sensitive.
argument1, argument2, [argument3, ...]
ASIN
Returns the inverse sine (the arcsine) of a number. The angle returned is between -PI/2 and +PI/2.
number
ASINH
Returns the inverse hyperbolic sine of a number.
number
ATAN
Returns the inverse tangent (the arctangent) of a number. The angle returned is between -PI/2 and PI/2.
number
ATAN2
Returns the inverse tangent (the arctangent) for specified x and y coordinates. The angle returned is between -PI and PI.
x_coord, y_coord
ATANH
Returns the inverse hyperbolic tangent of a number.
number
AVEDEV
Returns the average of the absolute deviations of values from their mean.
number1, [number2, ...]
AVERAGE
Returns the average of the arguments, ignoring text.
number1, [number2, ...]
AVERAGEIF
Returns the average of arguments that meet a single criteria.
range, criteria, [average_range])
C
Function
Description
Parameters
CEILING
Returns a number rounded up to a multiple of another number.
number, [mult]
CHAR
Returns a single text character, given a character code.
number
CHOOSE
Returns a value from a list, given an index number. Value may text, a number, a logical value, a reference, or a formula.
index, value1, [value2, ...]
CLEAN
Returns text with all non-printable characters removed. Spaces are not removed.
text
CODE
Returns the numeric code for the first character in a text string.
text
COLUMN
Returns the number of columns in a given reference.
reference
COLUMNS
Returns the number of columns in a given reference.
reference
COMBIN
Returns the number of combinations of a subset of items.
number1, number2
CONCATENATE
Combines several text strings into one string.
text1, [text2, ...]
COS
Returns the cosine of the given angle in radians.
number
COSH
Returns the hyperbolic cosine of a number.
number
COUNT
Returns the number of numeric values in a range.
value1, [value2, ...]
COUNTA
Returns the number of any values in a range.
value1, [value2, ...]
COUNTBLANK
Returns the number of empty values in a range.
value1, [value2, ...]
COUNTIF
Returns the number of numeric values that meet multiple criteria.
range, criteria
COUNTIFS
Count of numbers that meet multiple criteria.
range1, criteria1, [range2, criteria2, ...]
D
Function
Description
Parameters
DATE
Returns the date, given the year, month and day of the month.
year, month, day
DATEDIF
Returns the number of days, months, or years between two dates. The input should be "D" for days, "M" for months, and "Y' for years.
start_date, end_date, unit
DAY
Returns the date as a number (M-DD).
date
DAYS
Returns the number of days between two dates
enddate, startdate
DAYS360
Returns the number of days between two dates, using the 360 day year.
enddate, startdate
DEGREES
Converts radians into degrees.
radians
DEVSQ
Returns the sum of squares of deviations from the mean.
number1, [number2, ...]
DOLLAR
Returns text representing a number in your local currency format.
number, decimals
E
Function
Description
Parameters
ERROR.TYPE
Returns a number that corresponds to an error type. If there are no errors, ERROR.TYPE returns #N/A. ERROR.TYPE can be used in an IF function to return a custom message.
value
EVEN
Returns number rounded to the next even integer up from zero.
number
EXACT
Returns TRUE if the text strings text1 and text2 are exactly the same. EXACT is case-sensitive.
text1, text2
EXP
Returns the mathematical exponent raised to the power of the number.
number
F
Function
Description
Parameters
FACT
Returns the factorial of a number.
number
FALSE
Returns the boolean value FALSE.
FILTER
Returns any rows that match the filter conditions. Conditions can be combined using AND or OR.
table, condition, [condition_parameters, ...]
FILTERDIFF
Compares two filter arguments and returns rows that are unique to the first filter.
filter, filter
FIND
Returns the position of a string of text within another string.
findtext, texttosearch, [startposition]
FINDLASTROW
Returns the last row that matches the condition. The first parameter can be a filter or table.
table, condition, [condition_parameters, ...]
FINDROW
Returns the first row that matches the condition. The first parameter can be a filter or table.
table, condition, [condition_parameters, ...]
FIXED
Returns a number as text with a specified format.
number, decimals, omitseparators
FLOOR
Returns the nearest integer less than or equal to the input value. If the input value is 0 or omitted, FLOOR rounds down to the nearest negative number.
number, mult, [mode]
FV
Returns the future value of an initial sum with a subsequent stream of payments.
rate, numperiods, payment, presentvalue
G
Function
Description
Parameters
GETROW
Returns a rowlink based on an offset set to a specific row within a table or expression. Any positive or negative integer can be used.
table, offset, linked_row
H
Function
Description
Parameters
HLOOKUP
Searches horizontally across the first row of a range. When the search value is found, a value is returned from the specified row in the matching column.
value, range, index_number, [approx_match]
HOUR
Returns the hour of a given time as a number 0-23.
time
I
Function
Description
Parameters
IF
Returns a value based on an EITHER/OR condition.
expression, value_if_true, value_if_false
IFERROR
Returns a specific value if the first argument evaluates to error.
value, value_if_error
INDEX
Returns the value in a table or range.
range, row_num, [col_num]
INDEXROW
Returns the rowlink by index in a specific domain
table, index
INDIRECT
Returns a reference, given a text string.
textref
INT
Rounds a number down to the nearest integer.
number
INTERCEPT
Fits a straight line to data using linear regression and returns its intercept on the y-axis.