Function Reference
EngCanvas includes 196 built-in functions across 12 categories.
All Functions
| Function | Category | Description |
|---|---|---|
ABS | Math | Returns the absolute value of a number. |
ACOS | Trig | Returns the arccosine (inverse cosine) of a number, in radians. |
ACOSH | Trig | Returns the inverse hyperbolic cosine of a number. Number must be greater than o… |
AND | Logical | Returns TRUE if all arguments are truthy, FALSE otherwise. Short-circuits on fir… |
ASIN | Trig | Returns the arcsine (inverse sine) of a number, in radians. |
ASINH | Trig | Returns the inverse hyperbolic sine of a number. |
ATAN | Trig | Returns the arctangent (inverse tangent) of a number, in radians. |
ATAN2 | Trig | Returns the arctangent of the x,y coordinates, in radians. The angle is measured… |
ATANH | Trig | Returns the inverse hyperbolic tangent of a number. Number must be between -1 an… |
AVERAGE (AVG) | Statistical | Calculates the average (arithmetic mean) of the arguments. |
AVERAGEIF | Aggregate | Averages cells that meet a criteria. |
AVERAGEIFS | Aggregate | Averages values in average_range where ALL criteria match. Returns #DIV/0! if no… |
BILINTERP | Engineering | Bilinear interpolation (and extrapolation) over a 2D data table. known_xs and kn… |
BIN2DEC | Engineering | Converts a binary number to decimal. |
CEIL (CEILING) | Math | Rounds a number up, away from zero. |
CEILINGMATH | Math | Rounds a number up to the nearest multiple of significance. For negative numbers… |
CEILINGPRECISE | Math | Rounds a number up to the nearest multiple of significance. The sign of signific… |
CHAR | Text | Returns the character specified by the ASCII code number. |
CHOL (CHOLESKY) | Matrix | Cholesky decomposition: returns the lower-triangular factor L of a symmetric pos… |
CHOOSE | Lookup | Returns a value from a list of values based on an index number. |
CLAMP | Engineering | Clamps a value to the range [min, max]. Returns min if value < min, max if value… |
CLEAN | Text | Removes all non-printable characters (ASCII 0–31) from text. |
CODE | Text | Returns the ASCII code of the first character in a text string. |
COLS (COLUMNS) | Matrix | Returns the number of columns in a matrix. |
COLUMN | Lookup | Returns the column number of a reference. |
COMBIN | Math | Returns the number of combinations (n choose k) for a given number of items. |
COMPLEX | Engineering | Converts real and imaginary coefficients into a complex number of the form x + y… |
CONC_FC | Engineering | Returns a material property for normal-weight concrete with compressive strength… |
CONCAT (CONCATENATE) | Text | Joins two or more text strings into one string. |
COND | Matrix | Estimates the condition number of a square matrix (Frobenius-norm approximation … |
CONFIDENCE | Statistical | Returns the confidence interval for a population mean using a normal distributio… |
CORREL | Statistical | Returns the Pearson correlation coefficient between two data sets. |
COS | Trig | Returns the cosine of the given angle. |
COSH | Trig | Returns the hyperbolic cosine of a number. |
COUNT | Statistical | Counts the number of cells that contain numeric values. |
COUNTA | Statistical | Counts the number of cells that are not empty in a range. |
COUNTIF | Aggregate | Counts cells that meet a criteria. |
COUNTIFS | Aggregate | Counts cells that meet multiple criteria across multiple ranges. |
DATE | Date | Returns the Excel serial number for the specified date. Handles month and day ov… |
DATEDIF | Date | Returns the difference between two dates in the requested unit. Units: "D" days,… |
DAY | Date | Returns the day-of-month component of an Excel date serial number (1–31). |
DEC2BIN | Engineering | Converts a decimal number to binary. |
DEC2HEX | Engineering | Converts a decimal number to hexadecimal. |
DEGREES | Trig | Converts an angle in radians to degrees. |
DELTA | Engineering | Tests whether two values are equal. Returns 1 if they are equal, 0 otherwise. |
DET (DETERMINANT) | Matrix | Returns the determinant of a square matrix. |
DIAG | Matrix | Creates a diagonal matrix from a list of values. The values appear on the main d… |
E | Math | Returns Euler's number (e), the base of the natural logarithm, approximately 2.7… |
EDATE | Date | Returns the serial number of the date a given number of months before or after a… |
EIGVAL | Matrix | Returns the dominant (largest-magnitude) eigenvalue of a square matrix, computed… |
EOMONTH | Date | Returns the serial number of the last day of the month a given number of months … |
ERF | Math | Returns the error function integrated between 0 and a given value. |
ERFC | Math | Returns the complementary error function: 1 - ERF(x). |
ERRORTYPE | Information | Returns a numeric code classifying an error: 2=#DIV/0!, 3=#VALUE!, 4=#REF!, 5=#N… |
EVEN | Math | Rounds a number up to the nearest even integer. |
EXACT | Text | Compares two text strings and returns TRUE (1) if they are exactly the same (cas… |
EXP | Math | Returns e raised to the power of a specified number. |
FACT | Math | Returns the factorial of a non-negative integer. |
FALSE | Logical | Returns the boolean value FALSE (0). |
FILTER | DynamicArray | Filters a range of data based on criteria you define. |
FIND | Text | Finds one text string within another (case-sensitive) and returns the start posi… |
FIXED | Text | Rounds a number to the specified number of decimals and returns the result as te… |
FLOOR | Math | Rounds a number down, toward zero. |
FLOORMATH | Math | Rounds a number down to the nearest multiple of significance. For negative numbe… |
FLOORPRECISE | Math | Rounds a number down to the nearest multiple of significance. The sign of signif… |
FORECAST | Statistical | Predicts a future value along a linear trend using existing x and y values. |
FREQUENCY | Statistical | Calculates how often values occur within a range of values and returns a vertica… |
GCD | Math | Returns the greatest common divisor of two or more integers. |
GESTEP | Engineering | Returns 1 if number is greater than or equal to step; returns 0 otherwise. |
HEX2DEC | Engineering | Converts a hexadecimal number to decimal. |
HLOOKUP | Lookup | Searches for a value in the first row of a table array and returns a value in th… |
IDENTITY (EYE) | Matrix | Returns an n×n identity matrix (1s on the diagonal, 0s elsewhere). |
IF | Logical | Returns one value if condition is true, another if false. |
IFERROR | Lookup | Returns a specified value if a formula evaluates to an error; otherwise returns … |
IFNA | Lookup | Returns a specified value if a formula evaluates to #N/A error; otherwise return… |
IFS | Logical | Returns the value corresponding to the first true condition. Evaluates condition… |
IMABS | Engineering | Returns the absolute value (modulus) of a complex number. |
IMAGINARY | Engineering | Returns the imaginary coefficient of a complex number. |
IMREAL | Engineering | Returns the real coefficient of a complex number. |
INDEX | Lookup | Returns the value of a cell in a range specified by a row and column number. |
INDIRECT | Lookup | Returns the reference specified by a text string. |
INT | Math | Rounds a number down to the nearest integer (toward negative infinity). |
INTERCEPT | Statistical | Returns the y-intercept of the linear regression line through the given data poi… |
INV (INVERSE) | Matrix | Returns the inverse of a square matrix. |
ISBLANK | Information | Returns TRUE if the value refers to an empty cell, FALSE otherwise. |
ISERROR | Information | Returns TRUE if the value is any error value, FALSE otherwise. |
ISNA | Information | Returns TRUE if the value is the #N/A error value, FALSE otherwise. |
ISNUMBER | Information | Returns TRUE if the value is a number, FALSE otherwise. |
ISTEXT | Information | Returns TRUE if the value is text, FALSE otherwise. |
ITERATE | Engineering | Bounded fixed-point iteration: evaluates the update expression with the named va… |
LARGE | Statistical | Returns the k-th largest value in a data set. |
LCM | Math | Returns the least common multiple of two or more integers. |
LEFT | Text | Returns a specified number of characters from the start of a text string. |
LEN | Text | Returns the number of characters in a text string. |
LINTERP | Engineering | Linear interpolation (and extrapolation) over a table of (x, y) pairs. known_xs … |
LN | Math | Returns the natural logarithm of a number. |
LOG | Math | Returns the logarithm of a number to a specified base. When base is omitted, ret… |
LOG10 | Math | Returns the base-10 logarithm of a number. |
LOWER | Text | Converts a text string to all lowercase letters. |
MAP | Engineering | Linearly maps a value from the input range [from_low, from_high] to the output r… |
MATCH | Lookup | Returns the relative position of a value within a range. |
MAX | Statistical | Returns the maximum value in a list of arguments. |
MAXIFS | Aggregate | Returns the maximum value among cells that meet one or more criteria. |
MEDIAN | Statistical | Returns the median (middle value) of the given numbers. If there is an even numb… |
MID | Text | Returns a specific number of characters from a text string, starting at the posi… |
MIN | Statistical | Returns the minimum value in a list of arguments. |
MINIFS | Aggregate | Returns the minimum value among cells that meet one or more criteria. |
MOD | Math | Returns the remainder from a division. |
MODE | Statistical | Returns the most frequently occurring value in a data set. |
MONTH | Date | Returns the month component of an Excel date serial number (1–12). |
MRANK | Matrix | Returns the rank of a matrix (the number of linearly independent rows or columns… |
MROUND | Math | Returns a number rounded to the nearest specified multiple. |
MSOLVE | Matrix | Solves the linear system A·x = b for x, where A is a square matrix and b is a co… |
N | Information | Converts a value to a number. Numbers return as-is; text and other values return… |
NA | Information | Returns the #N/A error value. Use to indicate a value is unavailable. |
NORM | Matrix | Returns the Frobenius norm of a matrix (square root of sum of squared elements). |
NORMDIST | Statistical | Returns the normal distribution for the specified mean and standard deviation. |
NORMINV | Statistical | Returns the inverse of the normal cumulative distribution for the specified mean… |
NOT | Logical | Returns the opposite boolean value. TRUE becomes FALSE, FALSE becomes TRUE. |
NOW | Date | Returns the current date and time as an Excel serial number. Integer part is the… |
NUMBERVALUE | Text | Converts text to a number using locale-aware decimal and group separators. Handl… |
OCT2DEC | Engineering | Converts an octal number to decimal. |
ODD | Math | Rounds a number up to the nearest odd integer. |
OFFSET | Lookup | Returns a reference offset from a given reference by a specified number of rows … |
ONES | Matrix | Returns an m×n matrix filled with ones. |
OR | Logical | Returns TRUE if any argument is truthy, FALSE otherwise. Short-circuits on first… |
PERCENTILE | Statistical | Returns the k-th percentile of values in a range, where k is between 0 and 1 inc… |
PHITABLE | Engineering | Returns a property of an AISC W-shape from the AISC Steel Construction Manual (1… |
PI | Math | Returns the mathematical constant pi (π), approximately 3.14159265358979. |
POW (POWER) | Math | Returns the result of a number raised to a power. |
PRODUCT | Aggregate | Multiplies all values together. |
QR | Matrix | QR decomposition: returns the orthogonal factor Q of A = Q·R (via Householder re… |
QUOTIENT | Math | Returns the integer portion of a division (truncates the remainder). |
RADIANS | Trig | Converts an angle in degrees to radians. |
RAND | Math | Returns a random number greater than or equal to 0 and less than 1. |
RANDBETWEEN | Math | Returns a random integer between the numbers you specify. |
RANKAVG | Statistical | Returns the rank of a number in a list. If multiple values have the same rank, t… |
RANKEQ (RANK) | Statistical | Returns the rank of a number in a list of numbers. Ties receive the same rank. |
RATIO | Engineering | Returns demand / capacity as a dimensionless number. Throws an error if capacity… |
REBAR | Engineering | Returns a property of a standard ASTM rebar (reinforcing bar). Sizes #3–#18. Def… |
REPLACE | Text | Replaces part of a text string with a different text string. |
REPT | Text | Repeats text a specified number of times. |
RIGHT | Text | Returns a specified number of characters from the end of a text string. |
ROUND | Math | Rounds a number to a specified number of digits. |
ROUNDDOWN | Math | Rounds a number down, toward zero, to a specified number of digits. |
ROUNDUP | Math | Rounds a number up, away from zero, to a specified number of digits. |
ROW | Lookup | Returns the row number of a reference. |
ROWS | Matrix | Returns the number of rows in a matrix. |
RSQ | Statistical | Returns the square of the Pearson product-moment correlation coefficient (R²) th… |
SEARCH | Text | Finds one text string within another (case-insensitive) and returns the start po… |
SEQUENCE | DynamicArray | Generates a list of sequential numbers in an array. |
SIGN | Math | Returns the sign of a number: 1 for positive, -1 for negative, 0 for zero. |
SIN | Trig | Returns the sine of the given angle. |
SINH | Trig | Returns the hyperbolic sine of a number. |
SLOPE | Statistical | Returns the slope of the linear regression line through the given data points. |
SMALL | Statistical | Returns the k-th smallest value in a data set. |
SOLVE | Engineering | Bisection root-finder: the value of the named variable in [lo, hi] where the exp… |
SORT | DynamicArray | Sorts the contents of a range or array. |
SORTBY | DynamicArray | Sorts the contents of a range or array based on the values in a corresponding ra… |
SQRT | Math | Returns the square root of a number. |
STDEV | Statistical | Estimates the standard deviation based on a sample (ignores text and logical val… |
STDEVP | Statistical | Calculates the standard deviation based on the entire population (ignores text a… |
SUBSTITUTE | Text | Substitutes new text for old text in a text string. |
SUBTOTAL | Aggregate | Returns a subtotal in a list or database. Use function_num 1-11 (include all) or… |
SUM | Statistical | Calculates the sum of a list of numbers or ranges. |
SUMIF | Aggregate | Sums cells that meet a criteria. |
SUMIFS | Aggregate | Sums cells that meet multiple criteria. |
SUMPRODUCT | Aggregate | Returns the sum of products of corresponding elements in one or more arrays. |
SUMSQ | Math | Returns the sum of the squares of the arguments. |
SWITCH | Logical | Evaluates an expression against a list of values and returns the result correspo… |
T | Text | Returns the value if it is text, or an empty string if it is a number or other t… |
TAN | Trig | Returns the tangent of the given angle. |
TANH | Trig | Returns the hyperbolic tangent of a number. |
TEXT | Text | Converts a number to text using a specified format. |
TEXTJOIN | Text | Joins a list of text strings using a delimiter, with option to ignore empty stri… |
TODAY | Date | Returns the current date as an Excel serial number (integer). Volatile — recalcu… |
TOFTIN | Text | Converts a length value to a foot-inch string (e.g. 63 in → "5'-3""). Accepts a… |
TRACE (TR) | Matrix | Returns the trace of a square matrix (sum of diagonal elements). |
TRANSPOSE | Matrix | Returns the transpose of a matrix (rows become columns and columns become rows). |
TRIM | Text | Removes all spaces from text except for single spaces between words. |
TRUE | Logical | Returns the boolean value TRUE (1). |
TRUNC | Math | Truncates a number to an integer or to a specified number of decimal places by r… |
TYPE | Information | Returns a type code: 1 for numbers, 2 for text, 64 for arrays/matrices. |
UNIQUE | DynamicArray | Returns a list of unique values in a list or range. |
UPPER | Text | Converts a text string to all uppercase letters. |
VALUE | Text | Converts a text string that represents a number to a number. |
VAR | Statistical | Estimates variance based on a sample (ignores text and logical values). |
VARP | Statistical | Calculates variance based on the entire population (ignores text and logical val… |
VLOOKUP | Lookup | Searches for a value in the first column of a table array and returns a value in… |
WEEKDAY | Date | Returns the day of the week for a date serial. return_type: 1 = Sun–Sat → 1–7 (d… |
WITHIN | Engineering | Returns 1 if min ≤ value ≤ max (using SI values), otherwise 0. |
XLOOKUP | Lookup | Searches a range or array for a match and returns the corresponding item from a … |
XMATCH | Lookup | Returns the relative position of an item in an array or range. |
XOR | Logical | Returns a logical exclusive OR of all arguments. TRUE if an odd number of argume… |
YEAR | Date | Returns the year component of an Excel date serial number (1900–9999). |
ZEROS | Matrix | Returns an m×n matrix filled with zeros. |
By Category
Math
ABS— Returns the absolute value of a number.CEIL(CEILING) — Rounds a number up, away from zero.CEILINGMATH— Rounds a number up to the nearest multiple of significance. For negative numbers, mode controls dire…CEILINGPRECISE— Rounds a number up to the nearest multiple of significance. The sign of significance is ignored; alw…COMBIN— Returns the number of combinations (n choose k) for a given number of items.E— Returns Euler's number (e), the base of the natural logarithm, approximately 2.71828182845905.ERF— Returns the error function integrated between 0 and a given value.ERFC— Returns the complementary error function: 1 - ERF(x).EVEN— Rounds a number up to the nearest even integer.EXP— Returns e raised to the power of a specified number.FACT— Returns the factorial of a non-negative integer.FLOOR— Rounds a number down, toward zero.FLOORMATH— Rounds a number down to the nearest multiple of significance. For negative numbers, mode controls di…FLOORPRECISE— Rounds a number down to the nearest multiple of significance. The sign of significance is ignored; a…GCD— Returns the greatest common divisor of two or more integers.INT— Rounds a number down to the nearest integer (toward negative infinity).LCM— Returns the least common multiple of two or more integers.LN— Returns the natural logarithm of a number.LOG— Returns the logarithm of a number to a specified base. When base is omitted, returns log base 10 (Ex…LOG10— Returns the base-10 logarithm of a number.MOD— Returns the remainder from a division.MROUND— Returns a number rounded to the nearest specified multiple.ODD— Rounds a number up to the nearest odd integer.PI— Returns the mathematical constant pi (π), approximately 3.14159265358979.POW(POWER) — Returns the result of a number raised to a power.QUOTIENT— Returns the integer portion of a division (truncates the remainder).RAND— Returns a random number greater than or equal to 0 and less than 1.RANDBETWEEN— Returns a random integer between the numbers you specify.ROUND— Rounds a number to a specified number of digits.ROUNDDOWN— Rounds a number down, toward zero, to a specified number of digits.ROUNDUP— Rounds a number up, away from zero, to a specified number of digits.SIGN— Returns the sign of a number: 1 for positive, -1 for negative, 0 for zero.SQRT— Returns the square root of a number.SUMSQ— Returns the sum of the squares of the arguments.TRUNC— Truncates a number to an integer or to a specified number of decimal places by removing the fraction…
Trig
ACOS— Returns the arccosine (inverse cosine) of a number, in radians.ACOSH— Returns the inverse hyperbolic cosine of a number. Number must be greater than or equal to 1.ASIN— Returns the arcsine (inverse sine) of a number, in radians.ASINH— Returns the inverse hyperbolic sine of a number.ATAN— Returns the arctangent (inverse tangent) of a number, in radians.ATAN2— Returns the arctangent of the x,y coordinates, in radians. The angle is measured counter-clockwise f…ATANH— Returns the inverse hyperbolic tangent of a number. Number must be between -1 and 1 (exclusive).COS— Returns the cosine of the given angle.COSH— Returns the hyperbolic cosine of a number.DEGREES— Converts an angle in radians to degrees.RADIANS— Converts an angle in degrees to radians.SIN— Returns the sine of the given angle.SINH— Returns the hyperbolic sine of a number.TAN— Returns the tangent of the given angle.TANH— Returns the hyperbolic tangent of a number.
Statistical
AVERAGE(AVG) — Calculates the average (arithmetic mean) of the arguments.CONFIDENCE— Returns the confidence interval for a population mean using a normal distribution.CORREL— Returns the Pearson correlation coefficient between two data sets.COUNT— Counts the number of cells that contain numeric values.COUNTA— Counts the number of cells that are not empty in a range.FORECAST— Predicts a future value along a linear trend using existing x and y values.FREQUENCY— Calculates how often values occur within a range of values and returns a vertical array of numbers.INTERCEPT— Returns the y-intercept of the linear regression line through the given data points.LARGE— Returns the k-th largest value in a data set.MAX— Returns the maximum value in a list of arguments.MEDIAN— Returns the median (middle value) of the given numbers. If there is an even number of values, return…MIN— Returns the minimum value in a list of arguments.MODE— Returns the most frequently occurring value in a data set.NORMDIST— Returns the normal distribution for the specified mean and standard deviation.NORMINV— Returns the inverse of the normal cumulative distribution for the specified mean and standard deviat…PERCENTILE— Returns the k-th percentile of values in a range, where k is between 0 and 1 inclusive.RANKAVG— Returns the rank of a number in a list. If multiple values have the same rank, the average rank is r…RANKEQ(RANK) — Returns the rank of a number in a list of numbers. Ties receive the same rank.RSQ— Returns the square of the Pearson product-moment correlation coefficient (R²) through the given data…SLOPE— Returns the slope of the linear regression line through the given data points.SMALL— Returns the k-th smallest value in a data set.STDEV— Estimates the standard deviation based on a sample (ignores text and logical values).STDEVP— Calculates the standard deviation based on the entire population (ignores text and logical values).SUM— Calculates the sum of a list of numbers or ranges.VAR— Estimates variance based on a sample (ignores text and logical values).VARP— Calculates variance based on the entire population (ignores text and logical values).
Aggregate
AVERAGEIF— Averages cells that meet a criteria.AVERAGEIFS— Averages values in average_range where ALL criteria match. Returns #DIV/0! if no rows match.COUNTIF— Counts cells that meet a criteria.COUNTIFS— Counts cells that meet multiple criteria across multiple ranges.MAXIFS— Returns the maximum value among cells that meet one or more criteria.MINIFS— Returns the minimum value among cells that meet one or more criteria.PRODUCT— Multiplies all values together.SUBTOTAL— Returns a subtotal in a list or database. Use function_num 1-11 (include all) or 101-111 (exclude hi…SUMIF— Sums cells that meet a criteria.SUMIFS— Sums cells that meet multiple criteria.SUMPRODUCT— Returns the sum of products of corresponding elements in one or more arrays.
Logical
AND— Returns TRUE if all arguments are truthy, FALSE otherwise. Short-circuits on first false.FALSE— Returns the boolean value FALSE (0).IF— Returns one value if condition is true, another if false.IFS— Returns the value corresponding to the first true condition. Evaluates conditions left-to-right and …NOT— Returns the opposite boolean value. TRUE becomes FALSE, FALSE becomes TRUE.OR— Returns TRUE if any argument is truthy, FALSE otherwise. Short-circuits on first true.SWITCH— Evaluates an expression against a list of values and returns the result corresponding to the first m…TRUE— Returns the boolean value TRUE (1).XOR— Returns a logical exclusive OR of all arguments. TRUE if an odd number of arguments are true, FALSE …
Lookup
CHOOSE— Returns a value from a list of values based on an index number.COLUMN— Returns the column number of a reference.HLOOKUP— Searches for a value in the first row of a table array and returns a value in the same column from a…IFERROR— Returns a specified value if a formula evaluates to an error; otherwise returns the formula result.IFNA— Returns a specified value if a formula evaluates to #N/A error; otherwise returns the formula result…INDEX— Returns the value of a cell in a range specified by a row and column number.INDIRECT— Returns the reference specified by a text string.MATCH— Returns the relative position of a value within a range.OFFSET— Returns a reference offset from a given reference by a specified number of rows and columns.ROW— Returns the row number of a reference.VLOOKUP— Searches for a value in the first column of a table array and returns a value in the same row from a…XLOOKUP— Searches a range or array for a match and returns the corresponding item from a second range or arra…XMATCH— Returns the relative position of an item in an array or range.
Matrix
CHOL(CHOLESKY) — Cholesky decomposition: returns the lower-triangular factor L of a symmetric positive-definite matri…COLS(COLUMNS) — Returns the number of columns in a matrix.COND— Estimates the condition number of a square matrix (Frobenius-norm approximation ‖A‖·‖A⁻¹‖); large va…DET(DETERMINANT) — Returns the determinant of a square matrix.DIAG— Creates a diagonal matrix from a list of values. The values appear on the main diagonal; all other e…EIGVAL— Returns the dominant (largest-magnitude) eigenvalue of a square matrix, computed by power iteration.IDENTITY(EYE) — Returns an n×n identity matrix (1s on the diagonal, 0s elsewhere).INV(INVERSE) — Returns the inverse of a square matrix.MRANK— Returns the rank of a matrix (the number of linearly independent rows or columns).MSOLVE— Solves the linear system A·x = b for x, where A is a square matrix and b is a column vector.NORM— Returns the Frobenius norm of a matrix (square root of sum of squared elements).ONES— Returns an m×n matrix filled with ones.QR— QR decomposition: returns the orthogonal factor Q of A = Q·R (via Householder reflections). Recover …ROWS— Returns the number of rows in a matrix.TRACE(TR) — Returns the trace of a square matrix (sum of diagonal elements).TRANSPOSE— Returns the transpose of a matrix (rows become columns and columns become rows).ZEROS— Returns an m×n matrix filled with zeros.
Information
ERRORTYPE— Returns a numeric code classifying an error: 2=#DIV/0!, 3=#VALUE!, 4=#REF!, 5=#NAME?, 6=#NUM!, 7=#N/…ISBLANK— Returns TRUE if the value refers to an empty cell, FALSE otherwise.ISERROR— Returns TRUE if the value is any error value, FALSE otherwise.ISNA— Returns TRUE if the value is the #N/A error value, FALSE otherwise.ISNUMBER— Returns TRUE if the value is a number, FALSE otherwise.ISTEXT— Returns TRUE if the value is text, FALSE otherwise.N— Converts a value to a number. Numbers return as-is; text and other values return 0.NA— Returns the #N/A error value. Use to indicate a value is unavailable.TYPE— Returns a type code: 1 for numbers, 2 for text, 64 for arrays/matrices.
Text
CHAR— Returns the character specified by the ASCII code number.CLEAN— Removes all non-printable characters (ASCII 0–31) from text.CODE— Returns the ASCII code of the first character in a text string.CONCAT(CONCATENATE) — Joins two or more text strings into one string.EXACT— Compares two text strings and returns TRUE (1) if they are exactly the same (case-sensitive), FALSE …FIND— Finds one text string within another (case-sensitive) and returns the start position.FIXED— Rounds a number to the specified number of decimals and returns the result as text.LEFT— Returns a specified number of characters from the start of a text string.LEN— Returns the number of characters in a text string.LOWER— Converts a text string to all lowercase letters.MID— Returns a specific number of characters from a text string, starting at the position you specify.NUMBERVALUE— Converts text to a number using locale-aware decimal and group separators. Handles trailing % sign.REPLACE— Replaces part of a text string with a different text string.REPT— Repeats text a specified number of times.RIGHT— Returns a specified number of characters from the end of a text string.SEARCH— Finds one text string within another (case-insensitive) and returns the start position.SUBSTITUTE— Substitutes new text for old text in a text string.T— Returns the value if it is text, or an empty string if it is a number or other type.TEXT— Converts a number to text using a specified format.TEXTJOIN— Joins a list of text strings using a delimiter, with option to ignore empty strings.TOFTIN— Converts a length value to a foot-inch string (e.g. 63 in → "5'-3""). Accepts any length unit; dime…TRIM— Removes all spaces from text except for single spaces between words.UPPER— Converts a text string to all uppercase letters.VALUE— Converts a text string that represents a number to a number.
Engineering
BILINTERP— Bilinear interpolation (and extrapolation) over a 2D data table. known_xs and known_ys must each hav…BIN2DEC— Converts a binary number to decimal.CLAMP— Clamps a value to the range [min, max]. Returns min if value < min, max if value > max, otherwise va…COMPLEX— Converts real and imaginary coefficients into a complex number of the form x + yi.CONC_FC— Returns a material property for normal-weight concrete with compressive strength fc (psi) per ACI 31…DEC2BIN— Converts a decimal number to binary.DEC2HEX— Converts a decimal number to hexadecimal.DELTA— Tests whether two values are equal. Returns 1 if they are equal, 0 otherwise.GESTEP— Returns 1 if number is greater than or equal to step; returns 0 otherwise.HEX2DEC— Converts a hexadecimal number to decimal.IMABS— Returns the absolute value (modulus) of a complex number.IMAGINARY— Returns the imaginary coefficient of a complex number.IMREAL— Returns the real coefficient of a complex number.ITERATE— Bounded fixed-point iteration: evaluates the update expression with the named variable bound, n time…LINTERP— Linear interpolation (and extrapolation) over a table of (x, y) pairs. known_xs must be sorted ascen…MAP— Linearly maps a value from the input range [from_low, from_high] to the output range [to_low, to_hig…OCT2DEC— Converts an octal number to decimal.PHITABLE— Returns a property of an AISC W-shape from the AISC Steel Construction Manual (15th/16th edition). D…RATIO— Returns demand / capacity as a dimensionless number. Throws an error if capacity is zero.REBAR— Returns a property of a standard ASTM rebar (reinforcing bar). Sizes #3–#18. Default property is "ar…SOLVE— Bisection root-finder: the value of the named variable in [lo, hi] where the expression equals the t…WITHIN— Returns 1 if min ≤ value ≤ max (using SI values), otherwise 0.
DynamicArray
FILTER— Filters a range of data based on criteria you define.SEQUENCE— Generates a list of sequential numbers in an array.SORT— Sorts the contents of a range or array.SORTBY— Sorts the contents of a range or array based on the values in a corresponding range or array.UNIQUE— Returns a list of unique values in a list or range.
Date
DATE— Returns the Excel serial number for the specified date. Handles month and day overflow (e.g. month=1…DATEDIF— Returns the difference between two dates in the requested unit. Units: "D" days, "M" complete months…DAY— Returns the day-of-month component of an Excel date serial number (1–31).EDATE— Returns the serial number of the date a given number of months before or after a start date, keeping…EOMONTH— Returns the serial number of the last day of the month a given number of months before or after a st…MONTH— Returns the month component of an Excel date serial number (1–12).NOW— Returns the current date and time as an Excel serial number. Integer part is the date, fractional pa…TODAY— Returns the current date as an Excel serial number (integer). Volatile — recalculates each evaluatio…WEEKDAY— Returns the day of the week for a date serial. return_type: 1 = Sun–Sat → 1–7 (default), 2 = Mon–Sun…YEAR— Returns the year component of an Excel date serial number (1900–9999).
Auto-generated from the EngCanvas function registry.