Based on the official Microsoft Excel Documentation, the following table lists all the formulas covered by Smart Tables

FunctionShort description
ABSMath and trigonometry: Returns the absolute value of a number
ACCRINTFinancial: Returns the accrued interest for a security that pays periodic interest
ACOSMath and trigonometry: Returns the arccosine of a number
ACOSHMath and trigonometry: Returns the inverse hyperbolic cosine of a number
ACOTMath and trigonometry: Returns the arccotangent of a number
ACOTHMath and trigonometry: Returns the hyperbolic arccotangent of a number
AGGREGATEMath and trigonometry: Returns an aggregate in a list or database
ANDLogical: Returns TRUE if all of its arguments are TRUE
ARABICMath and trigonometry: Converts a Roman number to Arabic, as a number
ASINMath and trigonometry: Returns the arcsine of a number
ASINHMath and trigonometry: Returns the inverse hyperbolic sine of a number
ATANMath and trigonometry: Returns the arctangent of a number
ATAN2Math and trigonometry: Returns the arctangent from x- and y-coordinates
ATANHMath and trigonometry: Returns the inverse hyperbolic tangent of a number
AVEDEVStatistical: Returns the average of the absolute deviations of data points from their mean
AVERAGEStatistical: Returns the average of its arguments
AVERAGEAStatistical: Returns the average of its arguments, including numbers, text, and logical values
AVERAGEIFStatistical: Returns the average (arithmetic mean) of all the cells in a range that meet a given criteria
AVERAGEIFSStatistical: Returns the average (arithmetic mean) of all cells that meet multiple criteria.
BASEMath and trigonometry: Converts a number into a text representation with the given radix (base)
BESSELIEngineering: Returns the modified Bessel function In(x)
BESSELJEngineering: Returns the Bessel function Jn(x)
BESSELKEngineering: Returns the modified Bessel function Kn(x)
BESSELYEngineering: Returns the Bessel function Yn(x)
BETA.DISTStatistical: Returns the beta cumulative distribution function
BETA.INVStatistical: Returns the inverse of the cumulative distribution function for a specified beta distribution
BETADISTCompatibility: Returns the beta cumulative distribution function
BETAINVCompatibility: Returns the inverse of the cumulative distribution function for a specified beta distribution
BIN2DECEngineering: Converts a binary number to decimal
BIN2HEXEngineering: Converts a binary number to hexadecimal
BIN2OCTEngineering: Converts a binary number to octal
BINOM.DISTStatistical: Returns the individual term binomial distribution probability
BINOM.DIST.RANGEStatistical: Returns the probability of a trial result using a binomial distribution
BINOM.INVStatistical: Returns the smallest value for which the cumulative binomial distribution is less than or equal to a criterion value
BINOMDISTCompatibility: Returns the individual term binomial distribution probability
BITANDEngineering: Returns a 'Bitwise And' of two numbers
BITLSHIFTEngineering: Returns a value number shifted left by shift_amount bits
BITOREngineering: Returns a bitwise OR of 2 numbers
BITRSHIFTEngineering: Returns a value number shifted right by shift_amount bits
BITXOREngineering: Returns a bitwise 'Exclusive Or' of two numbers
CEILINGMath and trigonometry: Rounds a number to the nearest integer or to the nearest multiple of significance
CHARText: Returns the character specified by the code number
CHISQ.DISTStatistical: Returns the cumulative beta probability density function
CHISQ.DIST.RTStatistical: Returns the one-tailed probability of the chi-squared distribution
CHISQ.INVStatistical: Returns the cumulative beta probability density function
CHISQ.INV.RTStatistical: Returns the inverse of the one-tailed probability of the chi-squared distribution
CHOOSELookup and reference: Chooses a value from a list of values
CHOOSELookup and reference: Chooses a value from a list of values
CLEANText: Removes all nonprintable characters from text
CODEText: Returns a numeric code for the first character in a text string
COLUMNLookup and reference: Returns the column number of a reference
COLUMNSLookup and reference: Returns the number of columns in a reference
COMBINMath and trigonometry: Returns the number of combinations for a given number of objects
COMBINAMath and trigonometry:
Returns the number of combinations with repetitions for a given number of items
COMPLEXEngineering: Converts real and imaginary coefficients into a complex number
CONCATENATEText: Joins several text items into one text item
CONFIDENCECompatibility: Returns the confidence interval for a population mean
CONFIDENCE.NORMStatistical: Returns the confidence interval for a population mean
CONFIDENCE.TStatistical: Returns the confidence interval for a population mean, using a Student's t distribution
CONVERTEngineering: Converts a number from one measurement system to another
CORRELStatistical: Returns the correlation coefficient between two data sets
COSMath and trigonometry: Returns the cosine of a number
COSHMath and trigonometry: Returns the hyperbolic cosine of a number
COTMath and trigonometry: Returns the hyperbolic cosine of a number
COTHMath and trigonometry: Returns the cotangent of an angle
COUNTStatistical: Counts how many numbers are in the list of arguments
COUNTAStatistical: Counts how many values are in the list of arguments
COUNTBLANKStatistical: Counts the number of blank cells within a range
COUNTIFStatistical: Counts the number of cells within a range that meet the given criteria
COUNTIFSStatistical: Counts the number of cells within a range that meet multiple criteria
COVARIANCE.PStatistical: Returns covariance, the average of the products of paired deviations
COVARIANCE.SStatistical: Returns the sample covariance, the average of the products deviations for each data point pair in two data sets
CSCMath and trigonometry: Returns the cosecant of an angle
CSCHMath and trigonometry: Returns the hyperbolic cosecant of an angle
CUMIPMTFinancial: Returns the cumulative interest paid between two periods
CUMPRINCFinancial: Returns the cumulative principal paid on a loan between two periods
DATEVALUEDate and time: Converts a date in the form of text to a serial number
DAYDate and time: Converts a serial number to a day of the month
DAYSDate and time: Returns the number of days between two dates
DAYS360Date and time: Calculates the number of days between two dates based on a 360-day year
DBFinancial: Returns the depreciation of an asset for a specified period by using the fixed-declining balance method
DDBFinancial: Returns the depreciation of an asset for a specified period by using the double-declining balance method or some other method that you specify
DEC2BINEngineering: Converts a decimal number to binary
DEC2HEXEngineering: Converts a decimal number to hexadecimal
DEC2OCTEngineering: Converts a decimal number to octal
DECIMALMath and trigonometry: Converts a text representation of a number in a given base into a decimal number
DEGREESMath and trigonometry: Converts radians to degrees
DELTAEngineering: Tests whether two values are equal
DEVSQStatistical: Returns the sum of squares of deviations
DOLLARDEFinancial: Converts a dollar price, expressed as a fraction, into a dollar price, expressed as a decimal number
DOLLARFRFinancial: Converts a dollar price, expressed as a decimal number, into a dollar price, expressed as a fraction
EFFECTFinancial: Returns the effective annual interest rate
EOMONTHDate and time: Returns the serial number of the last day of the month before or after a specified number of months
ERFEngineering: Returns the error function
ERFCEngineering: Returns the complementary error function
EVENMath and trigonometry: Rounds a number up to the nearest even integer
EXACTText: Checks to see if two text values are identical
EXPMath and trigonometry: Returns e raised to the power of a given number
EXPON.DISTStatistical: Returns the exponential distribution
EXPONDISTCompatibility: Returns the exponential distribution
F.DISTStatistical: Returns the F probability distribution
F.DIST.RTStatistical: Returns the F probability distribution
F.INVStatistical: Returns the inverse of the F probability distribution
F.INV.RTStatistical: Returns the inverse of the F probability distribution
FACTDOUBLEMath and trigonometry: Returns the double factorial of a number
FALSELogical: Returns the logical value FALSE
FDISTCompatibility: Returns the F probability distribution
FINVStatistical: Returns the inverse of the F probability distribution
FISHERStatistical: Returns the Fisher transformation
FISHERINVStatistical: Returns the inverse of the Fisher transformation
FLOORCompatibility: Rounds a number down, toward zero
FORECASTStatistical: Returns a value along a linear trend
FREQUENCYStatistical: Returns a frequency distribution as a vertical array
FVFinancial: Returns the future value of an investment
FVSCHEDULEFinancial: Returns the future value of an initial principal after applying a series of compound interest rates
GAMMA.DISTStatistical: Returns the gamma distribution
GAMMA.INVStatistical: Returns the inverse of the gamma cumulative distribution
GAMMAINVCompatibility: Returns the inverse of the gamma cumulative distribution
GAMMALNStatistical: Returns the natural logarithm of the gamma function, Γ(x)
GAMMALN.PRECISEStatistical: Returns the natural logarithm of the gamma function, Γ(x)
GAUSSStatistical: Returns 0.5 less than the standard normal cumulative distribution
GCDMath and trigonometry: Returns the greatest common divisor
GEOMEANStatistical: Returns the geometric mean
GESTEPEngineering: Tests whether a number is greater than a threshold value
GROWTHStatistical: Returns values along an exponential trend
HEX2BINEngineering: Converts a hexadecimal number to binary
HEX2DECEngineering: Converts a hexadecimal number to decimal
HEX2OCTEngineering: Converts a hexadecimal number to octal
HOURDate and time: Converts a serial number to an hour
HYPGEOM.DISTStatistical: Returns the hypergeometric distribution
HYPGEOMDISTCompatibility: Returns the hypergeometric distribution
IMABSEngineering: Returns the absolute value (modulus) of a complex number
IMAGINARYEngineering: Returns the imaginary coefficient of a complex number
IMARGUMENTEngineering: Returns the argument theta, an angle expressed in radians
IMCONJUGATEEngineering: Returns the complex conjugate of a complex number
IMCOSEngineering: Returns the cosine of a complex number
IMCOSHEngineering: Returns the hyperbolic cosine of a complex number
IMCOTEngineering: Returns the cotangent of a complex number
IMCSCEngineering: Returns the cosecant of a complex number
IMCSCHEngineering: Returns the hyperbolic cosecant of a complex number
IMDIVEngineering: Returns the quotient of two complex numbers
IMEXPEngineering: Returns the exponential of a complex number
IMLNEngineering: Returns the natural logarithm of a complex number
IMLOG10Engineering: Returns the base-10 logarithm of a complex number
IMLOG2Engineering: Returns the base-2 logarithm of a complex number
IMPOWEREngineering: Returns a complex number raised to an integer power
IMPRODUCTEngineering: Returns the product of complex numbers
IMREALEngineering: Returns the real coefficient of a complex number
IMSECEngineering: Returns the secant of a complex number
IMSECHEngineering: Returns the hyperbolic secant of a complex number
IMSINEngineering: Returns the sine of a complex number
IMSINHEngineering: Returns the hyperbolic sine of a complex number
IMSQRTEngineering: Returns the square root of a complex number
IMSUBEngineering: Returns the difference between two complex numbers
IMSUMEngineering: Returns the sum of complex numbers
IMTANEngineering: Returns the tangent of a complex number
INTMath and trigonometry: Rounds a number down to the nearest integer
INTERCEPTStatistical: Returns the intercept of the linear regression line
IPMTFinancial: Returns the interest payment for an investment for a given period
IRRFinancial: Returns the internal rate of return for a series of cash flows
ISBLANKInformation: Returns TRUE if the value is blank
ISEVENInformation: Returns TRUE if the number is even
ISLOGICALInformation: Returns TRUE if the value is a logical value
ISNONTEXTInformation: Returns TRUE if the value is not text
ISNUMBERInformation: Returns TRUE if the value is a number
ISODDInformation: Returns TRUE if the number is odd
ISODDInformation: Returns TRUE if the number is odd
ISOWEEKNUMDate and time: Returns the number of the ISO week number of the year for a given date
ISTEXTInformation: Returns TRUE if the value is text
LCMMath and trigonometry: Returns the least common multiple
LEFTText: Returns the leftmost characters from a text value
LENText: Returns the number of characters in a text string
LINESTStatistical: Returns the parameters of a linear trend
LNMath and trigonometry: Returns the natural logarithm of a number
LOGMath and trigonometry: Returns the logarithm of a number to a specified base
LOG10Math and trigonometry: Returns the base-10 logarithm of a number
LOGESTStatistical: Returns the parameters of an exponential trend
LOGNORM.DISTStatistical: Returns the cumulative lognormal distribution
LOGNORM.INVStatistical: Returns the inverse of the lognormal cumulative distribution
LOGNORMDISTCompatibility: Returns the cumulative lognormal distribution
LOWERText: Converts text to lowercase
MAXStatistical: Returns the maximum value in a list of arguments
MAXAStatistical: Returns the maximum value in a list of arguments, including numbers, text, and logical values
MEDIANStatistical: Returns the median of the given numbers
MINStatistical: Returns the minimum value in a list of arguments
MINAStatistical: Returns the smallest value in a list of arguments, including numbers, text, and logical values
MINUTEDate and time: Converts a serial number to a minute
MIRRFinancial: Returns the internal rate of return where positive and negative cash flows are financed at different rates
MODMath and trigonometry: Returns the remainder from division
MODE.MULTStatistical: Returns a vertical array of the most frequently occurring, or repetitive values in an array or range of data
MODE.SNGLStatistical: Returns the most common value in a data set
MONTHDate and time: Converts a serial number to a month
MROUNDMath and trigonometry: Returns a number rounded to the desired multiple
MULTINOMIALMath and trigonometry: Returns the multinomial of a set of numbers
NEGBINOM.DISTStatistical: Returns the negative binomial distribution
NEGBINOMDISTCompatibility: Returns the negative binomial distribution
NETWORKDAYSDate and time: Returns the number of whole workdays between two dates
NOMINALFinancial: Returns the annual nominal interest rate
NORM.DISTStatistical: Returns the normal cumulative distribution
NORM.INVCompatibility: Returns the inverse of the normal cumulative distribution
NORM.S.DISTStatistical: Returns the standard normal cumulative distribution
NORM.S.INVStatistical: Returns the inverse of the standard normal cumulative distribution
NORMDISTCompatibility: Returns the normal cumulative distribution
NORMINVStatistical: Returns the inverse of the normal cumulative distribution
NORMSDISTCompatibility: Returns the standard normal cumulative distribution
NORMSINVCompatibility: Returns the inverse of the standard normal cumulative distribution
NOTLogical: Reverses the logic of its argument
NOWDate and time: Returns the serial number of the current date and time
NPERFinancial: Returns the number of periods for an investment
NPVFinancial: Returns the net present value of an investment based on a series of periodic cash flows and a discount rate
OCT2DECEngineering: Converts an octal number to decimal
OCT2HEXEngineering: Converts an octal number to hexadecimal
ODDMath and trigonometry: Rounds a number up to the nearest odd integer
ORLogical: Returns TRUE if any argument is TRUE
PEARSONStatistical: Returns the Pearson product moment correlation coefficient
PERMUTStatistical: Returns the number of permutations for a given number of objects
PERMUTATIONAStatistical: Returns the number of permutations for a given number of objects (with repetitions) that can be selected from the total objects
PHIStatistical: Returns the value of the density function for a standard normal distribution
PIMath and trigonometry: Returns the value of pi
PMTFinancial: Returns the periodic payment for an annuity
POISSON.DISTStatistical: Returns the Poisson distribution
POWERMath and trigonometry: Returns the result of a number raised to a power
PPMTFinancial: Returns the payment on the principal for an investment for a given period
PROBStatistical: Returns the probability that values in a range are between two limits
PRODUCTMath and trigonometry: Multiplies its arguments
PROPERText: Capitalizes the first letter in each word of a text value
PVFinancial: Returns the present value of an investment
QUARTILE.EXCStatistical: Returns the quartile of the data set, based on percentile values from 0..1, exclusive
QUARTILE.INCStatistical: Returns the quartile of a data set
QUOTIENTMath and trigonometry: Returns the integer portion of a division
RANDMath and trigonometry: Returns a random number between 0 and 1
RANDBETWEENMath and trigonometry: Returns a random number between the numbers you specify
RANK.AVGStatistical: Returns the rank of a number in a list of numbers
RANK.EQStatistical: Returns the rank of a number in a list of numbers
RATEFinancial: Returns the interest rate per period of an annuity
REPTText: Repeats text a given number of times
RIGHTText: Returns the rightmost characters from a text value
ROMANMath and trigonometry: Converts an arabic numeral to roman, as text
ROUNDMath and trigonometry: Rounds a number to a specified number of digits
ROUNDDOWNMath and trigonometry: Rounds a number down, toward zero
ROUNDUPMath and trigonometry: Rounds a number up, away from zero
ROWLookup and reference: Returns the row number of a reference
ROWSLookup and reference: Returns the number of rows in a reference
RRIFinancial: Returns an equivalent interest rate for the growth of an investment
RSQStatistical: Returns the square of the Pearson product moment correlation coefficient
SECMath and trigonometry: Returns the secant of an angle
SECHMath and trigonometry: Returns the hyperbolic secant of an angle
SECONDDate and time: Converts a serial number to a second
SERIESSUMMath and trigonometry: Returns the sum of a power series based on the formula
SIGNMath and trigonometry: Returns the sign of a number
SINMath and trigonometry: Returns the sine of the given angle
SINHMath and trigonometry: Returns the hyperbolic sine of a number
SKEWStatistical: Returns the skewness of a distribution
SKEW.PStatistical: Returns the skewness of a distribution based on a population: a characterization of the degree of asymmetry of a distribution around its mean
SLNFinancial: Returns the straight-line depreciation of an asset for one period
SLOPEStatistical: Returns the slope of the linear regression line
SMALLStatistical: Returns the k-th smallest value in a data set
SQRTMath and trigonometry: Returns a positive square root
SQRTPIMath and trigonometry: Returns the square root of (number * pi)
STANDARDIZEStatistical: Returns a normalized value
STDEV.PStatistical: Calculates standard deviation based on the entire population
STDEV.SStatistical: Estimates standard deviation based on a sample
STDEVAStatistical: Estimates standard deviation based on a sample, including numbers, text, and logical values
STDEVPCompatibility: Calculates standard deviation based on the entire population
STDEVPAStatistical: Calculates standard deviation based on the entire population, including numbers, text, and logical values
STEYXStatistical: Returns the standard error of the predicted y-value for each x in the regression
SUBSTITUTEText: Substitutes new text for old text in a text string
SUBTOTALMath and trigonometry: Returns a subtotal in a list or database
SUMMath and trigonometry: Adds its arguments
SUMIFMath and trigonometry: Adds the cells specified by a given criteria, only two params SUMIF(RANGE, CRITERIA)
SUMIFSMath and trigonometry: Adds the cells in a range that meet multiple criteria, only two params SUMIFS(RANGE, CRITERIA)
SUMPRODUCTMath and trigonometry: Returns the sum of the products of corresponding array components
SUMSQMath and trigonometry: Returns the sum of the squares of the arguments
SUMX2MY2Math and trigonometry: Returns the sum of the difference of squares of corresponding values in two arrays
SUMX2PY2Math and trigonometry: Returns the sum of the sum of squares of corresponding values in two arrays
SUMXMY2Math and trigonometry: Returns the sum of squares of differences of corresponding values in two arrays
SWITCHLogical: Evaluates an expression against a list of values and returns the result corresponding to the first matching value. If there is no match, an optional default value may be returned.
SYDFinancial: Returns the sum-of-years' digits depreciation of an asset for a specified period
T.DISTStatistical: Returns the Percentage Points (probability) for the Student t-distribution
T.DIST.2TStatistical: Returns the Percentage Points (probability) for the Student t-distribution
T.DIST.RTStatistical: Returns the Student's t-distribution
T.INVStatistical: Returns the t-value of the Student's t-distribution as a function of the probability and the degrees of freedom
T.INV.2TStatistical: Returns the inverse of the Student's t-distribution
TANMath and trigonometry: Returns the tangent of a number
TANHMath and trigonometry: Returns the hyperbolic tangent of a number
TBILLEQFinancial: Returns the bond-equivalent yield for a Treasury bill
TBILLPRICEFinancial: Returns the price per \$100 face value for a Treasury bill
TBILLYIELDFinancial: Returns the yield for a Treasury bill
TDISTCompatibility: Returns the Student's t-distribution
TIMEDate and time: Returns the serial number of a particular time
TIMEVALUEDate and time: Converts a time in the form of text to a serial number
TINVCompatibility: Returns the inverse of the Student's t-distribution
TODAYDate and time: Returns the serial number of today's date
TRANSPOSELookup and reference: Returns the transpose of an array
TRENDStatistical: Returns values along a linear trend
TRIMText: Removes spaces from text
TRIMMEANStatistical: Returns the mean of the interior of a data set
TRUELogical: Returns the logical value TRUE
TRUNCMath and trigonometry: Truncates a number to an integer
UNICODEText: Returns the number (code point) that corresponds to the first character of the text
UNIQUELookup and reference: Returns a list of unique values in a list or range
UPPERText: Converts text to uppercase
VAR.PStatistical: Calculates variance based on the entire population
VAR.SStatistical: Estimates variance based on a sample
VARAStatistical: Estimates variance based on a sample, including numbers, text, and logical values
VARPCompatibility: Calculates variance based on the entire population
VARPAStatistical: Calculates variance based on the entire population, including numbers, text, and logical values
WEEKDAYDate and time: Converts a serial number to a day of the week
WEEKNUMDate and time: Converts a serial number to a number representing where the week falls numerically with a year
WEIBULL.DISTStatistical: Returns the Weibull distribution
WORKDAYDate and time: Returns the serial number of the date before or after a specified number of workdays
XNPVFinancial: Returns the net present value for a schedule of cash flows that is not necessarily periodic
XORLogical: Returns a logical exclusive OR of all arguments
YEARFRACDate and time: Returns the year fraction representing the number of whole days between start_date and end_date