Worksheet Calculations

What is the Worksheet?

The Worksheet is where you run calculations directly inside Albert OS. Think of it like a spreadsheet engine built into your R&D workflow — you can reference cells, write formulas, and use over 390 built-in functions to analyse your experimental data without leaving the platform.

Total supported functions: 394

How do cell references work?

When you write or edit a formula, the Worksheet automatically highlights referenced cells with colour-coded outlines. This makes it easy to see exactly which cells are included in your calculation — useful for catching errors before you commit to a result.

📂 What categories of functions are available?

Category	What it's for	Functions
🔢 Array Manipulation	Work across ranges, filter datasets	3
📅 Date and Time	Date maths, working days, time values	26
⚙️ Engineering	Base conversions, bitwise ops, complex numbers	46
ℹ️ Information	Test cell types, detect errors, check blanks	16
💰 Financial	Loans, depreciation, present/future value	27
🔀 Logical	IF/AND/OR logic, error handling	11
🔍 Lookup and Reference	VLOOKUP, INDEX/MATCH, cell addressing	13
➕ Math and Trigonometry	Arithmetic, rounding, trig, logarithms	65
🔳 Matrix Functions	Matrix multiplication, transposition, pooling	4
⚡ Operator	Low-level arithmetic and comparison (HF.*)	16
📊 Statistical	Averages, distributions, regression, variance	100+
🔤 Text	String manipulation, search, concatenation	23

🔢 Array Manipulation

Also known as: array formulas, dynamic arrays, spill formulas

Use these when you need to work across ranges or filter data based on conditions.

Function	What it does	Syntax
ARRAYFORMULA	Applies a formula across an array — like pressing Ctrl+Shift+Enter in Excel	`ARRAYFORMULA(Formula)`
FILTER	Returns only the rows that match your conditions	`FILTER(SourceArray, BoolArray1[, BoolArray2[, ...]])`
ARRAY_CONSTRAIN	Trims an array down to a specific number of rows and columns	`ARRAY_CONSTRAIN(Array, Height, Width)`

📅 Date and Time

Also known as: date functions, date difference, working days calculator, business days, elapsed time

Use these to calculate dates, measure time between events, find working days, and parse date strings.

Function	What it does	Syntax
DATE	Builds a date from year, month, and day values	`DATE(Year, Month, Day)`
DATEDIF	Gap between two dates in days, months, or years — useful for age or elapsed time	`DATEDIF(Date1, Date2, Units)`
DATEVALUE	Converts a date text string into a usable date value	`DATEVALUE(Datestring)`
DAY	Extracts the day number from a date	`DAY(Number)`
DAYS	Number of days between two dates	`DAYS(Date2, Date1)`
DAYS360	Day difference using a 360-day year (common in finance)	`DAYS360(Date2, Date1[, Format])`
EDATE	Shifts a date forward or backward by a number of months	`EDATE(Startdate, Months)`
EOMONTH	Last day of a month, offset by a number of months — useful for month-end deadlines	`EOMONTH(Startdate, Months)`
HOUR	Extracts the hour from a time value	`HOUR(Time)`
INTERVAL	Converts a number of seconds into a readable interval string	`INTERVAL(Seconds)`
ISOWEEKNUM	Returns the ISO week number for a date	`ISOWEEKNUM(Date)`
MINUTE	Extracts the minutes from a time value	`MINUTE(Time)`
MONTH	Returns the month number (1–12) from a date	`MONTH(Number)`
NETWORKDAYS	Counts working days between two dates, excluding weekends and holidays	`NETWORKDAYS(Date1, Date2[, Holidays])`
NETWORKDAYS.INTL	Same as NETWORKDAYS but with custom weekend settings	`NETWORKDAYS.INTL(Date1, Date2[, Mode[, Holidays]])`
NOW	Returns the current date and time	`NOW()`
SECOND	Extracts the seconds from a time value	`SECOND(Time)`
TIME	Converts hours, minutes, and seconds into a time value	`TIME(Hour, Minute, Second)`
TIMEVALUE	Converts a time text string into a usable time value	`TIMEVALUE(Timestring)`
TODAY	Returns today's date — updates automatically	`TODAY()`
WEEKDAY	Returns a number (1–7) for the day of the week	`WEEKDAY(Date, Type)`
WEEKNUM	Returns which week of the year a date falls in	`WEEKNUM(Date, Type)`
WORKDAY	Returns a date a given number of working days from a start date	`WORKDAY(Date, Shift[, Holidays])`
WORKDAY.INTL	Same as WORKDAY but with custom weekend settings	`WORKDAY(Date, Shift[, Mode[, Holidays]])`
YEAR	Extracts the year from a date	`YEAR(Number)`
YEARFRAC	Difference between two dates as a decimal fraction of a year	`YEARFRAC(Date2, Date1[, Format])`

