 # Simplify formula writing

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.

# Honeycode functions

Function Description Parameters
FILTER Returns any rows that match the filter conditions. table, condition, [condition_parameters, ...]
FILTERDIFF Returns rows that are unique to the first filter. filter, filter
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, ...]
GETROW Returns a rowlink based on an offset to a specific row. table, offset, linked_row
INDEXROW Returns a rowlink by index in a specific domain. table, index
ISREF Tests if the argument is a reference to a cell or range of cells. value
ROWS Returns the number of rows in a given reference. reference
THISROW Returns a rowlink to the selected cell in a table. THISROW does not use arguments

# 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
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. yvalues, xvalues
IPMT Returns the interest payment amount for a loan. rate, period, number_of_periods, total_value, [final_value, type]
IRR Calculates the internal rate of return of a series of cash flows.
ISBLANK Returns TRUE if input is empty. value
ISERR Tests for an error value and returns TRUE if the value refers to or evaluates to an error value, except #N/A. value
ISERROR Tests for any error value and returns TRUE if value refers to or evaluates to any error value, including #N/A. value
ISLOGICAL Tests if a cell contains a logical value, TRUE or FALSE. value
ISNA Tests for the #N/A (Not Available) error value. value
ISNONTEXT Tests if a cell contains no text. value
ISNUMBER Tests if a cell contains a number. value
ISREF Tests if the argument is a reference to a cell or range of cells. value
ISTEXT Tests if a cell contains text. value

# L

Function Description Parameters
LARGE Returns the nth largest value in a list of numbers. numberlist, n
LEFT Returns text from the left side of a text string. text, number
LEN Returns the length of a text string. text
LN Returns the natural logarithm of a number. number
LOG Returns the logarithm of a number to the specified base. number, base
LOG10 Returns the base-10 logarithm of a number. number
LOWER Converts a text string to lowercase. text

# M

Function Description Parameters
MATCH Returns the position of a search item in a single row or column table. searchitem, searchregion, matchtype
MAX Maximum value in a range. number1, [number2, ...]
MAXA Returns the maximum of a list of arguments, including text and logical entries. value1, [value2, ...]
MEDIAN Returns the median of a set of numbers. number1, [number2, ...]
MID Returns text from the middle of a text string. text, start, number
MIN Minimum value in a range. value1, [value2, ...]
MINA Returns the minimum of a list of arguments, including text and logical entries. value1, [value2, ...]
MINUTE Returns the minutes of a given time. time
MIRR Returns the modified internal rate of return. values, finance_rate, reinvest_rate
MOD Returns the remainder when one integer is divided by another. number, divisor
MODE Returns the most common value in a set of numbers. number1, [number2, ...]
MONTH Returns the month of a given date. date

# N

Function Description Parameters
NA Returns the #N/A "Not Available" error value.
NORMSDIST Calculates values for the cumulative distribution function of a normal distribution. x
NOT Reverses the logical value. value
NOW Returns the current date and time
NPER Returns the number of payments required to pay off a loan. rate, payment_amount, total_value, [final_value], [type]
NPV Returns the net present value of an investment. rate, cashflow

# O

Function Description Parameters
ODD Rounds a number up, away from zero, to the next odd integer. number
OFFSET Returns a modified reference, given a reference, an offset, and a desired size. reference, row_offset, col_offset, new_height, new_width
OR Logical OR operator. logical_value1, [logical_value2, ...]
ORDER BY Sorts a list by the specified table column. table[column]

# P

Function Description Parameters
PERCENTILE Returns a specified percentile in a list of numbers. numberlist, fraction
PI Returns mathematical PI
PMT Returns the periodic payment amount for a loan. rate, number_of_periods, total_value, [final_value, type]
POISSON Calculates values for a Poisson distribution. x, lambada, mode
POWER Returns a number raised to a power. number, number
PPMT Returns the principal payment amount for a loan. rate, period, number_of_periods, total_value, [final_value, type]
PRODUCT Multiplies all the numbers given as arguments and returns the product. number1, [number2, ...]
PROPER Returns text with words in lowercase after a capitalised first letter. text

# R

Function Description Parameters
RAND Returns a random number between 0 and 1.
RANK Returns the rank of a number in a list of numbers. number, numberlist, [order]
REPLACE Replaces part of a text string with a different text string. orignaltext, startposition, length, newtext
REPT Repeats characters a specified number of times. text, number
RIGHT Returns text from the right side of a text string. text, number
ROMAN Returns a Roman numeral (eg XIV) as text, given a number. number, [mode]
ROUND Rounds a number to a decimal place or integer. number, [places]
ROUNDDOWN Rounds a number down, toward zero, to a certain precision. number, [places]
ROUNDUP Rounds a number up, away from zero, to a certain precision. number, [places]
ROW Returns the row number(s), given a reference. reference
ROWS Returns the number of rows in a given reference. reference

# S

Function Description Parameters
SEARCH Returns the position of a string of text within another string. findtext, texttosearch, [startposition]
SECOND Returns the seconds of a given time. time
SIGN Returns the sign of a number:- 1 if the number is positive, -1 if negative and 0 if zero. number
SIN Returns the sine of the given angle (in radians). angle
SINH Returns the hyperbolic sine of a number. number
SLOPE Fits a straight line to data using linear regression and returns its slope. yvalues, xvalues
SMALL Returns the nth smallest value in a list of numbers. numberlist, n
SQRT Returns the positive square root of a number. number
STDEV Returns the sample standard deviation of the arguments. number1, [number2, ...]
SUBSTITUTE Substitutes new text for old text in a text string. originaltext, oldtext, newtext, [which]
SUBTOTAL Returns the result for a specified function applied to a range. function_num, range
SUM Sum value of the arguments logical_value1, [logical_value2, ...]
SUMIF Sum value of the arguments that meet a single criteria. range, criteria, [sum_range]
SUMIFS Sum of the arguments that meet multiple criteria. sum_range, criteria_range1, criteria1, [criteria_range2, criteria2, ...]
SUMPRODUCT Returns the sum of the products of corresponding array elements. array1, [array2,....]
SUMSQ Returns the sum of the squares of the arguments. number1, [number2, ...]
SUMX2MY2 Returns the sum of the differences between corresponding squared elements of two matrices. x, y
SUMX2PY2 Returns the sum of the squares of all elements of two matrices. x, y
SUMXMY2 Returns the sum of the squared differences between corresponding elements of two matrices. x, y

# T

Function Description Parameters
T Returns the given text, or an empty text string if the target is not text. value
TAN Returns the tangent of the given angle (in radians). angle
TANH Returns the hyperbolic tangent of a number. number
TEXT Converts a number into text according to a given format. number, format
THISROW Returns a rowlink to the selected cell in a table. THISROW does not use arguments.
TIME Returns the time, given hours, minutes and seconds. hours, minutes, seconds
TODAY Returns the current date
TRIM Remove spaces from input text. text
TRUE Returns the boolean value TRUE.
TRUNC Truncates a number by removing decimal places. number, [places]
``````                                                    |
``````

# U

Function Description Parameters
UPPER Converts a text string to uppercase. text

# V

Function Description Parameters
VALUE Returns a number, given a text representation. text
VAR Returns the sample variance. number1, [number2, ...]
VARP Returns the population variance. number1, [number2, ...]
VLOOKUP Search for a row and return a specified column. value, range, index_number, [approx_match]

# W

Function Description Parameters
WEEKDAY Returns a number that corresponds to the day of the week. date

# X

Function Description Parameters
XOR Logical XOR operation boolean1, [boolean2]

# Y

Function Description Parameters
YEAR Returns the year of a given date. date