• Getting Started
• Components
• Barcodes
• Buttons
• Chartsupdated
• Conversational UIupdated
• Data Query
• Date Inputsupdated
• Date Math
• Dialogs
• Drawing
• Dropdownsupdated
• Editor
• Excel Export
• File Saver
• Filter
• Gantt
• Gauges
• Gridupdated
• Icons
• Indicators
• Inputsupdated
• Labels
• Layout
• ListBox
• ListView
• Map
• Pager
• PDF Export
• PDFViewer
• PivotGridupdated
• Popup
• ProgressBars
• Ripple
• Schedulerupdated
• ScrollView
• Sortable
• ToolBar
• Tooltips
• TreeList
• TreeView
• Typography
• Utilities
• Styling & Themes
• Common Features
• Project Setup
• Knowledge Base
• Sample Applications
• FAQ
• Troubleshooting
• Changelogs
New to Kendo UI for Angular? Start a free 30-day trial

# Angular Spreadsheet Built-in Formulas and Functions

The following table provides a list of the formulas and functions the Spreadsheet supports.

FunctionDescription
ABSReturns the absolute (nonnegative) value of a number.
ACOSReturns the principal value of the arccosine of a number in radians.
ACOSHReturns the principal value of the inverse hyperbolic cosine of a number.
ACOTReturns the principal value of the arccotangent of a number in radians.
ACOTHReturns the hyperbolic arccotangent of a number.
ADDRESSReturns a cell address (reference) as text.
AGGREGATEReturns an aggregate of a list or database.
ARABICConverts Roman numbers to Arabic as numbers.
AREASReturns the number of areas in a reference.
ASINReturns the principal value of the arcsine of a number in radians.
ASINHReturns the principal value of the inverse hyperbolic sine of a number.
ATANReturns the principal value of the arctangent of a number in radians.
ATAN2Returns the principal value of the arctangent from x- and y- coordinates in radians.
ATANHReturns the principal value of the inverse hyperbolic tangent of a number.
AVEDEVCalculates the average of the absolute deviations of listed values.
AVERAGEReturns the average of a set of numbers.
AVERAGEAReturns the average of values, including numbers, text, and logical values.
AVERAGEIFReturns the average of all cells in a range based on a given criteria.
AVERAGEIFSReturns the average of all cells in a range based on multiple criteria.
BASEConverts a number into a text representation with the given base.
BETA.DISTReturns the beta cumulative distribution function.
BETA.INVReturns the inverse of the cumulative distribution function for a specified beta distribution.
BETADISTReturns the value of the probability density function or the cumulative distribution function for the beta distribution.
BINOM.DISTReturns the individual term binomial distribution probability.
BINOM.DIST.RANGEReturns the probability of a trial result using a binomial distribution.
BINOM.INVReturns the smallest value for which the cumulative binomial distribution is less than or equal to a criterion value.
BINOMDISTReturns the binomial distribution probability.
CEILINGRounds a number to the nearest integer or to the nearest multiple of significance.
CEILING.MATHRounds a number up, to the nearest integer or to the nearest multiple of significance.
CEILING.PRECISERounds a number to the nearest integer or to the nearest multiple of significance. Regardless of the sign of the number, the number is rounded up.
CHARReturn character represented by a given number.
CHISQ.DISTReturns the cumulative beta probability density function.
CHISQ.DIST.RTReturns the one-tailed probability of the chi-squared distribution.
CHISQ.INVReturns the cumulative beta probability density function.
CHISQ.INV.RTReturns the inverse of the one-tailed probability of the chi-squared distribution.
CHISQ.TESTReturns the test for independence.
CHOOSEUses an index to return a value from a list of values.
CLEANRemoves all nonprintable characters from a text.
CODEReturn a numeric value corresponding to the first character in a text string.
COLUMNReturns the column number(s) of a reference.
COLUMNSReturns the number of columns in a given range.
COMBINReturns the number of combinations for a given number of objects.
COMBINAReturns the number of combinations with repetitions for a given number of objects.
CONCATENATEJoins a number of text strings into one text string.
CONFIDENCE.NORMReturns the confidence interval for a population mean.
CONFIDENCE.TReturns the confidence interval for a population mean, using a Student's t distribution.
COSReturns the cosine of a number. The angle is returned in radians.
COSHReturns the hyperbolic cosine of a number.
COTReturns the cotangent of an angle, specified in radians.
COTHReturns the hyperbolic cotangent of a number.
COUNTCounts the number of numbers in a list of arguments.
COUNTACounts the number of values in a list of arguments.
COUNTBLANKCounts the number of blank cells in a range.
COUNTIFCounts the number of cells in a range that meet a criteria.
COUNTIFSCounts the number of cells in a range that meet multiple criteria.
COVARCalculates the covariance between two cell ranges.
COVARIANCE.PReturns covariance, the average of the products of paired deviations.
COVARIANCE.SReturns the sample covariance, the average of the product deviations for each data point pair in two data sets.
CRITBINOMReturns the smallest value for which the cumulative binomial distribution is less than or equal to a criterion value.
CSCReturns the cosecant of an angle, specified in radians.
CSCHReturns the hyperbolic cosecant of an angle, specified in radians.
DATEReturns a date value constructed from year, month, and day values.
DATEVALUEReturns the date converting it into the form of text to a serial number.
DAYReturns the day by converting it from a serial number.
DAYSReturns the number of days between two dates.
DAYS360Returns the number of days between two dates using the 360-day year.
DECIMALConverts a text representation of a number in a given base into a decimal number.
DEGREESConverts radians to degrees.
DOLLARConverts a number to text, using the `\$` currency format.
EDATEReturns the serial number of the date that is the indicated number of months before or after the start date.
EOMONTHReturns the serial number of the last day of the month before or after a specified number of months.
ERFReturns the error function.
ERFCReturns the complementary error function.
EVENRounds a number up to the nearest even integer.
EXACTReports if two text values are equal using a case-sensitive comparison.
EXPReturns `e` raised to the power of a given number.
EXPON.DISTReturns the exponential distribution.
F.DISTReturns the `F` probability distribution.
F.DIST.RTReturns the `F` probability distribution.
F.INVReturns the inverse of the `F` probability distribution.
F.INV.RTReturns the inverse of the `F` probability distribution.
F.TESTReturns the result of an `F`-test.
FACTReturn the factorial of a number.
FACTDOUBLEReturns the double factorial of a number.
FALSEReturns logical value `False`.
FINDReturns the starting position of a given text.
FISHERReturns the `Fisher` transformation.
FISHERINVReturns the inverse of the `Fisher` transformation.
FIXEDRounds the number to a specified number of decimals and formats the result as text.
FLOORRounds a number down to the nearest multiple of the second parameter.
FLOOR.MATHRounds a number down, to the nearest integer or to the nearest multiple of significance.
FLOOR.PRECISERounds a number down to the nearest integer or to the nearest multiple of significance. Regardless of the sign of the number, the number is rounded down.
FORECASTAssumes a future value based on existing x- and y- values.
FORMULATEXTReturns the formula at the given reference as text.
FREQUENCYReturns a frequency distribution as a vertical array.
GAMMAReturn `Gamma` function value.
GAMMA.DISTReturns the `Gamma` distribution.
GAMMA.INVReturns the inverse of the `Gamma` cumulative distribution.
GAMMALNReturns the natural logarithm of the `Gamma` function.
GAUSSReturns 0.5 less than the standard normal cumulative distribution.
GCDReturns the greatest common divisor (GCD).
GEOMEANReturns the geometric mean of a sequence.
HARMEANReturns the harmonic mean of a sequence.
HLOOKUPLooks for a matching value in the first row of a given table and returns the value of the indicated row.
HOURConverts a serial number to an hour.
HYPERLINKCreates a hyperlink involving an evaluated expression.
IFReturns one of two values, depending on a condition.
IFERRORReturns a specified value if a formula evaluates to an error; otherwise, returns the result of the formula.
INDEXReturns a value or a reference to a value from within a table or range.
INDIRECTReturns a reference indicated by a text value.
INTRounds a number down to the nearest integer.
INTERCEPTReturns the intercept of the linear regression line for the given data.
ISBLANKReturns `True` if the referenced cell is blank; else returns `False`.
ISERRReturns `True` if the value is any error except `#N/A`; else returns `False`.
ISERRORReturns `True` if the value is any error; else returns `False`.
ISEVENReturns `True` if the value is even; else returns `False`.
ISLOGICALReturns `True` if the value is logical; else returns `False`.
ISNAReturns `True` if the value is the `#N/A` error; else returns `False`.
ISNONTEXTReturns `True` if the value is not text; else returns `False`.
ISNUMBERReturns `True` if the value is a number; else returns `False`.
ISO.CEILINGReturns a number that is rounded up to the nearest integer or to the nearest multiple of significance.
ISODDReturns `True` if the value is odd; else returns `False`.
ISOWEEKNUMReturns the ISO week number of the year for a given date.
ISREFReturns `True` if the value is a reference; else returns `False`.
ISTEXTReturns `True` if the value is text; else returns `False`.
KURTReturns the kurtosis (“peakedness”) of a data set.
LARGEFinds the nth largest value in a list.
LCMReturns the least common multiple.
LEFTReturns a selected number of text characters from the left.
LENReturns the number of characters from a given text.
LINESTReturns the parameters of a (simple or multiple) linear regression equation for the given data and, optionally, statistics on this regression.
LNReturns the natural logarithm of a number.
LOGReturns the logarithm of a number to a specified base.
LOG10Returns the base-10 logarithm of a number.
LOGESTReturns the parameters of an exponential regression equation for the given data obtained by linearizing this intrinsically linear response function and returns, optionally, statistics on this regression.
LOGNORM.DISTReturns the cumulative lognormal distribution.
LOGNORM.INVReturns the inverse of the lognormal cumulative distribution.
LOWERConverts text to lowercase.
MATCHFinds an item in a range of cells and returns its relative position (starting from 1).
MAXReturns the maximum value in a set of numbers.
MDETERMReturns the determinant of a matrix.
MEDIANReturns the median (middle) value in a list of numbers.
MIDReturns a specific number of characters from a text string, starting at a specified position.
MINReturns the minimum value in a set of numbers.
MINUTEConverts a serial number into a minute.
MINVERSEReturns the inverse of a matrix.
MMULTReturns the matrix output of two arrays.
MODReturns the remainder when one number is divided by another number.
MODE.MULTReturns a vertical array of the most frequently occurring, or repetitive values in an array or range of data.
MODE.SNGLReturns the most common value in a data set.
MONTHConverts a serial number to a month.
MROUNDRounds the number to the desired multiple.
MULTINOMIALReturns the multinomial for a given set of values.
MUNITCreates a unit matrix of a specified dimension.
NReturns the number of a value.
NAReturns the error value `#N/A`.
NEGBINOM.DISTReturns the negative binomial distribution.
NEGBINOMDISTReturns the negative binomial distribution.
NETWORKDAYSReturns the number of whole workdays between two dates.
NORM.DISTReturns the normal cumulative distribution.
NORM.INVReturns the inverse of the normal cumulative distribution.
NORM.S.DISTReturns the standard normal cumulative distribution.
NORM.S.INVReturns the inverse of the standard normal cumulative distribution.
NOTReverses the logic of its argument.
NOWReturns the serial number of the current date and time.
ODDRounds a number up to the nearest odd integer, where "up" means "away from 0".
OFFSETModifies the position and dimension of a reference.
PEARSONReturns the `Pearson` correlation coefficient of two data sets.
PERCENTILECalculates the x-th sample percentile of values in a range.
PERCENTILE.EXCReturns the k-th percentile of values in a range, where k is in the range 0..1, exclusive.
PERCENTILE.INCReturns the k-th percentile of values in a range.
PERCENTRANKReturns the percentage rank of a value in a sample.
PERCENTRANK.EXCReturns the rank of a value in a data set as a percentage (0..1, exclusive) of the data set.
PERCENTRANK.INCReturns the percentage rank of a value in a data set.
PHIReturns the value of the density function for a standard normal distribution.
PIReturns the approximate value of pi.
POISSON.DISTReturns the `Poisson` distribution.
POWERReturns the result of a number raised to the power of another number.
PROBReturns the probability that values in a range are between two limits.
PRODUCTMultiplies the set of numbers, including all numbers inside ranges.
PROPERCapitalizes the first letter in each word of a text value.
QUARTILEReturns the quartile of a data set.
QUARTILE.EXCReturns the quartile of the data set, based on percentile values from 0..1, exclusive.
QUARTILE.INCReturns the quartile of a data set.
QUOTIENTReturns the integer portion of a division.
RANDReturns a random number between 0 (inclusive) and 1 (exclusive).
RANDBETWEENReturns a random number between specified values.
RANKReturns the rank of a number in a list of numbers.
RANK.AVGReturns the rank of a number in a list of numbers.
RANK.EQReturns the rank of a number in a list of numbers.
REPLACEReplaces characters within text.
REPTRepeats text a specified number of times.
RIGHTReturns the rightmost characters from a text value.
ROMANConverts Arabic numbers to Roman as text.
ROUNDDOWNRounds a number down, towards zero, to the number of digits specified by `digits`.
ROUNDUPRounds a number up, away from 0 (zero), to the number of digits specified by `digits`.
ROWReturns the row number(s) of a reference.
ROWSReturns the number of rows in a reference.
RSQReturns the square of the `Pearson` product moment correlation coefficient.
SEARCHFinds a text value within another text value (not case-sensitive).
SECReturns the secant of an angle specified in radians.
SECHReturns the hyperbolic secant of a given angle specified in radians.
SECONDConverts a serial number to a second. This function presumes that leap seconds never exist.
SERIESSUMReturns the sum of a power series based on the formula.
SIGNReturns the sign of a number.
SINReturns the sine of an angle specified in radians.
SINHReturns the hyperbolic sine of a number.
SLOPECalculates the slope of the linear regression line.
SMALLFinds the n-th smallest value in a data set.
SQRTReturns a positive square root of a number.
SQRTPIReturns the square root of a number multiplied by pi.
STDEV.PCalculates the standard deviation based on the entire population.
STDEV.SEstimates the standard deviation based on a sample.
STEYXReturns the standard error of the predicted y-value for each x in the regression.
SUBSTITUTESubstitutes new text for old text string.
SUBTOTALEvaluates a function on a range.
SUMSums (adds) the set of numbers, including all numbers in a range.
SUMIFSums the values of cells in a range that meets a given criterion.
SUMIFSSums the values of cells in a range that meets multiple criteria.
SUMPRODUCTReturns the sum of the products of corresponding array elements.
SUMSQSums (adds) the set of squares of numbers, including all numbers in a range.
SUMX2MY2Returns the sum of the difference between the squares of corresponding values in two arrays.
SUMX2PY2Returns the sum of squares of corresponding values in two arrays.
SUMXMY2Returns the sum of squares of corresponding values in two arrays.
TConverts its arguments to text; else returns a 0-length text value.
T.DISTReturns the Percentage Points (probability) for the Student t-distribution.
T.DIST.2TReturns the Percentage Points (probability) for the Student t-distribution.
T.DIST.RTReturns the Student's t-distribution.
T.INVReturns the t-value of the Student's t-distribution as a function of the probability and the degrees of freedom.
T.INV.2TReturns the inverse of the Student's t-distribution.
T.TESTReturns the probability associated with a Student's t-test.
TANReturns the tangent of a number in radians.
TANHReturns the hyperbolic tangent of a number.
TEXTFormats a number and converts it to text.
TIMEConstructs a time value from hours, minutes, and seconds.
TIMEVALUEReturns the serial number of a particular time.
TODAYReturns the serial number of today's date.
TRANSPOSEReturns the transpose of an array.
TRIMRemoves spaces from text; replaces all internal multiple spaces with a single space.
TRIMMEANReturns the mean of the interior of a data set, ignoring a proportion of high and low values.
TRUEReturns the logical value `True`.
UNICHARReturns the character represented by the given numeric value according to the Unicode Standard.
UNICODEReturns the Unicode code point that corresponds to the first character of a text value.
UPPERConverts text to uppercase.
VALUEConverts a text argument to a number.
VAR.PCalculates variance based on the entire population.
VAR.SEstimates variance based on a sample.
VLOOKUPLooks for a matching value in a table or a range by row.
WEEKDAYConverts a serial number to a day of the week.
WEEKNUMDetermines the week number of the year for a given date.
WORKDAYReturns the date serial number which is a specified number of work days before or after an input date.
YEARConverts a serial number to a year.
YEARFRACExtracts the number of years (including the fractional part) between two dates.

For more information on how to create formulas and what their syntax is, see the list of `Excel functions`.

## Array Formulas

Similar to Excel, the Spreadsheet supports `array formulas` which return a matrix of values. You have to enter them in the same way as in Excel—by pre-selecting the target range and pressing `Ctrl+Shift+Enter` to save the formula.