⚙️ Engineering

Also known as: base conversion, binary hex octal, bitwise operations, complex number functions

Use these for number base conversions, bitwise operations, and complex number calculations.

Function	What it does	Syntax
BIN2DEC	Binary → decimal	`BIN2DEC(Number)`
BIN2HEX	Binary → hexadecimal	`BIN2HEX(Number, Places)`
BIN2OCT	Binary → octal	`BIN2OCT(Number, Places)`
BITAND	Bitwise AND	`BITAND(Number1, Number2)`
BITLSHIFT	Shifts a number left by n bits	`BITLSHIFT(Number, Shift)`
BITOR	Bitwise OR	`BITOR(Number1, Number2)`
BITRSHIFT	Shifts a number right by n bits	`BITRSHIFT(Number, Shift)`
BITXOR	Bitwise exclusive OR (XOR)	`BITXOR(Number1, Number2)`
COMPLEX	Creates a complex number from real and imaginary parts	`COMPLEX(Re, Im[, Symbol])`
DEC2BIN	Decimal → binary (–512 to 511)	`DEC2BIN(Number, Places)`
DEC2HEX	Decimal → hexadecimal	`DEC2HEX(Number, Places)`
DEC2OCT	Decimal → octal	`DEC2OCT(Number, Places)`
DELTA	Returns 1 if two numbers are equal, 0 if not	`DELTA(Number_1, Number_2)`
ERF	Gaussian error integral	`ERF(Lower_Limit, Upper_Limit)`
ERFC	Complementary Gaussian error integral	`ERFC(Lower_Limit)`
HEX2BIN	Hexadecimal → binary	`HEX2BIN(Number, Places)`
HEX2DEC	Hexadecimal → decimal	`HEX2DEC(Number)`
HEX2OCT	Hexadecimal → octal	`HEX2OCT(Number, Places)`
IMABS	Modulus (absolute value) of a complex number	`IMABS(Complex)`
IMAGINARY	Imaginary part of a complex number	`IMAGINARY(Complex)`
IMARGUMENT	Argument (angle) of a complex number	`IMARGUMENT(Complex)`
IMCONJUGATE	Conjugate of a complex number	`IMCONJUGATE(Complex)`
IMCOS	Cosine of a complex number	`IMCOS(Complex)`
IMCOSH	Hyperbolic cosine of a complex number	`IMCOSH(Complex)`
IMCOT	Cotangent of a complex number	`IMCOT(Complex)`
IMCSC	Cosecant of a complex number	`IMCSC(Complex)`
IMCSCH	Hyperbolic cosecant of a complex number	`IMCSCH(Complex)`
IMDIV	Divides two complex numbers	`IMDIV(Complex1, Complex2)`
IMEXP	Exponential of a complex number	`IMEXP(Complex)`
IMLN	Natural logarithm of a complex number	`IMLN(Complex)`
IMLOG2	Binary logarithm of a complex number	`IMLOG2(Complex)`
IMLOG10	Base-10 logarithm of a complex number	`IMLOG10(Complex)`
IMPOWER	Complex number raised to a power	`IMPOWER(Complex, Number)`
IMPRODUCT	Product of up to 30 complex numbers	`IMPRODUCT(Complex1...Complex30)`
IMREAL	Real part of a complex number	`IMREAL(Complex)`
IMSEC	Secant of a complex number	`IMSEC(Complex)`
IMSECH	Hyperbolic secant of a complex number	`IMSECH(Complex)`
IMSIN	Sine of a complex number	`IMSIN(Complex)`
IMSINH	Hyperbolic sine of a complex number	`IMSINH(Complex)`
IMSQRT	Square root of a complex number	`IMSQRT(Complex)`
IMSUB	Subtracts two complex numbers	`IMSUB(Complex1, Complex2)`
IMSUM	Sum of up to 30 complex numbers	`IMSUM(Complex1...Complex30)`
IMTAN	Tangent of a complex number	`IMTAN(Complex)`
OCT2BIN	Octal → binary	`OCT2BIN(Number, Places)`
OCT2DEC	Octal → decimal	`OCT2DEC(Number)`
OCT2HEX	Octal → hexadecimal	`OCT2HEX(Number, Places)`

ℹ️ Information

Also known as: IS functions, cell type check, error check, blank check, formula check

Use these to test what's in a cell — whether it's blank, a number, text, a formula, or an error.

