Regular

The familiar spreadsheet functions, with identical syntax. In Adaptam they work on cell references and directly on data from your data sets.

Function	Description
ABS	Returns the absolute value of a number — the number without its sign.
ACOS	Returns the arccosine (inverse cosine) of a number, in radians. Accepts values from -1 to 1.
ACOSH	Returns the inverse hyperbolic cosine of a number.
ACOT	Returns the arccotangent (inverse cotangent) of a number, in radians.
ACOTH	Returns the inverse hyperbolic cotangent of a number.
AND	Returns TRUE if all inputs are TRUE.
ARABIC	Converts a Roman numeral to a regular number.
ASIN	Returns the arcsine (inverse sine) of a number, in radians. Accepts values from -1 to 1.
ASINH	Returns the inverse hyperbolic sine of a number.
ATAN	Returns the arctangent (inverse tangent) of a number, in radians.
ATANH	Returns the inverse hyperbolic tangent of a number. Accepts values between -1 and 1 (exclusive).
AVERAGE	Average of numeric values in cells, ranges, or data fields. Non-numeric values (text, blanks, errors) are ignored.
BIN_TO_HEX	Converts a binary number to hexadecimal.
CEILING	Rounds a number up to the nearest integer.
CHAR	Converts a numeric character code (1-255) to its character. The inverse of CODE.
CLEAN	Removes all non-printable characters from text.
CODE	Numeric code of the first character in a text string. The inverse of CHAR.
CONCAT	Combines multiple inputs into one text value in the order provided.
COS	Returns the cosine of a number (in radians).
COSH	Returns the hyperbolic cosine of a number.
COT	Returns the cotangent of a number (in radians).
COTH	Returns the hyperbolic cotangent of a number.
COUNT	Count of numeric values in cells, ranges, or data fields. Non-numeric values (text, blanks, errors) are ignored.
CSC	Returns the cosecant of a number (in radians).
CSCH	Returns the hyperbolic cosecant of a number.
DATE	Creates a date from separate year, month, and day values.
DAY	Returns the day of the month (1–31) for a date.
DAYS_BETWEEN	Calculates the number of days between two dates.
DAYS_WORK	Calculates the number of weekdays between two dates, inclusive.
DEC_TO_BIN	Converts a decimal number to binary.
DEC_TO_HEX	Converts a decimal number to hexadecimal.
DEC_TO_OCT	Converts a decimal number to octal.
DEGREES	Converts radians to degrees.
EVEN	Rounds a number to the nearest even integer away from zero.
EXP	Returns e (Euler's number, approximately 2.71828) raised to the power of the input.
FACT	Factorial of a number.
FACT_DOUBLE	Returns the double factorial of a number.
FLOOR	Rounds a number down to the nearest integer.
HEX_TO_BIN	Converts a hexadecimal number to binary.
IF	Returns one value when a condition is met, and a different value when it's not.
INT	Integer portion of a number, rounded toward negative infinity (not toward zero).
IRR	Returns the internal rate of return for a series of cash flows occurring at regular periods.
IS_BLANK	Returns TRUE if the specified value or cell is empty, otherwise FALSE.
IS_DATE	Returns TRUE if the referenced value or cell contains a date, otherwise FALSE.
IS_ERROR	Returns TRUE if the referenced cell contains an error, otherwise FALSE.
IS_EVEN	Returns TRUE if the referenced value or cell contains an even number, otherwise FALSE.
IS_LOGICAL	Returns TRUE if the referenced cell contains TRUE or FALSE, otherwise FALSE.
IS_NOT_BLANK	Returns TRUE if the specified value or cell is not empty, otherwise FALSE.
IS_NUMBER	Returns TRUE if the referenced value or cell contains a number, otherwise FALSE.
IS_ODD	Returns TRUE if the referenced value or cell contains an odd number, otherwise FALSE.
IS_TEXT	Returns TRUE if the referenced value or cell contains text, otherwise FALSE.
ISO_WEEK_NUM	ISO week number of a date value.
LEN	Number of characters in the input, including spaces.
LN	Natural logarithm of a number (base e) — the inverse of EXP.
LOG_10	Base 10 logarithm of a number — the power to which 10 must be raised to produce it.
LOWER	Converts all uppercase letters in a text string to lowercase.
MAX	Maximum numeric value in cells, ranges, or data fields. Non-numeric values (text, blanks, errors) are ignored.
MEDIAN	Median (middle) numeric value in cells, ranges, or data fields. Non-numeric values (text, blanks, errors) are ignored.
MIN	Minimum numeric value in cells, ranges, or data fields. Non-numeric values (text, blanks, errors) are ignored.
MODE	Most frequent value in cells, ranges, or data fields. Blanks are ignored.
MONTH	Returns the month of a date as a combined number and abbreviation, like 04_Apr.
MONTH_END	Last date of the month for a date value.
MONTH_START	First date of the month for a date value.
NOT	Reverses the logical value of its argument.
NPV	Returns the net present value of a series of future cash flows using a discount rate.
ODD	Rounds a number to the nearest odd integer away from zero.
OR	Returns TRUE if any input is TRUE.
PROPER	Converts text to title case.
QUARTER	Returns the calendar quarter (Q1, Q2, Q3, or Q4) for a date.
RADIANS	Converts degrees to radians.
RAND	Random decimal number between 0 and 1.
RAND_BETWEEN	Returns a random number between the bottom and top values.
ROMAN	Converts a regular number to a Roman numeral.
ROUND	Rounds a number to the nearest integer. Halves round away from zero.
ROUND_DOWN	Rounds a number toward zero to an integer.
ROUND_UP	Rounds a number away from zero to an integer.
SEC	Returns the secant of a number (in radians).
SECH	Returns the hyperbolic secant of a number.
SIGN	Sign of a number (-1, 0, or 1).
SIN	Returns the sine of a number (in radians).
SINH	Returns the hyperbolic sine of a number.
SQRT	Square root of a positive number.
SQRT_PI	Square root of a number multiplied by pi — i.e., √(π * x).
SUM	Sum of numeric values in cells, ranges, or data fields. Non-numeric values (text, blanks, errors) are ignored.
TAN	Returns the tangent of a number (in radians).
TANH	Returns the hyperbolic tangent of a number.
TRIM	Removes leading and trailing spaces from text.
TRUNC	Truncates a number to an integer by removing the decimal portion.
UPPER	Converts all lowercase letters in a text string to uppercase.
WEEKDAY	Day of week number and abbreviation of a date value.
YEAR	Returns the year of a date as a four-digit number.