— No function —
ABS — Returns the absolute value of a number. The absolute value of a number is the number without its sign.
ACCRINT — Calculates the accrued interest of a security that pays periodic interest
ACCRINTM — Calculates the accrued interest of a security that pays its interest at maturity
ACOS — Returns the arccosine of a number — the angle (in radians) whose cosine equals the input value, in the range 0 to π
ACOSH — Returns the inverse hyperbolic cosine of a number
ACOT — Returns the arccotangent of a number (0 to π) — the angle whose cotangent equals the value
ACOTH — Returns the inverse hyperbolic cotangent of a number
ADDRESS — Builds a cell address as text from a row number and a column number
AGGREGATE — Performs calculations with awareness of filtered or hidden rows, with advanced options
AMORDEGRC — Calculates the depreciation of each accounting period using a declining coefficient and taking the purchase date into account
AMORLINC — Calculates the depreciation of each accounting period on a straight-line basis, taking the purchase date into account
AND — Checks whether two or more conditions are all TRUE
ARABIC — Converts a Roman numeral to a regular number
AREAS — Returns the number of separate areas in a reference
ARRAYTOTEXT — Converts the values of a range into a single text string
ASC — Converts full-width (double-byte) English and katakana characters to half-width (single-byte) — for Japanese data
ASIN — Returns the arcsine of a number — the angle whose sine equals the value (-π/2 to π/2)
ASINH — Returns the inverse hyperbolic sine of a number
ATAN — Returns the arctangent of a number (-π/2 to π/2)
ATAN2 — Returns the arctangent of the coordinates (x,y) in radians — with quadrant detection
ATANH — Returns the inverse hyperbolic tangent of a number — the value must be between -1 and 1
AVEDEV — Returns the average of the absolute deviations of numbers from their average
AVERAGE — Arithmetic mean
AVERAGEA — Calculates the average, taking text and logical values into account
AVERAGEIF — Conditional average
AVERAGEIFS — Average with one condition or multiple conditions (up to 127 conditions)
BASE — Converts a number to another base
BESSELI — Returns the modified Bessel function In(x) — engineering use
BESSELJ — Returns the Bessel function Jn(x)
BESSELK — Returns the modified Bessel function Kn(x)
BESSELY — Returns the Bessel function Yn(x) (Weber)
BETA.DIST — Calculates the beta distribution probability
BETA.INV — Returns the inverse of the cumulative beta distribution
BETADIST — Returns the cumulative beta distribution (the legacy compatibility version BETADIST) — for compatibility with Excel 2007
BETAINV — Returns the inverse of the cumulative beta distribution (compatibility)
BIN2DEC — Converts a binary number (up to 10 bits) to decimal
BIN2HEX — Converts a binary number to hexadecimal
BIN2OCT — Converts a binary number to octal
BINOM.DIST — Calculates the probability of a specified number of successes in a number of trials
BINOM.DIST.RANGE — Calculates the probability that the number of successes falls between two numbers
BINOM.INV — Returns the smallest number of successes at which the cumulative probability reaches a specified level
BINOMDIST — Returns the binomial distribution (compatibility) — the probability of successes in a number of trials
BITAND — Returns the bitwise AND of two numbers — a bit-by-bit comparison
BITLSHIFT — Bit-shifts a number to the left by a specified amount
BITOR — Returns the bitwise OR of two numbers
BITRSHIFT — Bit-shifts a number to the right by a specified amount
BITXOR — Returns the bitwise XOR (exclusive OR) of two numbers
BYCOL — Applies a calculation to each column of a range in turn and returns one result per column
BYROW — Applies a calculation to each row of a range in turn and returns one result per row
CEILING — Rounds a number up to the nearest multiple of a specified significance
CEILING.MATH — Rounds a number up to the nearest multiple of a specified significance
CEILING.PRECISE — Rounds a number up to the nearest multiple with high precision — unlike CEILING, the sign of significance does not matter
CELL — Returns information about a cell, such as its address, format, file name, or column width
CHAR — Returns the character whose code (a number between 1 and 255) is given
CHIDIST — Chi-square distribution (compatibility) — returns the right-tail probability of the chi-square distribution
CHIINV — Inverse of the chi-square distribution (compatibility) — returns the x value corresponding to the probability
CHISQ.DIST — Calculates the chi-square distribution probability from the left
CHISQ.DIST.RT — Calculates the right-tail probability of the chi-square distribution
CHISQ.INV — Returns the inverse of the left-tail probability of the chi-square distribution
CHISQ.INV.RT — Returns the critical value of the chi-square distribution from the right
CHISQ.TEST — Performs the chi-square test on observed and expected values
CHITEST — Returns the chi-square test of independence (compatibility)
CHOOSE — Returns one of several specified values based on a number
CHOOSECOLS — Extracts the desired columns from a range and returns them in the order you want
CHOOSEROWS — Extracts the desired rows from a range and returns them in the order you want
CLEAN — Removes non-printable characters such as line breaks and tabs
CODE — Returns the numeric code of the first character of a text
COLUMN — Returns the column number
COLUMNS — Returns the number of columns in a range
COMBIN — Returns the number of combinations of choosing several items from a number of objects without regard to order
COMBINA — Returns the number of combinations with repetition — COMBIN with repeated selections allowed
COMPLEX — Builds a complex number in the form a+bi from the real and imaginary parts
CONCAT — Joins and concatenates text strings together
CONCATENATE — Appends and joins text strings
CONFIDENCE — Returns the confidence interval for a population mean (compatibility) — for the normal distribution
CONFIDENCE.NORM — Calculates the margin of error of the mean using the normal distribution
CONFIDENCE.T — Calculates the margin of error of the mean using the t distribution
CONVERT — Converts a number from one measurement unit to another
CORREL — Returns the correlation coefficient between two sets of numbers
COS — Returns the cosine of an angle
COSH — Returns the hyperbolic cosine of a number
COT — Returns the cotangent of an angle (in radians)
COTH — Returns the hyperbolic cotangent of a number
COUNT — Counts numeric values only
COUNTA — Counts the cells that are not empty
COUNTBLANK — Counts empty cells
COUNTIF — Conditional count (a single condition)
COUNTIFS — Count with one condition or multiple conditions
COUPDAYBS — Calculates the number of days from the beginning of the coupon period to the settlement date
COUPDAYS — Calculates the number of days in the coupon period that contains the settlement date
COUPDAYSNC — Calculates the number of days from the settlement date to the next interest payment
COUPNCD — Returns the next coupon payment date after the settlement date
COUPNUM — Calculates the number of remaining coupon payments between the settlement date and maturity
COUPPCD — Returns the previous coupon payment date before the settlement date
COVAR — Covariance — returns the average of the products of deviations (compatibility)
COVARIANCE.P — Calculates the population covariance between two sets of numbers
COVARIANCE.S — Calculates the sample covariance between two sets of numbers
CRITBINOM — Returns the smallest value for which the cumulative binomial distribution is greater than or equal to the criterion α
CSC — Returns the cosecant of an angle (1/sin)
CSCH — Returns the hyperbolic cosecant of a number
CUBEKPIMEMBER — Returns one component of a key performance indicator (KPI) from the data model or cube
CUBEMEMBER — Returns a member or measure from the data model or cube
CUBEMEMBERPROPERTY — Returns the value of a member property from the cube
CUBERANKEDMEMBER — Returns the nth member of a set
CUBESET — Defines a set of members from the data model or cube
CUBESETCOUNT — Returns the number of members in a set
CUBEVALUE — Returns a computed value from the data model or cube
CUMIPMT — Calculates the cumulative interest paid on a loan between two specified payments
CUMPRINC — Calculates the cumulative principal paid on a loan between two specified payments
DATE — Builds a date from a year, a month, and a day
DATEDIF — Calculates the difference between two dates in years, months, or days
DATEVALUE — Converts a date written as text to a real date
DAVERAGE — Calculates the average of the numbers in a column for the rows that match the criteria
DAY — Returns the day of a date
DAYS — Calculates the difference between two dates
DAYS360 — Calculates the number of days between two dates based on a 360-day year
DB — Calculates the depreciation of an asset for a specified period using the fixed-declining balance method
DBCS — Converts half-width (single-byte) characters to full-width (double-byte)
DCOUNT — Counts the numeric cells in a column for the rows that match the criteria
DCOUNTA — Counts the non-empty cells in a column for the rows that match the criteria
DDB — Calculates the depreciation of an asset for a specified period using the double-declining balance method
DEC2BIN — Converts a decimal number to binary
DEC2HEX — Converts a decimal number to hexadecimal
DEC2OCT — Converts a decimal number to octal
DECIMAL — Converts a number written in another base to a regular number
DEGREES — Converts an angle from radians to degrees
DELTA — Tests whether two values are equal — 1 if equal, otherwise 0
DETECTLANGUAGE — Detects the language of a text
DEVSQ — Returns the sum of squares of the deviations of numbers from their average
DGET — Returns the only value in a database that matches the given criteria
DISC — Calculates the annual discount rate of a security
DMAX — Returns the largest number in a column among the rows that match the criteria
DMIN — Returns the smallest number in a column among the rows that match the criteria
DOLLAR — Converts a number to text in dollar currency format with two decimal places and a thousands separator
DOLLARDE — Converts a price written as a fractional number to a decimal number
DOLLARFR — Converts a decimal number to a fraction with a specified denominator
DPRODUCT — Multiplies the numbers in a column of a database that match the criteria
DROP — Removes a specified number of rows or columns from the start or end of a range and returns the rest
DSTDEV — Calculates the sample standard deviation for the rows of a database that match the criteria
DSTDEVP — Calculates the population standard deviation for the rows of a database that match the criteria
DSUM — Sums the numbers in a column for the rows that match the criteria
DURATION — Calculates the Macaulay duration in years of a security that pays periodic interest
DVAR — Calculates the sample variance for the rows of a database that match the criteria
DVARP — Calculates the population variance for the rows of a database that match the criteria
EDATE — Returns a date a specified number of months before or after a date
EFFECT — Calculates the effective annual interest rate from the nominal rate and the number of compounding periods per year
ENCODEURL — Converts text to a form that can be used in a web address
EOMONTH — Returns the date of the last day of the month
ERF — Returns the error function — the integral of the normal distribution
ERF.PRECISE — Returns the error function with high precision (lower limit only)
ERFC — Returns the complementary error function (1-ERF)
ERFC.PRECISE — Returns the complementary error function with high precision
ERROR.TYPE — Returns the error type of a cell as a number
EUROCONVERT — Converts an amount between the currencies of the euro zone (pre-euro) — at the fixed 1998 rates
EVEN — Rounds a number up to the nearest even number
EXACT — Compares two texts, case-sensitively
EXP — Raises e to a given power
EXPAND — Expands an array to specified dimensions
EXPON.DIST — Calculates the exponential distribution probability
EXPONDIST — Returns the exponential distribution (compatibility) — for modeling the time between events
F.DIST — Calculates the F distribution probability from the left
F.DIST.RT — Calculates the right-tail probability of the F distribution
F.INV — Returns the inverse of the left-tail probability of the F distribution
F.INV.RT — Returns the critical value of the F distribution from the right
F.TEST — Checks whether the spread of two data sets differs significantly
FACT — Returns the factorial of a number
FACTDOUBLE — Returns the double factorial of a number (n!!) — such as 7!!=105
FALSE — Returns the logical value FALSE
FDIST — F distribution (compatibility) — the right-tail probability of the F distribution
FILTER — Filters data by one or more conditions and returns only the matching results
FILTERXML — Extracts custom data from an XML text
FIND — Finds the position of a text inside another text (case-sensitive)
FINDB — Returns the position of a text in another text in bytes (DBCS, for double-byte languages) — like FIND but byte-based
FINV — Returns the inverse of the F distribution (compatibility)
FISHER — Applies the Fisher transformation to a number
FISHERINV — Returns the inverse of the Fisher transformation
FIXED — Converts a number to text with a fixed number of decimals and a thousands separator
FLOOR — Rounds a number down to the nearest multiple of a specified significance
FLOOR.MATH — Rounds a number down to the nearest multiple of a specified significance
FLOOR.PRECISE — Rounds a number toward negative infinity to the nearest multiple with high precision
FORECAST — Predicts a future value based on a linear trend (the legacy FORECAST.LINEAR)
FORECAST.ETS — Predicts a future value by considering the trend and seasonal pattern
FORECAST.ETS.CONFINT — Returns the confidence margin of a FORECAST.ETS prediction
FORECAST.ETS.SEASONALITY — Detects the length of the repeating pattern in a time series
FORECAST.ETS.STAT — Returns statistical indicators of the FORECAST.ETS prediction model
FORECAST.LINEAR — Predicts a future value based on the linear trend of past data
FORMULATEXT — Displays the formula written in a cell as text
FREQUENCY — Counts the numbers in each interval
FTEST — Returns the result of the F-test (compatibility) — equality of variances
FV — Calculates the future value of an investment or savings with a fixed interest rate
FVSCHEDULE — Calculates the future value of a principal with different interest rates in each period
GAMMA — Returns the value of the gamma function
GAMMA.DIST — Calculates the probability of the gamma distribution
GAMMA.INV — Returns the inverse of the gamma cumulative distribution
GAMMADIST — Returns the gamma distribution (compatibility)
GAMMAINV — Returns the inverse of the gamma distribution (compatibility)
GAMMALN — Returns the natural logarithm of the gamma function
GAMMALN.PRECISE — Returns the natural logarithm of the gamma function with high precision
GAUSS — Returns the probability of falling between the mean and z standard deviations above it
GCD — Returns the greatest common divisor of several numbers
GEOMEAN — Returns the geometric mean of positive numbers
GESTEP — Checks whether a number is greater than or equal to a threshold — 1 or 0
GETPIVOTDATA — Returns a specific number from inside a PivotTable based on field and item names
GROUPBY — Groups data by one or more columns and returns a sum, count, or another calculation for each group
GROWTH — Predicts future values based on an exponential growth trend
HARMEAN — Returns the harmonic mean of positive numbers
HEX2BIN — Converts a hexadecimal number to binary
HEX2DEC — Converts a hexadecimal number to decimal
HEX2OCT — Converts a hexadecimal number to octal
HLOOKUP — Searches for a value in a row and returns the value found in the same row or rows below
HOUR — Separates and displays the hour from a time
HSTACK — Joins several ranges or arrays side by side (horizontally) and builds a single table
HYPERLINK — Creates a clickable link to a site, file, or another cell
HYPGEOM.DIST — Calculates the probability of the number of successes in sampling without replacement
HYPGEOMDIST — Returns the hypergeometric distribution (compatibility)
IF — Decision structure, checking condition(s) and specifying alternative outcomes
IFERROR — Replaces any kind of error in formulas with a desired value or formula
IFNA — Replaces the #N/A error with another value
IFS — Checks several conditions in order and returns the result of the first true condition
IMABS — Returns the absolute value (modulus) of a complex number
IMAGE — Displays an image inside the cell from its internet address
IMAGINARY — Returns the imaginary coefficient of a complex number
IMARGUMENT — Returns the argument (angle in radians) of a complex number
IMCONJUGATE — Returns the complex conjugate of a number
IMCOS — Returns the cosine of a complex number
IMCOSH — Returns the hyperbolic cosine of a complex number
IMCOT — Returns the cotangent of a complex number
IMCSC — Returns the cosecant of a complex number
IMCSCH — Returns the hyperbolic cosecant of a complex number
IMDIV — Returns the division of two complex numbers
IMEXP — Returns the exponential (e to the power) of a complex number
IMLN — Returns the natural logarithm of a complex number
IMLOG10 — Returns the base-10 logarithm of a complex number
IMLOG2 — Returns the base-2 logarithm of a complex number
IMPOWER — Returns the power of a complex number
IMPRODUCT — Returns the product of several complex numbers
IMREAL — Returns the real part of a complex number
IMSEC — Returns the secant of a complex number
IMSECH — Returns the hyperbolic secant of a complex number
IMSIN — Returns the sine of a complex number
IMSINH — Returns the hyperbolic sine of a complex number
IMSQRT — Returns the square root of a complex number
IMSUB — Returns the subtraction of two complex numbers
IMSUM — Returns the sum of several complex numbers
IMTAN — Returns the tangent of a complex number
INDEX — Returns the value at a specific position in a range
INDIRECT — Converts an address written as text into a real address
INFO — Returns information about the Excel and system environment
INT — Removes the decimal part of a number and rounds it down to the lower integer
INTERCEPT — Returns the y-intercept of the regression line
INTRATE — Calculates the annual interest rate of securities whose full amount is received at maturity
IPMT — Calculates the interest portion of a specific loan payment
IRR — Calculates the internal rate of return of an investment from its cash flows
ISBLANK — Checks whether a cell is empty or not?
ISERR — Whether a formula is an error or not
ISERROR — Checks whether a value is an error or not?
ISEVEN — Checks whether a number is even or not?
ISFORMULA — Checks whether a cell contains a formula or not?
ISLOGICAL — Checks whether a value is logical (TRUE or FALSE) or not?
ISNA — Whether it is the #N/A error or not
ISNONTEXT — Checks that a value is not text
ISNUMBER — Checks whether a value is numeric or not?
ISO.CEILING — Rounds a number up to the nearest multiple with the ISO standard — negatives toward negative infinity
ISODD — Checks whether a number is odd or not?
ISOMITTED — Checks whether a LAMBDA input was left empty or not
ISOWEEKNUM — Returns the week number of the year based on the ISO standard
ISPMT — Calculates the interest of a period for a loan whose principal is repaid equally
ISREF — Checks whether a value is a valid reference to a cell or range or not
ISTEXT — Checks whether an input value is text or not?
JIS — Converts half-width text to full-width (JIS/two-byte)
KURT — Returns the kurtosis of a data distribution
LAMBDA — With it you can build a custom function without programming and use it like Excel's own functions
LARGE — Finds the k-th largest number in a range
LCM — Returns the least common multiple of several numbers
LEFT — Separates a part from the beginning of a text
LEFTB — Returns a specified number of characters from the beginning of a text in bytes
LEN — Determines the number of characters of an input value
LENB — Returns the length of a text in bytes — each double-byte character counts as 2
LET — Assigns names to intermediate values or calculations inside a formula to make the formula more readable and to evaluate repeated calculations only once
LINEST — Returns the coefficients of the linear regression line and its statistics
LN — Returns the natural logarithm of a number
LOG — Returns the logarithm of a number to a specified base
LOG10 — Returns the base-10 logarithm of a number
LOGEST — Returns the coefficients of an exponential curve fitted to the data
LOGINV — Returns the inverse of the lognormal distribution (compatibility)
LOGNORM.DIST — Calculates the lognormal distribution probability
LOGNORM.INV — Returns the inverse of the lognormal cumulative distribution
LOGNORMDIST — Returns the lognormal distribution (compatibility)
LOOKUP — Looks up a value in a sorted row or column and returns the corresponding value from another row or column
LOWER — Converts text to lowercase
MAKEARRAY — Creates an array with specified dimensions and fills each cell with a calculation
MAP — Applies a calculation to each cell of an array
MATCH — Finds the position of a value within a range
MAX — Returns the largest number among the input numbers or ranges
MAXA — Returns the largest value including text and logical values
MAXIFS — Returns the maximum value that meets criteria (conditional maximum)
MDETERM — Returns the determinant of a matrix
MDURATION — Calculates the modified duration of a security
MEDIAN — Returns the median (the middle value) of a set of numbers
MID — Extracts a specified number of characters from a text starting at a specified position
MIDB — Returns a portion of text starting at a specified position based on bytes
MIN — Returns the smallest number among the input numbers or ranges
MINA — Returns the smallest value including text and logical values
MINIFS — Returns the minimum value that meets criteria (conditional minimum)
MINUTE — Extracts and returns the minute from a time value
MINVERSE — Returns the inverse matrix — array result
MIRR — Calculates the modified internal rate of return, considering the finance rate and reinvestment rate
MMULT — Returns the matrix product of two arrays
MOD — Returns the remainder after dividing a number by a divisor
MODE — Returns the most frequently occurring number in a set of numbers
MODE.MULT — Returns all numbers that occur most frequently
MODE.SNGL — Returns the most frequently occurring number in a set
MONTH — Returns the month number of a date
MROUND — Rounds a number to the nearest multiple of a specified value
MULTINOMIAL — Returns the ratio of the factorial of the sum to the product of factorials
MUNIT — Creates an identity (unit) matrix of a specified size
N — Converts a value to a number; text becomes zero and TRUE becomes 1
NA — Deliberately places the #N/A error in a cell to indicate that the value is not available
NEGBINOM.DIST — Calculates the probability of a specified number of failures before a specified number of successes
NEGBINOMDIST — Returns the negative binomial distribution (compatibility)
NETWORKDAYS — Calculates the number of workdays between two dates
NETWORKDAYS.INTL — Counts the number of workdays between two dates with a custom weekend
NOMINAL — Calculates the nominal annual interest rate from the effective rate and the number of compounding periods per year
NORM.DIST — Calculates the normal distribution probability with a specified mean and standard deviation
NORM.INV — Returns the value corresponding to a probability in the normal distribution
NORM.S.DIST — Calculates the standard normal distribution probability
NORM.S.INV — Returns the z value corresponding to a probability in the standard normal distribution
NORMDIST — Normal distribution (compatibility) — cumulative or probability density
NORMINV — Returns the inverse of the normal distribution (compatibility)
NORMSDIST — Returns the standard normal distribution (compatibility)
NORMSINV — Returns the inverse of the standard normal distribution (compatibility)
NOT — Returns the logical negation (NOT)
NOW — Returns the current date and time of the system
NPER — Calculates the number of periods required to pay off a loan or reach a target amount
NPV — Calculates the net present value of an investment from future cash flows and a discount rate
NUMBERVALUE — Converts text to a number using locale-specific decimal and group separators
OCT2DEC — Converts an octal number to decimal
OCT2HEX — Converts an octal number to hexadecimal
ODD — Rounds a number up to the nearest odd number
ODDFPRICE — Calculates the price of a security whose first interest period is shorter or longer than the others
ODDFYIELD — Calculates the yield of a security whose first interest period is shorter or longer than the others
ODDLPRICE — Calculates the price of a security whose last interest period is shorter or longer than the others
ODDLYIELD — Calculates the yield of a security whose last interest period is shorter or longer than the others
OFFSET — Starts from a cell, moves by a specified number of rows and columns, and returns the new cell or range
OR — Checks whether at least one of several conditions is true
PDURATION — Calculates the number of periods required for an investment to reach a target value
PEARSON — Returns the Pearson correlation coefficient between two sets of numbers
PERCENTILE — Returns the percentile of the data (legacy PERCENTILE.INC)
PERCENTILE.EXC — Returns the percentile of the data excluding 0 and 100 percent
PERCENTILE.INC — Returns the value below which a specified percentage of the data falls
PERCENTOF — Calculates the share of a subset relative to the total
PERCENTRANK — Returns the percent rank of a value in a data set (compatibility) — between 0 and 1
PERCENTRANK.EXC — Returns the percent rank of a number excluding 0 and 100 percent
PERCENTRANK.INC — Returns how many percent of the data a number is above (percent rank)
PERMUT — Returns the number of ordered selections without repetition
PERMUTATIONA — Returns the number of ordered selections with repetition
PHI — Returns the height of the standard normal curve at a point (density)
PHONETIC — Extracts the phonetic (Furigana) characters from Japanese text
PI — Returns the number pi with 15-digit precision
PIVOTBY — Groups data simultaneously by row and column and creates a two-dimensional report similar to a PivotTable
PMT — Calculates the payment for a loan with a fixed interest rate and equal installments
POISSON — Returns the Poisson distribution (compatibility)
POISSON.DIST — Calculates the probability of a specified number of events occurring in an interval
POWER — Raises a number to a power
PPMT — Calculates the principal portion of a specific loan payment
PRICE — Calculates the price per 100 par value of a security that pays periodic interest
PRICEDISC — Calculates the price per 100 par value of a discounted security
PRICEMAT — Calculates the price of a security that pays interest only at maturity
PROB — Calculates the probability that values fall within an interval using a probability table
PRODUCT — Multiplies numbers together
PROPER — Capitalizes the first letter of each word
PV — Calculates the present value of money to be received or paid in the future
QUARTILE — Returns the quartiles of a set of numbers (legacy QUARTILE.INC)
QUARTILE.EXC — Returns the quartile of the data excluding the minimum and maximum
QUARTILE.INC — Returns the quartiles of a set of numbers
QUOTIENT — Returns the integer portion of a division
RADIANS — Converts an angle from degrees to radians
RAND — Returns a random number between 0 and 1
RANDARRAY — Creates an array of random numbers with specified rows and columns
RANDBETWEEN — Returns a random number between two specified numbers
RANK — Returns the rank of a number within a list of numbers
RANK.AVG — Returns the rank of a number, assigning the average rank to tied values
RANK.EQ — Returns the rank of a number within a list of numbers
RATE — Calculates the interest rate per period for a loan or investment
RECEIVED — Calculates the amount received at maturity for a fully invested security
REDUCE — Reduces all cells of an array to a single result with an accumulative calculation
REGEXEXTRACT — Extracts the part of a text that matches a pattern
REGEXREPLACE — Replaces parts of a text that match a pattern
REGEXTEST — Checks whether a text matches a pattern
REGISTER.ID — Returns the register ID of a DLL or registered code resource
REPLACE — Replaces part of a text based on position and character count with other text
REPLACEB — Replaces part of text by bytes (DBCS)
REPT — Repeats a text a specified number of times
RIGHT — Extracts a specified number of characters from the end of a text
RIGHTB — Returns a specified number of characters from the end of text based on bytes
ROMAN — Converts a number to Roman numerals
ROUND — Rounds a number to a specified number of digits
ROUNDDOWN — Always rounds a number down
ROUNDUP — Always rounds a number up
ROW — Returns the row number of a reference or the row number of the cell where it is called
ROWS — Returns the number of rows in a range
RRI — Calculates the compound growth rate per period from the present value, future value, and number of periods
RSQ — Returns the coefficient of determination of the regression line
RTD — Retrieves real-time data from a COM Automation server
SCAN — Runs a cumulative calculation over an array and returns the result of each step
SEARCH — Finds the position of one text string within another
SEC — Returns the secant of an angle (1/cos)
SECH — Returns the hyperbolic secant of a number
SECOND — Extracts and returns the second from a time value
SEQUENCE — Generates a sequence of sequential numbers
SERIESSUM — Returns the sum of a power series based on coefficients
SHEET — Returns the sheet number according to its position in the workbook
SHEETS — Returns the number of sheets in the workbook or the number of sheets in a reference
SIGN — Returns the sign of a number
SIN — Returns the sine of an angle
SINH — Returns the hyperbolic sine of a number
SKEW — Returns the skewness of a distribution
SKEW.P — Returns the skewness of a distribution for the entire population
SLN — Calculates the depreciation of an asset for each period using the straight-line method
SLOPE — Returns the slope of the regression line
SMALL — Returns the k-th smallest number in a range
SORT — Sorts the input data
SORTBY — Sorts a range based on the values in another range or column
SQRT — Returns the square root of a number
SQRTPI — Returns the square root of (number × π)
STANDARDIZE — Converts a value to a standardized score (z-score)
STDEV — Calculates the standard deviation based on a sample (legacy version of STDEV.S)
STDEV.P — Calculates the standard deviation for the entire population
STDEV.S — Calculates the standard deviation based on a sample
STDEVA — Calculates sample standard deviation including text and logical values
STDEVP — Returns the population standard deviation (compatibility) — includes the entire population
STDEVPA — Calculates population standard deviation including text and logical values
STEYX — Returns the standard error of the predicted y value for each x in the regression
STOCKHISTORY — Returns the price, volume, and stock information history from the stock market (Excel 365)
SUBSTITUTE — Replaces part of a text string
SUBTOTAL — Calculates with awareness of filtered or hidden rows
SUM — Mathematical sum
SUMIF — Sums with one condition
SUMIFS — Sums with one or more conditions
SUMPRODUCT — Sums the products
SUMSQ — Returns the sum of the squares of numbers
SUMX2MY2 — Returns the sum of the difference of squares of corresponding numbers in two ranges
SUMX2PY2 — Returns the sum of squares of corresponding numbers in two arrays (Σx²+Σy²)
SUMXMY2 — Returns the sum of squares of differences of two arrays (Σ(x-y)²)
SWITCH — Compares a value against several cases and returns the result of the first matching case
SYD — Calculates the depreciation of an asset for a specified period using the sum-of-the-years' digits method
T — Returns the text if the input is text, otherwise returns empty text
T.DIST — Calculates the left-tail t-distribution probability
T.DIST.2T — Calculates the two-tailed t-distribution probability
T.DIST.RT — Calculates the right-tail t-distribution probability
T.INV — Returns the inverse of the left-tail t-distribution probability
T.INV.2T — Returns the two-tailed critical value of the t-distribution
T.TEST — Tests whether the means of two groups differ significantly
TAKE — Returns a specified number of rows or columns from the start or end of a range
TAN — Returns the tangent of an angle
TANH — Returns the hyperbolic tangent of a number
TBILLEQ — Calculates the bond-equivalent yield for Treasury bills
TBILLPRICE — Calculates the price of Treasury bills per $100 face value
TBILLYIELD — Calculates the yield of Treasury bills from their price
TDIST — Returns the Student t-distribution (compatibility)
TEXT — Converts a number or date to text with a custom format
TEXTAFTER — Returns the part of a text that comes after a specified delimiter
TEXTBEFORE — Returns the part of a text that comes before a specified delimiter
TEXTJOIN — Joins and concatenates texts together
TEXTSPLIT — Splits a text by delimiters into multiple parts and puts each part in a separate cell
TIME — Creates a time from hours, minutes, and seconds
TIMEVALUE — Converts a time written as text to a real time value
TINV — Returns the inverse of the two-tailed t-distribution (compatibility)
TOCOL — Stacks all values of a multi-row and multi-column range into one column
TODAY — Returns the current system date
TOROW — Arranges all values of a multi-row and multi-column range into one row
TRANSLATE — Translates text from one language to another
TRANSPOSE — Swaps the rows and columns of a range
TREND — Calculates values along the trend line of existing data
TRIM — Removes all extra spaces from text except single spaces between words
TRIMMEAN — Calculates the mean after excluding a percentage of the largest and smallest numbers
TRIMRANGE — Trims empty rows and columns from the start and end of a range
TRUE — Returns the logical value TRUE
TRUNC — Truncates decimals to a specified number of digits
TTEST — Student's t-test (compatibility) — probability associated with the t-test
TYPE — Returns the type of a value as a number
UNICHAR — Returns the character or symbol whose Unicode code is given
UNICODE — Returns the Unicode code of a text character
UNIQUE — Returns the distinct values of a range without duplicates
UPPER — Converts text to uppercase
VALUE — Converts text to a number
VALUETOTEXT — Converts any value to text
VAR — Calculates variance based on a sample (legacy version of VAR.S)
VAR.P — Calculates variance for the entire population
VAR.S — Calculates variance based on a sample
VARA — Calculates sample variance including text and logical values
VARP — Returns population variance (compatibility)
VARPA — Calculates population variance including text and logical values
VDB — Calculates depreciation of an asset for a range of periods using the declining balance method
VLOOKUP — Looks up a value in the first column of a range and returns information from another column
VSTACK — Stacks multiple ranges or arrays vertically and creates a single table
WEBSERVICE — Reads information from a web address and returns it as text in the cell
WEEKDAY — Returns the day of the week number for a date
WEEKNUM — Returns the week number of a date in the year
WEIBULL — Returns the Weibull distribution (compatibility)
WEIBULL.DIST — Calculates the Weibull distribution probability
WORKDAY — Returns the date that is a specified number of workdays before or after a date
WORKDAY.INTL — Returns the date that is a specified number of workdays before or after, with a custom weekend
WRAPCOLS — Splits a single-row or single-column list into multiple columns with a specified number of cells
WRAPROWS — Splits a single-row or single-column list into multiple rows with a specified number of cells
XIRR — Calculates the annualized internal rate of return for cash flows with irregular dates
XLOOKUP — Searches a range and returns the corresponding value in the result range (row-wise or column-wise)
XMATCH — Finds the position (relative row or column number) of a value in a range or array; the modern, more complete version of MATCH
XNPV — Calculates the net present value for cash flows with irregular dates
XOR — Checks whether exactly one of two conditions is true
YEAR — Returns the year of a date
YEARFRAC — Calculates the interval between two dates as a year and fraction of a year
YIELD — Calculates the annual yield of a security that pays periodic interest
YIELDDISC — Calculates the annual yield of a discounted security
YIELDMAT — Calculates the annual yield of a security that pays its interest in a lump sum at maturity
Z.TEST — Returns the one-tailed probability of the z-test
ZTEST — Z-test (compatibility) — one-tailed p-value of the Z-test for the mean
▶ Run
Clear
Share ↗
Fill sample
Presets:
fx
A1
↵ Enter = محاسبه · کلیک روی سلول = ویرایش فرمول
💡 مثل اکسل: روی سلولی کلیک کن، = بزن و بعد بدون Enter روی هر سلول دیگری کلیک یا درگ کن — آدرسش داخل فرمول درج میشود. لبهی هدر هر ستون را بکش تا اندازهاش عوض شود، دبلکلیک = اندازه خودکار به محتوا.
Active cell
A1
Copy table
CSV
TSV
▦ Supported functionsSUM, AVERAGE, MIN, MAX, COUNT, COUNTA, SUMIF, COUNTIF, AVERAGEIF, IF, AND, OR, NOT, CONCAT, TEXTJOIN, LEFT, RIGHT, MID, LEN, UPPER, LOWER, TRIM, ROUND, ROUNDDOWN, ROUNDUP, ABS, TODAY, NOW — و همه عملگرها: + - * / ^ % & = < > <= >= <> و ارجاع A1 و بازه A1:B5