Function	What it does	Syntax
ISBINARY	TRUE if the value is a valid binary number	`ISBINARY(Value)`
ISBLANK	TRUE if the cell is empty	`ISBLANK(Value)`
ISERR	TRUE if the value is any error except #N/A!	`ISERR(Value)`
ISERROR	TRUE if the value is any error (including #N/A!)	`ISERROR(Value)`
ISEVEN	TRUE if the value is an even integer	`ISEVEN(Value)`
ISFORMULA	TRUE if the cell contains a formula	`ISFORMULA(Value)`
ISLOGICAL	TRUE if the value is TRUE or FALSE	`ISLOGICAL(Value)`
ISNA	TRUE if the value is #N/A!	`ISNA(Value)`
ISNONTEXT	TRUE if the cell does not contain text	`ISNONTEXT(Value)`
ISNUMBER	TRUE if the value is a number	`ISNUMBER(Value)`
ISODD	TRUE if the value is an odd integer	`ISODD(Value)`
ISREF	TRUE if the value is a #REF! error	`ISREF(Value)`
ISTEXT	TRUE if the cell contains text	`ISTEXT(Value)`
SHEET	Returns the sheet number	`SHEET([Value])`
SHEETS	Returns the total number of sheets in the workbook	`SHEETS([Value])`
NA	Returns a #N/A! error value deliberately	`NA(Value)`

💰 Financial

Also known as: loan calculator, depreciation, NPV, present value, future value, interest rate, amortisation, mortgage calculator

Use these for loan calculations, depreciation schedules, present/future value, and interest rate analysis.

Function	What it does	Syntax
CUMIPMT	Total interest paid between two payment periods	`CUMIPMT(Rate, Nper, Pv, Start, End, type)`
CUMPRINC	Total principal paid between two payment periods	`CUMPRINC(Rate, Nper, Pv, Start, End, Type)`
DB	Depreciation — fixed-declining balance method	`DB(Cost, Salvage, Life, Period[, Month])`
DDB	Depreciation — double-declining balance method	`DDB(Cost, Salvage, Life, Period[, Factor])`
DOLLARDE	Converts a fractional price (e.g. bond prices) to decimal	`DOLLARDE(Price, Fraction)`
DOLLARFR	Converts a decimal price to fractional notation	`DOLLARFR(Price, Fraction)`
EFFECT	Effective annual interest rate from a nominal rate	`EFFECT(Nominal_rate, Npery)`
FV	Future value of an investment with regular payments	`FV(Rate, Nper, Pmt[, Pv[, Type]])`
FVSCHEDULE	Future value when the interest rate varies over time	`FV(Pv, Schedule)`
IPMT	Interest portion of a specific loan payment	`IPMT(Rate, Per, Nper, Pv[, Fv[, Type]])`
ISPMT	Interest paid in a period with equal principal payments	`ISPMT(Rate, Per, Nper, Value)`
MIRR	Modified internal rate of return	`MIRR(Flows, FRate, RRate)`
NOMINAL	Nominal interest rate from an effective rate	`NOMINAL(Effect_rate, Npery)`
NPER	Number of periods needed to repay a loan	`NPER(Rate, Pmt, Pv[, Fv[, Type]])`
NPV	Net present value of future cash flows	`NPV(Rate, Value1,...,Value30)`
PDURATION	Number of periods to reach a target value	`PDURATION(Rate, Pv, Fv)`
PMT	Regular payment amount for a loan	`PMT(Rate, Nper, Pv[, Fv[, Type]])`
PPMT	Principal portion of a specific loan payment	`PPMT(Rate, Per, Nper, Pv[, Fv[, Type]])`
PV	Present value of an investment	`PV(Rate, Nper, Pmt[, Fv[, Type]])`
RATE	Interest rate per period for an annuity	`RATE(Nper, Pmt, Pv[, Fv[, Type[, guess]]])`
RRI	Equivalent interest rate for a given investment growth	`RRI(Nper, Pv, Fv)`
SLN	Straight-line depreciation over one period	`SLN(Cost, Salvage, Life)`
SYD	Sum-of-years-digits depreciation	`SYD(Cost, Salvage, Life, Period)`
TBILLEQ	Bond-equivalent yield for a Treasury bill	`TBILLEQ(Settlement, Maturity, Discount)`
TBILLPRICE	Price per $100 face value for a Treasury bill	`TBILLPRICE(Settlement, Maturity, Discount)`
TBILLYIELD	Yield for a Treasury bill	`TBILLYIELD(Settlement, Maturity, Price)`
XNPV	Net present value with irregular cash flows	`XNPV(Rate, Payments, Dates)`

🔀 Logical

Also known as: IF statement, conditional formula, AND OR logic, error handling, nested IF, IFS, SWITCH

Use these to build conditional logic, test multiple conditions, and handle errors gracefully.

Function	What it does	Syntax
AND	TRUE only if all conditions are TRUE	`AND(Logicalvalue1,...,Logicalvalue30)`
FALSE	Returns the logical value FALSE	`FALSE()`
IF	Returns different values depending on whether a condition is met	`IF(Test, Then value, Otherwisevalue)`
IFS	Tests multiple conditions and returns the first match — cleaner than nested IFs	`IFS(Condition1, Value1[,...])`
IFNA	Fallback value if a cell contains #N/A! — useful after VLOOKUP	`IFNA(Value, Alternate_value)`
IFERROR	Fallback value if a cell contains any error	`IFERROR(Value, Alternate_value)`
NOT	Reverses a logical value (TRUE → FALSE, FALSE → TRUE)	`NOT(Logicalvalue)`
OR	TRUE if at least one condition is TRUE	`OR(Logicalvalue1,...,Logicalvalue30)`
SWITCH	Matches a value against a list and returns the paired result	`SWITCH(Expression1, Value1[,...])`
TRUE	Returns the logical value TRUE	`TRUE()`
XOR	TRUE if an odd number of conditions are TRUE (exclusive OR)	`XOR(Logicalvalue1,...,Logicalvalue30)`

🔍 Lookup and Reference

Also known as: VLOOKUP, HLOOKUP, INDEX MATCH, lookup formula, find value in table, cross-reference, search table

Use these to search, navigate, and reference data across your Worksheet.

Function	What it does	Syntax
ADDRESS	Returns a cell address as a text string (e.g. "B4")	`ADDRESS(Row, Column[, AbsoluteRelativeMode[, UseA1Notation[, Sheet]]])`
CHOOSE	Picks a value from a list based on an index number	`CHOOSE(Index, Value1,...,Value30)`
COLUMN	Returns the column number of a cell reference	`COLUMN([Reference])`
COLUMNS	Returns how many columns are in a range	`COLUMNS(Array)`
FORMULATEXT	Returns the formula in a cell as readable text	`FORMULATEXT(Reference)`
HLOOKUP	Horizontal lookup — like VLOOKUP but searches across rows	`HLOOKUP(Search_Criterion, Array, Index, Sort_Order)`
HYPERLINK	Stores a clickable URL in a cell	`HYPERLINK(Url[, LinkLabel])`
INDEX	Returns the value at a specific row and column — often paired with MATCH	`INDEX(Range, Row[, Column])`
MATCH	Returns the position of a value in a range — often paired with INDEX	`MATCH(Searchcriterion, Lookuparray[, MatchType])`
OFFSET	Returns a value a set number of rows and columns from a starting point	`OFFSET(Reference, Rows, Columns, Height, Width)`
ROW	Returns the row number of a cell reference	`ROW([Reference])`
ROWS	Returns how many rows are in a range	`ROWS(Array)`
VLOOKUP	Looks up a value in the first column of a table and returns a matched value	`VLOOKUP(Search_Criterion, Array, Index, Sort_Order)`

➕ Math and Trigonometry

Also known as: AutoSum, add up cells, total column, sum inventory, rounding, round up round down, absolute value, square root, logarithm, sine cosine tangent, random number, modulo, factorial

Use these for arithmetic, rounding, logarithms, and trigonometry. For totalling a column of values — like inventory quantities or batch amounts — use SUM (also called AutoSum in Excel).

Function	What it does	Syntax
ABS	Absolute value — removes the negative sign	`ABS(Number)`
ACOS	Inverse cosine (arccos)	`ACOS(Number)`
ACOSH	Inverse hyperbolic cosine	`ACOSH(Number)`
ACOT	Inverse cotangent	`ACOT(Number)`
ACOTH	Inverse hyperbolic cotangent	`ACOTH(Number)`
ARABIC	Converts Roman numerals to a number	`ARABIC(String)`
ASIN	Inverse sine (arcsin)	`ASIN(Number)`
ASINH	Inverse hyperbolic sine	`ASINH(Number)`
ATAN	Inverse tangent (arctan)	`ATAN(Number)`
ATAN2	Inverse tangent from x and y coordinates	`ATAN2(Numberx, Numbery)`
ATANH	Inverse hyperbolic tangent	`ATANH(Number)`
BASE	Converts a positive integer to a different number base	`BASE(Number, Radix[, Minimumlength])`
CEILING	Rounds up to the nearest multiple of a given value	`CEILING(Number, Significance)`
CEILING.MATH	Rounds up — with control over negative number behaviour	`CEILING.MATH(Number[, Significance[, Mode]])`
CEILING.PRECISE	Rounds up, always away from zero	`CEILING.PRECISE(Number[, Significance])`
COMBIN	Combinations without repetition (nCr)	`COMBIN(Number, Number)`
COMBINA	Combinations with repetition	`COMBINA(Number, Number)`
COS	Cosine (radians)	`COS(Number)`
COSH	Hyperbolic cosine	`COSH(Number)`
COT	Cotangent (radians)	`COT(Number)`
COTH	Hyperbolic cotangent	`COTH(Number)`
COUNTUNIQUE	Counts distinct values in a list	`COUNTUNIQUE(Value1[, Value2,...])`
CSC	Cosecant (radians)	`CSC(Number)`
CSCH	Hyperbolic cosecant	`CSCH(Number)`
DECIMAL	Converts a number in a given base back to decimal	`DECIMAL("Text", Radix)`
DEGREES	Converts radians to degrees	`DEGREES(Number)`
EVEN	Rounds up to the next even integer	`EVEN(Number)`
EXP	Returns e raised to a given power	`EXP(Number)`
FACT	Factorial (e.g. 5! = 120)	`FACT(Number)`
FACTDOUBLE	Double factorial	`FACTDOUBLE(Number)`
FLOOR	Rounds down to the nearest multiple of a given value	`FLOOR(Number, Significance)`
FLOOR.MATH	Rounds down — with control over negative number behaviour	`FLOOR.MATH(Number[, Significance[, Mode]])`
FLOOR.PRECISE	Rounds down, always toward zero	`FLOOR.PRECISE(Number[, Significance])`
GCD	Greatest common divisor	`GCD(Number1, Number2,...)`
INT	Rounds down to the nearest integer	`INT(Number)`
ISO.CEILING	Rounds up to nearest multiple (ISO standard)	`ISO.CEILING(Number[, Significance])`
LCM	Least common multiple	`LCM(Number1, Number2,...)`
LN	Natural logarithm (base e)	`LN(Number)`
LOG	Logarithm to any specified base	`LOG(Number, Base)`
LOG10	Base-10 logarithm	`LOG10(Number)`
MOD	Remainder after division (modulo)	`MOD(Dividend, Divisor)`
MROUND	Rounds to the nearest specified multiple	`MROUND(Number, Base)`
MULTINOMIAL	Multinomial coefficient	`MULTINOMIAL(Number1, Number2,...)`
ODD	Rounds up to the nearest odd integer	`ODD(Number)`
PI	Returns π (3.14159265358979)	`PI()`
POWER	Raises a number to a power (same as ^)	`POWER(Base, Exponent)`
PRODUCT	Multiplies a range of numbers together	`PRODUCT(Number1,...,Number30)`
QUOTIENT	Integer part of a division — drops the remainder	`QUOTIENT(Dividend, Divisor)`
RADIANS	Converts degrees to radians	`RADIANS(Number)`
RAND	Random decimal number between 0 and 1	`RAND()`
RANDBETWEEN	Random whole number between two values	`RANDBETWEEN(Lowerbound, Upperbound)`
ROMAN	Converts a number to Roman numerals	`ROMAN(Number[, Mode])`
ROUND	Rounds to a specified number of decimal places	`ROUND(Number, Count)`
ROUNDDOWN	Rounds toward zero	`ROUNDDOWN(Number, Count)`
ROUNDUP	Rounds away from zero	`ROUNDUP(Number, Count)`
SEC	Secant (radians)	`SEC(Number)`
SECH	Hyperbolic secant	`SECH(Number)`
SERIESSUM	Evaluates a power series at a point	`SERIESSUM(Number, Number, Number, Coefficients)`
SIGN	Returns +1, 0, or –1 based on the sign of a number	`SIGN(Number)`
SIN	Sine (radians)	`SIN(Number)`
SINH	Hyperbolic sine	`SINH(Number)`
SQRT	Square root	`SQRT(Number)`
SQRTPI	Square root of (number × π)	`SQRTPI(Number)`
SUBTOTAL	One of 11 aggregate functions — ignores other SUBTOTAL rows, useful in filtered lists	`SUBTOTAL(Function, Number1,...,Number30)`
SUM	Adds up a range of values — AutoSum in Excel. Use this to total inventory quantities, batch sizes, or any column of numbers	`SUM(Number1,...,Number30)`
SUMIF	Sum of values meeting a single condition	`SUMIF(Range, Criteria, Sumrange)`
SUMIFS	Sum of values meeting multiple conditions	`SUMIFS(Sum_Range, Criterion_range1, Criterion1[,...])`
SUMPRODUCT	Multiplies matching values across arrays then sums — useful for weighted averages	`SUMPRODUCT(Array1, Array2,...Array30)`
SUMSQ	Sum of squares	`SUMSQ(Number1,...,Number30)`
SUMX2MY2	Sum of (x² – y²) for each pair	`SUMX2MY2(Range1, Range2)`
SUMX2PY2	Sum of (x² + y²) for each pair	`SUMX2PY2(Range1, Range2)`
SUMXMY2	Sum of (x – y)² for each pair	`SUMXMY2(Range1, Range2)`
TAN	Tangent (radians)	`TAN(Number)`
TANH	Hyperbolic tangent	`TANH(Number)`
TRUNC	Removes decimal places without rounding	`TRUNC(Number, Count)`

🔳 Matrix Functions

Also known as: matrix multiplication, MMULT, transpose rows and columns, data pooling

Use these for matrix algebra and pooling operations — useful in multivariate analysis and data reduction.

Function	What it does	Syntax
MMULT	Matrix product of two arrays	`MMULT(Array, Array)`
MEDIANPOOL	Median of a sliding window across a range	`MEDIANPOOL(Range, Window_size, Stride)`
MAXPOOL	Maximum of a sliding window across a range	`MAXPOOL(Range, Window_size, Stride)`
TRANSPOSE	Swaps rows and columns in an array	`TRANSPOSE(Array)`

⚡ Operator Functions

Also known as: arithmetic operators, add subtract multiply divide, comparison operators, equals not equals, greater than less than

Standard operators (+, –, , /) work directly in formulas. The HF. functions below are the explicit function-form equivalents.

Function	What it does	Syntax
HF.ADD	Addition (+)	`HF.ADD(Number, Number)`
HF.CONCAT	String concatenation (&)	`HF.CONCAT(String, String)`
HF.DIVIDE	Division (/)	`HF.DIVIDE(Number, Number)`
HF.EQ	Equal to (=)	`HF.EQ(Value, Value)`
HF.LTE	Less than or equal to (<=)	`HF.LEQ(Value, Value)`
HF.LT	Less than (<)	`HF.LT(Value, Value)`
HF.GTE	Greater than or equal to (>=)	`HF.GEQ(Value, Value)`
HF.GT	Greater than (>)	`HF.GT(Value, Value)`
HF.MINUS	Subtraction (–)	`HF.MINUS(Number, Number)`
HF.MULTIPLY	Multiplication (*)	`HF.MULTIPLY(Number, Number)`
HF.NE	Not equal to (<>)	`HF.NE(Value, Value)`
HF.POW	Exponentiation (^)	`HF.POW(Number, Number)`
HF.UMINUS	Unary minus (negation)	`HF.UMINUS(Number)`
HF.UNARY_PERCENT	Percent operator (%)	`HF.UNARY_PERCENT(Number)`
HF.UPLUS	Unary plus	`HF.UPLUS(Number)`

📊 Statistical

Also known as: average, mean, median, standard deviation, variance, count, COUNTIF, AVERAGEIF, normal distribution, t-test, chi-square, regression, correlation, percentile, rank, bell curve, standard error

Use these for descriptive statistics, hypothesis testing, probability distributions, and regression. All Excel-compatible aliases (e.g. NORMDIST, STDEVP, ZTEST) are also supported.

Function	What it does	Syntax
AVEDEV	Average of absolute deviations from the mean	`AVEDEV(Number1,...,Number30)`
AVERAGE	Arithmetic mean	`AVERAGE(Number1,...,Number30)`
AVERAGEA	Mean including text (as 0) and logical values	`AVERAGEA(Value1,...,Value30)`
AVERAGEIF	Average of values meeting a condition	`AVERAGEIF(Range, Criterion[, Average_Range])`
BESSELI	Modified Bessel function, first kind	`BESSELI(x, n)`
BESSELJ	Bessel function, first kind	`BESSELJ(x, n)`
BESSELK	Modified Bessel function, second kind	`BESSELK(x, n)`
BESSELY	Bessel function, second kind	`BESSELY(x, n)`
BETA.DIST	Beta distribution (also: BETADIST)	`BETA.DIST(Number1, Number2, Number3, Boolean[,...])`
BETA.INV	Inverse Beta distribution (also: BETAINV)	`BETA.INV(Number1, Number2, Number3[,...])`
BINOM.DIST	Binomial distribution (also: BINOMDIST)	`BINOM.DIST(Number1, Number2, Number3, Boolean)`
BINOM.INV	Inverse binomial distribution (also: CRITBINOM)	`BINOM.INV(Number1, Number2, Number3)`
CHISQ.DIST	Chi-square distribution	`CHISQ.DIST(X, Degrees, Mode)`
CHISQ.DIST.RT	Chi-square right-tail probability (also: CHIDIST)	`CHISQ.DIST.RT(X, Degrees)`
CHISQ.INV.RT	Inverse chi-square right-tail (also: CHIINV)	`CHISQ.INV.RT(P, Degrees)`
CHISQ.TEST	Chi-squared test for independence (also: CHITEST)	`CHISQ.TEST(Array1, Array2)`
CONFIDENCE.NORM	Upper confidence bound, normal distribution (also: CONFIDENCE)	`CONFIDENCE.NORM(Alpha, Stdev, Size)`
CONFIDENCE.T	Upper confidence bound, t-distribution	`CONFIDENCE.T(Alpha, Stdev, Size)`
CORREL	Correlation coefficient between two datasets	`CORREL(Data1, Data2)`
COUNT	Counts cells containing numbers	`COUNT(Value1,...,Value30)`
COUNTA	Counts all non-empty cells	`COUNTA(Value1,...,Value30)`
COUNTBLANK	Counts empty cells in a range	`COUNTBLANK(Range)`
COUNTIF	Counts cells meeting a single condition	`COUNTIF(Range, Criteria)`
COUNTIFS	Counts cells meeting multiple conditions	`COUNTIFS(Range1, Criterion1[,...])`
COVARIANCE.P	Population covariance (also: COVAR)	`COVARIANCE.P(Data1, Data2)`
COVARIANCE.S	Sample covariance	`COVARIANCE.S(Data1, Data2)`
DEVSQ	Sum of squared deviations from the mean	`DEVSQ(Number1,...,Number30)`
EXPON.DIST	Exponential distribution (also: EXPONDIST)	`EXPON.DIST(Number1, Number2, Boolean)`
F.DIST	F distribution value	`F.DIST(X, Degree1, Degree2, Mode)`
F.DIST.RT	F right-tail probability (also: FDIST)	`F.DIST.RT(X, Degree1, Degree2)`
F.INV.RT	Inverse F right-tail (also: FINV)	`F.INV.RT(P, Degree1, Degree2)`
F.TEST	F-test (also: FTEST)	`F.TEST(Array1, Array2)`
FISHER	Fisher transformation	`FISHER(Number)`
FISHERINV	Inverse Fisher transformation	`FISHERINV(Number)`
GAMMA	Gamma function	`GAMMA(Number)`
GAMMA.DIST	Gamma distribution (also: GAMMADIST)	`GAMMA.DIST(Number1, Number2, Number3, Boolean)`
GAMMA.INV	Inverse Gamma distribution (also: GAMMAINV)	`GAMMA.INV(Number1, Number2, Number3)`
GAMMALN	Natural log of the Gamma function	`GAMMALN(Number)`
GAUSS	Probability of a standard normal variable within n standard deviations	`GAUSS(Number)`
GEOMEAN	Geometric mean	`GEOMEAN(Number1,...,Number30)`
HARMEAN	Harmonic mean	`HARMEAN(Number1,...,Number30)`
HYPGEOM.DIST	Hypergeometric distribution (also: HYPGEOMDIST)	`HYPGEOM.DIST(Number1, Number2, Number3, Number4, Boolean)`
LARGE	K-th largest value in a range	`LARGE(Range, K)`
LOGNORM.DIST	Lognormal distribution (also: LOGNORMDIST)	`LOGNORM.DIST(X, Mean, Stddev, Mode)`
LOGNORM.INV	Inverse lognormal distribution (also: LOGINV, LOGNORMINV)	`LOGNORM.INV(P, Mean, Stddev)`
MAX	Maximum value in a range	`MAX(Number1,...,Number30)`
MAXA	Maximum including text and logical values	`MAXA(Value1,...,Value30)`
MAXIFS	Maximum value meeting one or more conditions	`MAXIFS(Max_Range, Criterion_range1, Criterion1[,...])`
MEDIAN	Middle value of a dataset	`MEDIAN(Number1,...,Number30)`
MIN	Minimum value in a range	`MIN(Number1,...,Number30)`
MINA	Minimum including text and logical values	`MINA(Value1,...,Value30)`
MINIFS	Minimum value meeting one or more conditions	`MINIFS(Min_Range, Criterion_range1, Criterion1[,...])`
NEGBINOM.DIST	Negative binomial distribution (also: NEGBINOMDIST)	`NEGBINOM.DIST(Number1, Number2, Number3, Mode)`
NORM.DIST	Normal distribution (also: NORMDIST)	`NORM.DIST(X, Mean, Stddev, Mode)`
NORM.INV	Inverse normal distribution (also: NORMINV)	`NORM.INV(P, Mean, Stddev)`
NORM.S.DIST	Standard normal distribution (also: NORMSDIST)	`NORM.S.DIST(X, Mode)`
NORM.S.INV	Inverse standard normal (also: NORMSINV)	`NORM.S.INV(P)`
PEARSON	Pearson correlation coefficient	`PEARSON(Data1, Data2)`
PHI	Probability density of the standard normal distribution	`PHI(X)`
POISSON.DIST	Poisson distribution (also: POISSON)	`POISSON.DIST(X, Mean, Mode)`
RSQ	R-squared between two datasets	`RSQ(Data1, Data2)`
SKEW	Skewness of a sample	`SKEW(Number1,...,Number30)`
SKEW.P	Skewness of a population	`SKEW.P(Number1,...,Number30)`
SLOPE	Slope of the linear regression line	`SLOPE(Array1, Array2)`
SMALL	K-th smallest value in a range	`SMALL(Range, K)`
STANDARDIZE	Normalises a value relative to mean and standard deviation	`STANDARDIZE(X, Mean, Stddev)`
STDEV	Sample standard deviation (also: STDEV.S)	`STDEV(Value1,...,Value30)`
STDEV.P	Population standard deviation (also: STDEVP)	`STDEV.P(Value1,...,Value30)`
STEYX	Standard error of predicted y values in a regression	`STEYX(Array1, Array2)`
T.DIST	Student's t-distribution (also: TDIST)	`T.DIST(X, Degrees, Mode)`
T.DIST.2T	Two-tailed Student's t-distribution	`T.DIST.2T(X, Degrees)`
T.DIST.RT	Right-tailed Student's t-distribution	`T.DIST.RT(X, Degrees)`
T.INV	Inverse Student's t-distribution (also: TINV)	`T.INV(P, Degrees)`
T.INV.2T	Two-tailed inverse Student's t-distribution	`T.INV.2T(P, Degrees)`
T.TEST	Student's t-test (also: TTEST)	`T.TEST(Array1, Array2)`
VAR	Sample variance (also: VAR.S)	`VAR(Value1,...,Value30)`
VAR.P	Population variance (also: VARP)	`VAR.P(Value1,...,Value30)`
WEIBULL.DIST	Weibull distribution (also: WEIBULL)	`WEIBULL.DIST(Number1, Number2, Number3, Boolean)`
Z.TEST	Z-test (also: ZTEST)	`Z.TEST(Array, X[, Sigma])`

🔤 Text

Also known as: string functions, concatenate, join text, split text, find replace, upper lower case, trim spaces, extract text, left right mid

Use these to manipulate, search, format, and combine text strings in your Worksheet.

Function	What it does	Syntax
CHAR	Converts a character code to its character	`CHAR(Number)`
CLEAN	Removes non-printable characters and line breaks	`CLEAN("Text")`
CODE	Returns the numeric code for the first character in a string	`CODE("Text")`
CONCATENATE	Joins multiple strings into one (also writeable as &)	`CONCATENATE("Text1",...,"Text30")`
EXACT	TRUE if two strings are identical, including case	`EXACT(Text, Text)`
FIND	Position of one string inside another — case-sensitive	`FIND("Text1", "Text2"[, Number])`
LEFT	Extracts characters from the left side of a string	`LEFT("Text", Number)`
LEN	Number of characters in a string	`LEN("Text")`
LOWER	Converts text to lowercase	`LOWER(Text)`
MID	Extracts a substring from a specified position	`MID(Text, Start_position, Length)`
PROPER	Capitalises the first letter of each word (title case)	`PROPER("Text")`
REPLACE	Replaces text at a specific position	`REPLACE(Text, Start_position, Length, New_text)`
REPT	Repeats a string a given number of times	`REPT("Text", Number)`
RIGHT	Extracts characters from the right side of a string	`RIGHT("Text", Number)`
SEARCH	Finds a string — case-insensitive, supports wildcards (* ?)	`SEARCH(Search_string, Text[, Start_position])`
SPLIT	Splits text by spaces and returns the word at a given index	`SPLIT(Text, Index)`
SUBSTITUTE	Replaces all occurrences of a string — like Find & Replace	`SUBSTITUTE(Text, Old_text, New_text[, Occurrence])`
T	Returns the value if text; empty string otherwise	`T(Value)`
TEXT	Formats a number as text using a format code	`TEXT(Number, Format)`
TRIM	Removes extra spaces, leaving single spaces between words	`TRIM("Text")`
UNICHAR	Returns the character for a Unicode code point	`UNICHAR(Number)`
UNICODE	Returns the Unicode code point of the first character	`UNICODE(Text)`
UPPER	Converts text to uppercase	`UPPER(Text)`

Last updated: 2 years ago. For questions about a specific function or how to use it in your Worksheet, reach out to your Albert partner team.