Add and summarize numbers
Total ranges, build subtotals, and summarize values that meet conditions.
Excel functions
Find the Excel function you need, see how it works, and try important formulas in a live spreadsheet.
Start with a task
Know the problem, not the function name? Start here.
Look up values
Find matching rows, return related values, and modernize older lookup formulas.
Make decisions
Return different results based on tests, errors, and multiple conditions.
Count things
Count numbers, filled cells, matching rows, and multi-condition records.
Clean and combine text
Pull text apart, remove extra spaces, and combine labels or names.
Work with dates
Create dates, calculate deadlines, and work with business days.
Essential Excel functions
The functions people reach for most. Many come with a live example or short exercises, so you can try the formula instead of only reading about it.
VLOOKUP
Look up a value in the first column of a table.
=VLOOKUP(lookup_value, table_array, col_index_num, range_lookup) 11 exercises to practice
DATEDIF
Count the days, months, or years between two dates.
=DATEDIF(start_date, end_date, unit) 2 exercises to practice
IF
Return one result when a test passes, another when it fails.
=IF(Logical_test, Value_if_true, Value_if_false) 20 exercises to practice
SUM
Add up numbers across cells and ranges.
=SUM(number1, number2, ...) 11 exercises to practice
XLOOKUP
Find values in any direction, without VLOOKUP's limits.
=XLOOKUP(lookup_value, lookup_array, return_array, [if_not_found], [match_mode], [search_mode]) 9 exercises to practice
AND
Check that several conditions are all true.
=AND(logical1, logical2, ...) 4 exercises to practice
AVERAGE
Get the mean of a range of numbers.
=AVERAGE(number1, number2, ...) 6 exercises to practice
IFS
Test several conditions without nesting IFs.
=IFS(logical_test1, value_if_true1, [logical_test2, value_if_true2, ...], [default_value]) 1 exercise to practice
COUNTIF
Count cells that match one condition.
=COUNTIF(range, criteria) 7 exercises to practice
ROUND
Round a number to a set number of digits.
=ROUND(number, num_digits) 1 exercise to practice
IFERROR
Catch formula errors and return a cleaner result.
=IFERROR(value, value_if_error) 4 exercises to practice
SUMIF
Add the values that meet one condition.
=SUMIF(range, criteria, [sum_range]) 3 exercises to practice
All Excel functions
Browse by category, or use search to filter the full reference instantly.
Compatibility functions
38 function s
Function Purpose Syntax
BETADIST
The BETADIST function is used to calculate the beta cumulative distribution function (CDF) at a specified value in a...
=BETADIST(X, Alpha, Beta, [A], [B]) BETAINV
The BETAINV function is used to determine the inverse of the cumulative beta probability density function. This function...
=BETAINV(probability, alpha, beta) BINOMDIST
The BINOMDIST function calculates the probability of a certain number of successes in a fixed number of trials, where...
=BINOMDIST(number_s, trials, probability_s, cumulative) CHIDIST
The CHIDIST function calculates the one-tailed probability of the chi-squared distribution (χ2) given a value and the...
=CHIDIST(X, Deg_freedom) CHIINV
The CHIINV function is used to calculate the inverse of the one-tailed probability of the chi-squared distribution. This...
=CHIINV(probability, degrees_freedom) CHITEST
The CHITEST function is used to perform the chi-squared test of independence in Excel. This statistical function is...
=CHITEST(actual_range, expected_range) CONFIDENCE
The CONFIDENCE function is used to calculate the confidence interval for a population mean, based on a sample.
=CONFIDENCE(alpha, standard_dev, size) COVAR
The COVAR function calculates the covariance between two sets of values. It is commonly used in statistics and financial...
=COVAR(array1, array2) CRITBINOM
The CRITBINOM function calculates the smallest value for which the cumulative binomial distribution is less than or...
=CRITBINOM(Trials, Probability_s, Alpha) EXPONDIST
The EXPONDIST function calculates the exponential distribution for a given value of x, with a specified parameter lambda...
=EXPONDIST(x, lambda, cumulative) FDIST
The FDIST function in Excel is used to calculate the two-tailed F probability density function. It is commonly employed...
=FDIST(x, deg_freedom1, deg_freedom2) FINV
The FINV function calculates the left-tailed F probability distribution. It returns the probability that the observed F...
=FINV(probability, deg_freedom1, deg_freedom2) FTEST
The FTEST function is used to return the result of an F-test, which is a statistical test that compares the variances of...
=FTEST(array1, array2) GAMMADIST
The GAMMADIST function is used to calculate the gamma distribution probability for a given value. It is commonly applied...
=GAMMADIST(X, Alpha, Beta, Cumulative) GAMMAINV
The GAMMAINV function calculates the inverse of the gamma cumulative distribution function for a specified probability...
=GAMMAINV(Probability, Alpha, Beta) HYPGEOMDIST
The HYPGEOMDIST function calculates the probability of a specified number of successes in a sample drawn from a finite...
=HYPGEOMDIST(Number_s, Population_s, Number_s, Population_successes) LOGINV
The LOGINV function calculates the inverse of the log-normal cumulative distribution function for a specified...
=LOGINV(Probability, Mean, Standard_dev) LOGNORMDIST
The LOGNORMDIST function calculates the probability density function of a log-normal distribution for a given value. It...
=LOGNORMDIST(x, mean, standard_dev) MODE
The MODE function is used to find the most frequently occurring number in a range of values. It is handy when you want...
=MODE(number1, [number2], ...) NEGBINOMDIST
The NEGBINOMDIST function calculates the probability of a specified number of failures before achieving a target number...
=NEGBINOMDIST(Number_f, Number_s, Probability_s) NORMDIST
The NORMDIST function calculates the cumulative probability of a normal distribution at a specific value or the...
=NORMDIST(x, mean, standard_dev, cumulative) NORMINV
The NORMINV function calculates the inverse of the normal cumulative distribution for a specified probability. It is...
=NORMINV(Probability, Mean, Standard deviation) NORMSDIST
The NORMSDIST function calculates the standard normal cumulative distribution function for a specified value in Excel....
=NORMSDIST(Z) NORMSINV
The NORMSINV function returns the inverse of the standard normal cumulative distribution. In simpler terms, it...
=NORMSINV(Probability) PERCENTILE
The PERCENTILE function calculates the k-th percentile of a set of values. It is commonly used in data analysis and...
=PERCENTILE(array, k) PERCENTRANK
The PERCENTRANK function calculates the relative position of a specified value in a data set as a percentage, indicating...
=PERCENTRANK(array, x, [significance]) POISSON
The POISSON function calculates the Poisson distribution, which is a probability distribution that shows how many times...
=POISSON(X, Mean, Cumulative) QUARTILE
The QUARTILE function in Excel is utilized to determine the specific quartile (i.e., the 25th percentile, 50th...
=QUARTILE(array, quart) RANK
The RANK function in Excel is used to determine the rank of a specified value in a list of values. It is particularly...
=RANK(Number, Ref, [Order]) STDEV
The STDEV function calculates the standard deviation of a sample set of data. It is commonly used to measure the amount...
=STDEV(number1, [number2,...]) STDEVP
The STDEVP function calculates the standard deviation based on the entire population given as arguments. It is used to...
=STDEVP(number1, [number2], ...) TDIST
The TDIST function calculates the two-tailed probability of the t-distribution for a given value and degrees of freedom....
=TDIST(x, degrees_freedom, tails) TINV
The TINV function calculates the inverse of the Student's T-Distribution. It is commonly used in statistical analysis to...
=TINV(probability, degrees_freedom) TTEST
The TTEST function is used to calculate the probability associated with the t-test for independent samples. This...
=TTEST(array1, array2, Tail, Type) VAR
The VAR function in Excel is used to calculate the variance based on a sample of data. Variance measures the variability...
=VAR(number1, number2, ...) VARP
The VARP function calculates the variance of a population based on the entire dataset. It is commonly used in statistics...
=VARP(number1, number2, ...) WEIBULL
The WEIBULL function calculates the Weibull distribution, which is often used in reliability engineering to model...
=WEIBULL(X, Alpha, Beta, Cumulative) ZTEST
The ZTEST function is used to calculate the one-tailed probability of a sample mean being equal to the specified...
=ZTEST(data_array, mean, [sigma]) Database functions
12 function s
Function Purpose Syntax
DAVERAGE
The DAVERAGE function is used to calculate the average of values in a database that meet specific criteria. This...
=DAVERAGE(Database, Field, Criteria) DCOUNT
The DCOUNT function is used to count the number of cells in a database that meet specific criteria. It is particularly...
=DCOUNT(Database, Field, Criteria) DCOUNTA
The DCOUNTA function is used to count non-blank cells in a database or a list based on specified criteria. It is handy...
=DCOUNTA(database, field, criteria) DGET
The DGET function is used to extract a single value from a database based on a specific criteria. It is handy when you...
=DGET(Database, Field, Criteria) DMAX
The DMAX function is used to find the maximum value in a database or list that meets specified criteria. It is handy for...
=DMAX(database, field, criteria) DMIN
The DMIN function is used to return the smallest value in a database, based on specified criteria. It is handy for...
=DMIN(Database, Field, Criteria) DPRODUCT
The DPRODUCT function is used to multiply values in a database that match specific criteria. It is handy for extracting...
=DPRODUCT(database, field, criteria) DSTDEV
The DSTDEV function in Excel is used to calculate the standard deviation of a population based on a sample. It is...
=DSTDEV(database, field, criteria) DSTDEVP
The DSTDEVP function calculates the standard deviation of an entire population, provided the data set is from a sample...
=DSTDEVP(database, field, criteria) DSUM
DSUM is a powerful Excel function used for calculating the sum of a range of cells in a database that meets specific...
=DSUM(database, field, criteria) DVAR
The DVAR function calculates the variance of a population based on a sample, using a specific field and criteria.
=DVAR(database, field, criteria) DVARP
The DVARP function is used to calculate the population variance of a database using a specified field column and...
=DVARP(database, field, criteria) Date and time functions
25 function s
Function Purpose Syntax
DATE
The DATE function in Excel is used to create a date by specifying the year, month, and day. It is helpful when you need...
=DATE(year, month, day) DATEDIF
Calculate the difference between two dates as complete years, months, or days using DATEDIF.
=DATEDIF(start_date, end_date, unit) DATEVALUE
The DATEVALUE function in Excel is used to convert a date that is stored as text to a serial number representing the...
=DATEVALUE(Date_text) DAY
The DAY function is used to extract the day value from a date in Excel. It returns the day of the month (a number from 1...
=DAY(date) DAYS
The DAYS function calculates the number of days between two dates in Excel. It is a simple yet essential function for...
=DAYS(End_date, Start_date) DAYS360
The DAYS360 function calculates the number of days between two dates based on a 360-day year with twelve 30-day months....
=DAYS360(Start_date, End_date, [Method]) EDATE
The EDATE function adds or subtracts a specified number of months to a given date, returning the resulting date. This...
=EDATE(start_date, months) EOMONTH
The EOMONTH function is used to calculate the end date of a month a specified number of months before or after a given...
=EOMONTH(start_date, months) HOUR
The HOUR function returns the hour component of a given time as a whole number between 0 and 23.
=HOUR(serial_number) ISOWEEKNUM
The ISOWEEKNUM function returns the ISO week number of a specific date.
=ISOWEEKNUM(date) MINUTE
The MINUTE function returns the minute component of a specified time.
=MINUTE(time) MONTH
The MONTH function in Excel returns the month of a given date as an integer from 1 (January) to 12 (December). This...
=MONTH(date) NETWORKDAYS
The NETWORKDAYS function is used to calculate the number of working days between two specified dates, excluding weekends...
=NETWORKDAYS(Start_Date, End_Date, [Holidays]) NETWORKDAYS.INTL
The NETWORKDAYS.INTL function calculates the number of workdays between two dates, considering specified weekend days...
=NETWORKDAYS.INTL(start_date, end_date, [weekend], [holidays]) NOW
The NOW function returns the current date and time as a serial number.
=NOW() SECOND
The SECOND function in Excel is used to extract the second component (seconds) of a given time value. It is particularly...
=SECOND(time) TIME
The TIME function is used to create a valid Excel time from individual hour, minute, and second components. This...
=TIME(hour, minute, second) TIMEVALUE
The TIMEVALUE function in Excel converts a text string that represents a time into a decimal number, which Excel...
=TIMEVALUE(time_text) TODAY
Returns today's date as a date value, updating automatically whenever the workbook recalculates.
=TODAY() WEEKDAY
The WEEKDAY function in Excel returns a number that corresponds to the day of the week for a given date. This function...
=WEEKDAY(serial_number, [return_type]) WEEKNUM
The WEEKNUM function is used to determine the week number within a year for a given date. This function is handy for...
=WEEKNUM(Date, [Return Type]) WORKDAY
The WORKDAY function returns a date that is a specified number of working days (weekdays) before or after a given date....
=WORKDAY(start_date, days, [holidays]) WORKDAY.INTL
The WORKDAY.INTL function in Excel is used to calculate the next working day after a specified number of workdays have...
=WORKDAY.INTL(start_date, days, [weekend], [holidays]) YEAR
The YEAR function in Excel is used to extract the year from a given date.
=YEAR(date) YEARFRAC
Calculate the fraction of a year between two dates using Excel's YEARFRAC function.
=YEARFRAC(Start_date, End_date, [Basis]) Engineering functions
54 function s
Function Purpose Syntax
BESSELI
The BESSELI function in Excel calculates the modified Bessel function I(n, x) which is often used in statistical...
=BESSELI(Order, X) BESSELJ
The BESSELJ function calculates the Bessel function Jn(x), which is used in various mathematical, engineering, and...
=BESSELJ(n, x) BESSELK
The BESSELK function in Excel is used to calculate the modified Bessel function of the second kind, which is a...
=BESSELK(n, x, [order]) BESSELY
The BESSELY function returns the Y Bessel function of the second kind for a given complex number.
=BESSELY(X, N) BIN2DEC
The BIN2DEC function is used to convert a binary number to its decimal equivalent. This function is extremely useful for...
=BIN2DEC(number) BIN2HEX
The BIN2HEX function converts a binary number to its hexadecimal equivalent. This function is useful when working with...
=BIN2HEX(number, [places]) BIN2OCT
The BIN2OCT function converts a binary number to an octal number in Excel. It is useful when working with binary numbers...
=BIN2OCT(number, [num_digits]) BITAND
The BITAND function is used to perform a bitwise AND operation on two numbers, bit by bit.
=BITAND(number1, number2) BITLSHIFT
The BITLSHIFT function is used to shift the bits of a specified number to the left (toward the most significant bit) by...
=BITLSHIFT(number, shift_amount) BITOR
The BITOR function is used to perform a bitwise OR operation between two numbers in Excel. This function is commonly...
=BITOR(number1, number2) BITRSHIFT
The BITRSHIFT function is used to perform a bitwise right shift operation on a specified number, shifting its binary...
=BITRSHIFT(number, shift_amount) BITXOR
The BITXOR function performs a bitwise XOR (exclusive OR) operation on two numbers or sets of binary digits. This...
=BITXOR(number1, number2) COMPLEX
The COMPLEX function is used to convert real and imaginary coefficients into a complex number in the standard a + bi or...
=COMPLEX(real_num, i_num, [suffix]) CONVERT
The CONVERT function is used to convert a measurement from one unit to another within the same measurement system. It is...
=CONVERT(number, from_unit, to_unit) DEC2BIN
The DEC2BIN function converts a decimal number into a binary number. It is useful for converting decimal numbers to...
=DEC2BIN(Number, [Places]) DEC2HEX
The DEC2HEX function converts a decimal number to its hexadecimal equivalent.
=DEC2HEX(number, [places]) DEC2OCT
The DEC2OCT function converts a decimal number to octal representation in Excel.
=DEC2OCT(number, [places]) DELTA
The DELTA function is used to test whether two values are equal. It returns 1 if the values are equal, and 0 if they are...
=DELTA(number1, number2) ERF
The ERF function calculates the error function, a mathematical function that describes the probability of an event...
=ERF(value) ERF.PRECISE
ERF.PRECISE is an Excel function that returns the error function integrated between the limits of 0 and x. It is part of...
=ERF.PRECISE(x) ERFC
The ERFC function is used to calculate the complementary error function of a given value. It is commonly used in...
=ERFC(X) ERFC.PRECISE
The ERFC.PRECISE function calculates the complementary error function of a number, which represents the integral of the...
=ERFR.PRECISE(X) GESTEP
The GESTEP function is used to check if a number is greater than or equal to a threshold value. It returns 1 if the...
=GESTEP(number, step) HEX2BIN
The HEX2BIN function converts a hexadecimal number to a binary number. It's handy when working with different number...
=HEX2BIN(Number, [Places]) HEX2DEC
The HEX2DEC function is used to convert a hexadecimal number to a decimal number in Excel. This function is handy when...
=HEX2DEC(number) HEX2OCT
The HEX2OCT function in Excel is used to convert a hexadecimal number to its octal equivalent. This function comes in...
=HEX2OCT(number, [places]) IMABS
The IMABS function is used to return the absolute value (magnitude) of a complex number in the form of x + yi.
=IMABS(Inumber) IMAGINARY
The IMAGINARY function in Excel is used to return the imaginary coefficient of a complex number. It helps in extracting...
=IMAGINARY(complex_number) IMARGUMENT
The IMARGUMENT function is used in Excel to extract a specific argument from a complex number in its rectangular form....
=IMARGUMENT(Inumber, Arg_num) IMCONJUGATE
The IMCONJUGATE function is used to return the complex conjugate of a given complex number. It is commonly used in...
=IMCONJUGATE(complex_number) IMCOS
The IMCOS function in Excel returns the cosine of a complex number in the form of x + yi. This function is particularly...
=IMCOS(complex_number) IMCOSH
The IMCOSH function returns the hyperbolic cosecant of a complex number in Excel. It is used to calculate the inverse...
=IMCOSH(complex_number) IMCOT
The IMCOT function is used in Excel to return the cotangent of a complex number in the form of x + y*i.
=IMCOT(complex_number) IMCSC
The IMCSC function is used to return the imaginary coefficient of a complex number in its sign-convention form (i * Im +...
=IMCSC(Inumber) IMCSCH
IMCSCH function returns the hyperbolic cosecant of a complex number in Excel.
=IMCSCH(complex_number) IMDIV
The IMDIV function in Excel is used to divide complex numbers. It takes two complex numbers as arguments and returns the...
=IMDIV(Complex_num1, Complex_num2) IMEXP
The IMEXP function in Excel is used to calculate the exponential of a complex number.
=IMEXP(ComplexNumber) IMLN
The IMLN function calculates the natural logarithm of the absolute value of a complex number. It is useful in...
=IMLN(ComplexNumber) IMLOG10
The IMLOG10 function is used to calculate the base-10 logarithm of a complex number in Excel. It is particularly useful...
=IMLOG10(Complex number) IMLOG2
The IMLOG2 function calculates the base-2 logarithm of a complex number in Excel. This function is primarily used in...
=IMLOG2(ComplexNumber) IMPOWER
The IMPOWER function in Excel is used to raise a number to the power of another number, allowing for exponential...
=IMPOWER(number, power) IMPRODUCT
The IMPRODUCT function is used to calculate the product of complex numbers in Excel. It multiplies multiple complex...
=IMPRODUCT(complex_num1, complex_num2, ...) IMREAL
The IMREAL function in Excel returns the real component of a complex number. It is useful for working with complex...
=IMREAL(Inumber) IMSEC
The IMSEC function is used to format a value as an immutable security identifier according to the ISIN standard.
=IMSEC(Value) IMSECH
The IMSECH function is used to calculate the hyperbolic secant of a complex number in Excel. This function is handy for...
=IMSECH(complex_number) IMSIN
The IMSIN function returns the sine of a complex number in the form x + yi. It is useful in trigonometry and...
=IMSIN(complex_number) IMSINH
The IMSINH function returns the hyperbolic sine of a complex number in the form x + yi in Excel. It is useful for...
=IMSINH(complex_number) IMSQRT
The IMSQRT function returns the square root of a complex number. Complex numbers are used in many scientific and...
=IMSQRT(inumber) IMSUB
The IMSUB function is used in Excel to subtract complex numbers. It is especially handy when dealing with calculations...
=IMSUB(complex_number1, complex_number2) IMSUM
The IMSUM function is used to return the sum of complex numbers in the form of a + bi or a + bj.
=IMSUM(number1, number2, ...) IMTAN
The IMTAN function returns the inverse tangent of a complex number in the form x + yi. This function is useful when...
=IMTAN(inumber) OCT2BIN
The OCT2BIN function converts a number in octal (base 8) format to binary (base 2) format in Excel. It is particularly...
=OCT2BIN(number, [places]) OCT2DEC
The OCT2DEC function converts an octal number to a decimal number in Excel. This function is helpful when working with...
=OCT2DEC(number) OCT2HEX
The OCT2HEX function converts a number from octal (base 8) to hexadecimal (base 16) representation in Excel.
=OCT2HEX(number, places) Financial functions
55 function s
Function Purpose Syntax
ACCRINT
The ACCRINT function is used to calculate the accrued interest for a security that pays periodic interest. This function...
=ACCRINT(Issue, Settlement, Rate, Par, [Basis], [Calc method]) ACCRINTM
The ACCRINTM function is used to calculate the accrued interest for a security that pays interest at maturity. It is...
=ACCRINTM(Issue, Settlement, Rate, Par, [Basis]) AMORLINC
The AMORLINC function in Excel is used to calculate the prorated depreciation for an asset for a specific accounting...
=AMORLINC(Cost, Date purchased, First period, Salvage, Period, Rate, [Basis]) COUPDAYBS
The COUPDAYBS function is used to calculate the number of days from the beginning of the coupon period to the settlement...
=COUPDAYBS(Settlement, Maturity, Frequency, Basis) COUPDAYS
The COUPDAYS function calculates the number of days in the coupon period that contains the settlement date. It is...
=COUPDAYS(Settlement, Maturity, Frequency, [Basis]) COUPDAYSNC
The COUPDAYSNC function is used to calculate the number of days in a coupon period falling within the settlement date...
=COUPDAYSNC(Settlement, Maturity, Frequency, [Basis]) COUPNCD
The COUPNCD function in Excel is used to calculate the next coupon date (the date when the next coupon payment is due)...
=COUPNCD(Settlement, Maturity, Frequency, Basis) COUPNUM
The COUPNUM function in Excel is utilized to determine the number of coupons to be paid between the settlement date and...
=COUPNUM(Settlement, Maturity, Frequency, Basis) COUPPCD
The COUPPCD function is used to calculate the previous coupon date before the settlement date for a security that pays...
=COUPPCD(Settlement, Maturity, Frequency, [Basis]) CUMIPMT
The CUMIPMT function in Excel is used to calculate the cumulative interest paid between two specified periods for a loan...
=CUMIPMT(Rate, Nper, Pv, Start_period, End_period, Type) CUMPRINC
The CUMPRINC function calculates the principal portion of a loan payment made during a specific period. It helps in...
=CUMPRINC(Rate, Nper, Pv, Start Period, End Period, Type) DB
The DB function calculates the depreciation of an asset for a specific period using the fixed-declining balance method....
=DB(Cost, Salvage, Life, Period, [Month]) DDB
The DDB function is used to calculate the depreciation of an asset for a specified period using the double-declining...
=DDB(Cost, Salvage, Life, Period, [Factor]) DISC
The DISC function in Excel is used to calculate the discount rate for a security. It is commonly utilized in financial...
=DISC(Settlement, Maturity, Price, Redemption, Coupon, Yield, [Frequency]) DOLLARDE
The DOLLARDE function is used to convert a dollar price value expressed as a fraction into a decimal number in Excel....
=DOLLARDE(FractionalDollar, [Fraction]) DOLLARFR
The DOLLARFR function is used to convert a dollar price expressed as a decimal number into a fraction representation....
=DOLLARFR(decimal_dollar, fraction) DURATION
The DURATION function calculates the Macaulay duration of a security, which provides a measure of the weighted average...
=DURATION(Settlement, Maturity, Rate, Yield, Redemption, [Frequency], [Basis]) EFFECT
The EFFECT function calculates the annual effective interest rate based on a nominal interest rate and the number of...
=EFFECT(Nominal_rate, Npery) FV
The FV function calculates the future value of an investment based on periodic, constant payments and a constant...
=FV(Rate, Nper, Pmt, [PV], [Type]) FVSCHEDULE
The FVSCHEDULE function is used to calculate the future value of an initial principal amount after applying a series of...
=FVSCHEDULE(Principal, Schedule) INTRATE
The INTRATE function is used to calculate the interest rate for a fully invested security.
=INTRATE(Settlement, Maturity, Investment, Redemption, Basis) IPMT
Calculate the interest portion of a loan payment for a given period with IPMT.
=IPMT(Rate, Period, Num_periods, PV, [FV], [Type]) IRR
The IRR function calculates the internal rate of return for a series of cash flows. It is commonly used in finance to...
=IRR(Values, [Guess]) ISPMT
The ISPMT function calculates the interest portion of a loan payment for a specific period based on a fixed interest...
=ISPMT(Rate, Per, Nper, PV) MDURATION
The MDURATION function calculates the Macaulay duration of a security, which provides the weighted average time to...
=MDURATION(Settlement, Maturity, Rate, Yield, Frequency, [Basis]) MIRR
The MIRR function in Excel calculates the modified internal rate of return for a series of cash flows that may have...
=MIRR(values, finance_rate, reinvest_rate) NOMINAL
The NOMINAL function converts an effective interest rate to a nominal interest rate. It is commonly used in financial...
=NOMINAL(Effective_rate, Npery) NPER
The NPER function calculates the number of periods for an investment or loan based on regular fixed payments and a...
=NPER(Rate, Pmt, PV, [FV], [Type]) NPV
The NPV function in Excel is utilized to calculate the net present value of an investment by discounting the series of...
=NPV(Rate, Value1, [Value2, ...]) ODDFPRICE
The ODDFPRICE function is used to calculate the price per $100 face value of a security that pays periodic interest at...
=ODDFPRICE(Settlement, Maturity, Issue, First_coup, Rate, Yld, Redemption, Frequency, [Basis]) ODDFYIELD
The ODDFYIELD function calculates the yield of a security that has an odd (irregular) first period.
=ODDFYIELD(Settlement, Maturity, Issue, First_coupon, Rate, Pr, Redemption, Basis) ODDLPRICE
The ODDLPRICE function calculates the price per $100 face value of a security with an odd (irregular) first period.
=ODDLPRICE(Settlement, Maturity, Issue, First_Coup, Rate, Yield, Redemption, Basis) ODDLYIELD
The ODDLYIELD function calculates the yield of a security with an odd first period, such as T-bills that have a short or...
=ODDLYIELD(settlement, maturity, issue, first_coupon, rate, price, redemption, basis) PDURATION
The PDURATION function calculates the duration of an investment with periodic payments based on a specified discount...
=PDURATION(Rate, Nper, Pmt, Fv, Type) PMT
The PMT function is used to calculate the periodic payment for a loan or investment, based on constant payments and a...
=PMT(Rate, Nper, Pv, Fv, [Type]) PPMT
The PPMT function is used to calculate the principal payment for a specific period of a loan or investment with constant...
=PPMT(Rate, Per, Nper, PV, FV, Type) PRICE
The PRICE function calculates the price per $100 face value of a security that pays periodic interest. It is commonly...
=PRICE(Settlement, Maturity, Rate, Yield, Redemption, [Frequency], [Basis]) PRICEDISC
The PRICEDISC function calculates the price of a discounted security, such as a treasury bill, that pays interest at...
=PRICEDISC(Settlement, Maturity, Discount, Redemption, [Basis]) PRICEMAT
The PRICEMAT function is used to calculate the price per $100 face value of a security that pays interest at maturity....
=PRICEMAT(Settlement, Maturity, Issue, RATE, Yield, Basis) PV
The PV function calculates the present value of an investment or a loan based on a constant interest rate.
=PV(rate, nper, pmt, [fv], [type]) RATE
The RATE function calculates the interest rate per period of an annuity investment by solving for the rate in the...
=RATE(Nper, Pmt, Pv, Fv, [Type], [Guess]) RECEIVED
The RECEIVED function calculates the amount received at maturity for an investment, such as a bond, based on a...
=RECEIVED(Settlement, Maturity, Investment, Discount, [basis]) RRI
The RRI function in Excel is used to calculate the internal rate of return for an investment based on a series of...
=RRI(Nper, PV, FV) SLN
The SLN function calculates the straight-line depreciation of an asset for a single period. It is commonly used in...
=SLN(Cost, Salvage, Life) STOCKHISTORY
Pull historical stock prices and trading data directly into Excel with the STOCKHISTORY function.
=STOCKHISTORY(symbol, start_date, end_date, interval, headers) SYD
The SYD function calculates the depreciation of an asset for a specific period using the Sum of Years' Digits method. It...
=SYD(Cost, Salvage, Life, Period) TBILLEQ
The TBILLEQ function calculates the equivalent annualized yield for a US Treasury bill, providing a means to analyze and...
=TBILLEQ(Settlement, Maturity, Discount) TBILLPRICE
The TBILLPRICE function is used to calculate the price per $100 face value for a Treasury bill based on discount rate.
=TBILLPRICE(Settlement, Maturity, Discount) TBILLYIELD
The TBILLYIELD function is used to calculate the yield of a US Treasury Bill based on its price. This function is...
=TBILLYIELD(Settlement, Maturity, Price) VDB
The VDB function calculates the depreciation of an asset for a specific accounting period using the double-declining...
=VDB(Cost, Salvage, Life, Start_period, End_period, [Factor], [No_switch]) XIRR
The XIRR function calculates the internal rate of return for a series of cash flows that are not necessarily periodic....
=XIRR(Values, Dates, Guess) XNPV
The XNPV function calculates the net present value of a series of cash flows at specific dates, using a specified...
=XNPV(Rate, Values, Dates) YIELD
The YIELD function calculates the yield of a security that pays periodic interest, such as bonds or treasury bills. It...
=YIELD(Settlement, Maturity, Rate, Pr, Redemption, [Frequency], [Basis]) YIELDDISC
The YIELDDISC function calculates the annual yield of a discounted security, such as a treasury bill or zero-coupon...
=YIELDDISC(Settlement, Maturity, Discount, Redemption, [Basis]) YIELDMAT
The YIELDMAT function calculates the annual yield of a security that pays interest at maturity. This function is...
=YIELDMAT(Settlement, Maturity, Issue, Rate, Pr, [Basis]) Information functions
19 function s
Function Purpose Syntax
CELL
The CELL function is used to retrieve information about the formatting, location, or contents of a cell in Excel. It is...
=CELL(info_type, reference) ERROR.TYPE
The ERROR.TYPE function is used to return a number corresponding to the error value of a cell.
=ERROR.TYPE(error_val) ISBLANK
The ISBLANK function checks whether a specified cell is blank (empty) and returns TRUE if it is blank or FALSE if it...
=ISBLANK(value) ISERR
The ISERR function is used in Excel to check if a value is an error other than #N/A. It returns TRUE if the value is any...
=ISERR(value) ISERROR
Check if a cell contains any Excel error value with the ISERROR function.
=ISERROR(value) ISEVEN
The ISEVEN function in Excel is used to check if a number is even.
=ISEVEN(number) ISFORMULA
The ISFORMULA function is used to check whether a cell contains a formula or a constant value. This function is handy...
=ISFORMULA(reference) ISLOGICAL
The ISLOGICAL function in Excel is used to check if a value is a logical value (TRUE or FALSE). It returns TRUE if the...
=ISLOGICAL(value) ISNA
Check whether a value is the #N/A error and return TRUE or FALSE.
=ISNA(value) ISNONTEXT
The ISNONTEXT function checks whether a value is not text. It returns TRUE if the value is not a text string and FALSE...
=ISNONTEXT(value) ISNUMBER
The ISNUMBER function is used to check if a value is a numeric value (number) or not. It returns TRUE if the value is a...
=ISNUMBER(value) ISODD
The ISODD function in Excel is used to check if a given number is odd or not. It returns TRUE if the number is odd and...
=ISODD(number) ISREF
The ISREF function is used to check if a value is a reference or not in Excel. This function returns TRUE if the value...
=ISREF(value) ISTEXT
The ISTEXT function is used to check if a value is a text string. It returns TRUE if the value is a text string;...
=ISTEXT(value) N
The N function in Excel is used to check if a value is a number. It returns TRUE if the value is a number and FALSE if...
=N(value) NA
The NA function returns the #N/A error value which stands for 'Not Available', indicating that the requested value is...
=NA() SHEET
The SHEET function is used to return the sheet number of a referenced sheet in a workbook. This function is helpful for...
=SHEET(value) SHEETS
The SHEETS function is used to count the number of sheets in a reference.
=SHEETS(reference) TYPE
The TYPE function in Excel is used to determine the data type of a given value. It returns a number that corresponds to...
=TYPE(value) Logical functions
15 function s
Function Purpose Syntax
AND
Check if all conditions are true with AND, which returns TRUE only when every test passes.
=AND(logical1, logical2, ...) FALSE
The FALSE function in Excel returns the logical value 'FALSE', indicating a condition of falsity or a negative outcome.
=FALSE() IF
Returns one value when a condition is true and another when it's false
=IF(Logical_test, Value_if_true, Value_if_false) IFERROR
Check a formula for errors. Return a fallback value when one occurs, or the formula result when it does not.
=IFERROR(value, value_if_error) IFNA
The IFNA function allows you to replace #N/A errors in Excel with a specific value of your choice. This function comes...
=IFNA(value, value_if_na) IFS
Check multiple conditions at once and return the value for the first one that's true.
=IFS(logical_test1, value_if_true1, [logical_test2, value_if_true2, ...], [default_value]) LAMBDA
Creates a custom, reusable function with named parameters and saves it as a named formula in the workbook. No VBA or...
=LAMBDA([parameter1, parameter2, ...], calculation) LET
Name intermediate values inside a formula with LET so long calculations are easier to read and faster to run.
=LET(name1, value1, calculation_or_name2, [value2], ...) MAP
Apply a LAMBDA to every value in one or more arrays and return a new array of the results with MAP.
=MAP(array1, [array2, ...], lambda) NOT
The NOT function in Excel is used to reverse the logical value of a given expression. It returns TRUE if the expression...
=NOT(logical_expression) OR
Test whether any of multiple conditions are TRUE in Excel
=OR(logical1, [logical2], ...) REDUCE
Boil a whole array down to a single result by running a LAMBDA across every value and carrying a running total forward...
=REDUCE([initial_value], array, lambda) SWITCH
The SWITCH function allows you to evaluate an expression against a list of values and return a corresponding result...
=SWITCH(expression, value1, result1, [value2, result2,...], default) TRUE
The TRUE function in Excel returns the logical value TRUE, which represents the boolean value of 'true' or 'yes'. It is...
=TRUE() XOR
The XOR function is used in Excel to perform an exclusive OR logical operation on one or more expressions. It returns...
=XOR(logical1, logical2, ...) Lookup and reference functions
30 function s
Function Purpose Syntax
ADDRESS
The ADDRESS function in Excel is used to create a cell address as text, based on specified row and column numbers. This...
=ADDRESS(row_num, column_num, [abs_num], [a1]) AREAS
The AREAS function in Excel is used to count the number of areas in a reference. It is commonly used in conjunction with...
=AREAS(reference) CHOOSE
Pick a value from a list by its position number with Excel's CHOOSE function.
=CHOOSE(index_num, value1, [value2], ...) CHOOSECOLS
Return specific columns from an array or range with Excel's CHOOSECOLS function.
=CHOOSECOLS(array, col_num1, [col_num2], ...) CHOOSEROWS
Return specific rows from an array or range, in any order you choose.
=CHOOSEROWS(array, row_num1, [row_num2], ...) COLUMN
The COLUMN function in Excel is used to return the column number of a specified cell reference. It is useful for...
=COLUMN([reference]) COLUMNS
The COLUMNS function returns the number of columns in a reference or array in Excel. It is useful for calculating the...
=COLUMNS(array) DROP
Remove a set number of rows or columns from the start or end of an array with Excel's DROP function.
=DROP(array, rows, [columns]) FILTER
Pull specific rows from a range based on conditions you define, returning a dynamic array of matching results.
=FILTER(array, include, [if_empty]) FORMULATEXT
The FORMULATEXT function returns the formula in a cell as text, allowing you to display or refer to the formula itself...
=FORMULATEXT(reference) GETPIVOTDATA
Pull a single summarized value out of a pivot table with Excel's GETPIVOTDATA function.
=GETPIVOTDATA(DataField, PivotTable, Field1, Item1, [Field2], [Item2], ..., [FieldN, [ItemN]]) HLOOKUP
Look up a value in the top row of a table and return a value from the same column with HLOOKUP.
=HLOOKUP(lookup_value, table_array, row_index_num, [range_lookup]) HSTACK
Join two or more ranges side by side to build one wider array in a single formula.
=HSTACK(array1, [array2], ...) HYPERLINK
The HYPERLINK function creates a clickable hyperlink in a cell. It is used to direct users to a specific website, file,...
=HYPERLINK(link_location, [friendly_name]) INDEX
Return the value at a given row and column position in a range with Excel's INDEX function.
=INDEX(array, row_num, [column_num]) INDIRECT
The INDIRECT function is used to return the reference specified by a text string. It is commonly employed in Excel to...
=INDIRECT(ref_text, [a1]) LOOKUP
The LOOKUP function is used to search for a value in a range or array and return a value that corresponds to the first...
=LOOKUP(lookup_value, lookup_vector, result_vector) MATCH
Find the position of a value in a range or array with Excel's MATCH function.
=MATCH(lookup_value, lookup_array, [match_type]) OFFSET
The OFFSET function in Excel is used to return a reference to a range that is a specified number of rows and columns...
=OFFSET(reference, rows, cols, [height], [width]) ROW
The ROW function returns the row number of a reference. It is handy for dynamic referencing and data manipulation in...
=ROW([reference]) ROWS
The ROWS function in Excel is used to count the number of rows in a specified range or array. It is handy for quickly...
=ROWS(array) SORT
Sort a range or array by any column in ascending or descending order with the SORT function.
=SORT(array, [sort_index], [sort_order], [by_col]) SORTBY
The SORTBY function is used to sort a range or array based on the values in another range or array. It is handy for...
=SORTBY(array, by_array, [sort_order], [sort]) TAKE
Return a set number of rows or columns from the start or end of an array with TAKE.
=TAKE(array, rows, [columns]) TRANSPOSE
The TRANSPOSE function in Excel converts a vertical range of cells into a horizontal range, or vice versa. It allows you...
=TRANSPOSE(array) UNIQUE
Return a list of distinct values from a range or array, removing duplicates automatically.
=UNIQUE(array, [by_col], [exactly_once]) VLOOKUP
Search for a value in the first column of a table and retrieve data from another column in the same row.
=VLOOKUP(lookup_value, table_array, col_index_num, range_lookup) VSTACK
Stack two or more ranges on top of each other to build one taller array in a single formula.
=VSTACK(array1, [array2], ...) XLOOKUP
Search a range or array for a value and return the corresponding result from another range.
=XLOOKUP(lookup_value, lookup_array, return_array, [if_not_found], [match_mode], [search_mode]) XMATCH
The XMATCH function is used to search for a specified item in a range or array and returns the relative position of that...
=XMATCH(lookup_value, lookup_array, [match_type], [search_mode]) Math and trigonometry functions
80 function s
Function Purpose Syntax
ABS
Returns the absolute value of a number, removing any negative sign.
=ABS(number) ACOS
The ACOS function returns the arccosine, or inverse cosine, of a number. It is useful for finding the angle whose cosine...
=ACOS(number) ACOSH
The ACOSH function is used to calculate the inverse hyperbolic cosine of a number. It is commonly used in mathematical...
=ACOSH(number) ACOT
The ACOT function returns the arccotangent, or the inverse cotangent, of a number. It is useful for calculating angles...
=ACOT(number) ACOTH
The ACOTH function returns the inverse hyperbolic cotangent of a number. It is useful for performing calculations in...
=ACOTH(number) AGGREGATE
Run one of 19 built-in calculations on a range while skipping hidden rows, error values, or nested subtotals.
=AGGREGATE(function_num, options, ref1, [ref2], ...) ARABIC
The ARABIC function is used to convert a Roman numeral to an Arabic (decimal) number. It can be handy for converting...
=ARABIC(text) ASIN
Get the arcsine (inverse sine) of a number and return the angle in radians with ASIN.
=ASIN(number) ASINH
The ASINH function is used to calculate the inverse hyperbolic sine of a number. This function is essential in...
=ASINH(number) ATAN
The ATAN function returns the arctangent, or inverse tangent, of a number. It is commonly used in trigonometry and...
=ATAN(number) ATAN2
The ATAN2 function returns the arctangent of the specified x- and y-coordinates, representing the angle in radians...
=ATAN2(x_num, y_num) ATANH
The ATANH function returns the hyperbolic arctangent of a number. It is useful in scenarios involving mathematical...
=ATANH(number) BASE
The BASE function converts a number to a text representation in a specified base (radix), incorporating the characters...
=BASE(Number, Radix, [Min length]) CEILING
Round a number up to the nearest multiple of a value you choose with Excel's CEILING function.
=CEILING(number, significance) CEILING.MATH
The CEILING.MATH function rounds a number up to the nearest multiple of a specified significance. This function is...
=CEILING.MATH(number, significance) CEILING.PRECISE
The CEILING.PRECISE function rounds a number up to the nearest specified multiple, ensuring a precise upward rounding...
=CEILING.PRECISE(number, significance) COMBIN
The COMBIN function is used to calculate the number of combinations for a given number of items selected from a set...
=COMBIN(n, k) COMBINA
The COMBINA function calculates the number of combinations with repetitions for a specified number of items. It is...
=COMBINA(number, number_chosen) COS
Calculate the cosine of an angle (in radians) with Excel's COS function.
=COS(number) COSH
The COSH function returns the hyperbolic cosine of a number. It is useful for calculations involving exponential growth...
=COSH(number) COT
The COT function in Excel is used to return the cotangent of an angle, given in radians.
=COT(number) COTH
Calculate the hyperbolic cotangent of a number in Excel with COTH.
=COTH(number) CSC
The CSC function returns the cosecant of an angle specified in radians. In trigonometry, the cosecant is the reciprocal...
=CSC(number) CSCH
The CSCH function returns the hyperbolic cosecant of a number. It is a mathematical function used to calculate the...
=CSCH(number) DECIMAL
The DECIMAL function is used in Excel to convert a text representation of a number in a specific base to its decimal...
=DECIMAL(Text, Radix) DEGREES
The DEGREES function converts radians to degrees. It is useful when working with trigonometry or geometry calculations.
=DEGREES(angle) EVEN
The EVEN function rounds a number up to the nearest even integer. It is helpful when you need to manipulate numbers for...
=EVEN(number) EXP
The EXP function returns the mathematical constant e raised to the power of a given number. In simpler terms, it...
=EXP(number) FACT
The FACT function calculates the factorial of a number, which is the product of all positive integers up to and...
=FACT(number) FACTDOUBLE
The FACTDOUBLE function returns the double factorial of a number, which is the product of every second number up to the...
=FACTDOUBLE(number) FLOOR
The FLOOR function returns a number rounded down to the nearest multiple of significance. It is commonly used in...
=FLOOR(number, significance) FLOOR.MATH
The FLOOR.MATH function rounds a number down, towards zero, to the nearest multiple of a specified significance.
=FLOOR.MATH(number, significance, [mode]) FLOOR.PRECISE
The FLOOR.PRECISE function is used to round numbers down to the nearest specified multiple, ensuring that the result is...
=FLOOR.PRECISE(number, significance) GCD
Find the greatest common divisor of two or more integers with Excel's GCD function
=GCD(Number1, Number2, ...) INT
Round a number down to the nearest integer with Excel's INT function.
=INT(number) LCM
The LCM function in Excel is used to find the least common multiple of one or more integers. It is particularly helpful...
=LCM(number1, number2, [number3], ...) LN
The LN function calculates the natural logarithm of a number. It is commonly used in mathematical and scientific...
=LN(number) LOG
The LOG function calculates the logarithm of a number to a specified base. It is commonly used in mathematical and...
=LOG(Number, Base) LOG10
The LOG10 function calculates the base 10 logarithm of a number. It is useful for converting numbers into logarithmic...
=LOG10(number) MDETERM
The MDETERM function calculates the matrix determinant of an array in Excel. This function is handy for performing...
=MDETERM(array) MINVERSE
The MINVERSE function is used to calculate the multiplicative inverse (or matrix inverse) of a given square matrix in...
=MINVERSE(array) MMULT
The MMULT function in Excel is used to multiply two matrices and return the matrix product.
=MMULT(array1, array2) MOD
The MOD function in Excel returns the remainder after a number is divided by a divisor. It is commonly used to calculate...
=MOD(number, divisor) MROUND
The MROUND function is used to round a number to the nearest multiple specified by the user. This function is handy for...
=MROUND(number, multiple) MULTINOMIAL
The MULTINOMIAL function calculates the multinomial coefficient for a set of numbers you specify. It is useful in...
=MULTINOMIAL(Number1, [Number2,...]) MUNIT
The MUNIT function returns a unit matrix of a specified size. A unit matrix is a square matrix where all elements are...
=MUNIT(size) ODD
The ODD function in Excel is used to round a number up to the nearest odd integer. This function is helpful when you...
=ODD(number) PI
The PI function returns the mathematical constant pi (π), which represents the ratio of the circumference of a circle to...
=PI() POWER
The POWER function raises a number to a specified power.
=POWER(number, power) PRODUCT
The PRODUCT function in Excel calculates the product of a given set of values. It multiplies all the numbers together...
=PRODUCT(number1, [number2], ...) QUOTIENT
The QUOTIENT function in Excel returns the integer portion of a division between two numbers, discarding any remainder....
=QUOTIENT(numerator, denominator) RADIANS
The RADIANS function converts angles from degrees to radians in Excel. It is commonly used in trigonometry and geometry...
=RADIANS(angle) RAND
The RAND function generates a random decimal number between 0 and 1. It is commonly used in Excel to produce random...
=RAND() RANDARRAY
The RANDARRAY function generates an array of random numbers between 0 and 1. It's handy for creating datasets for...
=RANDARRAY(rows, columns, [min], [max], [integer]) RANDBETWEEN
The RANDBETWEEN function is used to generate a random integer number between two specified values. It is commonly...
=RANDBETWEEN(Bottom, Top) ROMAN
The ROMAN function converts an Arabic numeral into a Roman numeral in Excel. It is helpful for displaying numbers in a...
=ROMAN(Number, [Form]) ROUND
Round a number to a set number of decimal places with the ROUND function.
=ROUND(number, num_digits) ROUNDDOWN
The ROUNDDOWN function rounds a number down towards zero to a specified number of digits.
=ROUNDDOWN(number, num_digits) ROUNDUP
The ROUNDUP function in Excel is used to round a number towards a specified number of digits away from zero. It rounds...
=ROUNDUP(number, num_digits) SEC
The SEC function in Excel is used to calculate the annual interest rate of a security based on its settlement date,...
=SEC(Settlement, Maturity, Pr, Redemption, Basis) SECH
The SECH function returns the hyperbolic secant of an angle in radians. It is useful in mathematical calculations...
=SECH(number) SEQUENCE
The SEQUENCE function generates a sequence of numbers in an array, providing a convenient way to create a series of...
=SEQUENCE(rows, [columns], [start], [step]) SERIESSUM
The SERIESSUM function in Excel is used to return the sum of a power series based on the formula: a * power( x, 1 ) + b...
=SERIESSUM(x, n, coef, power)) SIGN
The SIGN function is used to determine the sign of a number. It returns 1 if the number is positive, -1 if the number is...
=SIGN(number) SIN
The SIN function returns the sine of an angle provided in radians. It is commonly used in trigonometry and geometry...
=SIN(number) SINH
The SINH function calculates the hyperbolic sine of a given number. It is a mathematical function that is particularly...
=SINH(number) SQRT
The SQRT function returns the square root of a number.
=SQRT(number) SQRTPI
The SQRTPI function calculates the square root of the product of a number and pi (π). It is a simple mathematical...
=SQRTPI(number) SUBTOTAL
The SUBTOTAL function in Excel is a versatile tool that performs calculations on a range of data while allowing the user...
=SUBTOTAL(function_num, ref1, [ref2, ...]) SUM
Add up numbers in a range with Excel's SUM function.
=SUM(number1, number2, ...) SUMIF
Add up numbers in a range that meet a specific condition with SUMIF
=SUMIF(range, criteria, [sum_range]) SUMIFS
Sum values that meet multiple conditions at once with SUMIFS, Excel's multi-criteria addition function.
=SUMIFS(sum_range, criteria_range1, criteria1, [criteria_range2, criteria2, ...]) SUMPRODUCT
Multiply matching entries across arrays and return the total of those products.
=SUMPRODUCT(array1, [array2, ...]) SUMSQ
The SUMSQ function calculates the sum of the squares of a set of numbers. This function is handy for quickly finding the...
=SUMSQ(number1, [number2], ...) SUMX2MY2
The SUMX2MY2 function in Excel is used to calculate the sum of squares of differences between corresponding arrays in...
=SUMX2MY2(array_x, array_y) SUMX2PY2
The SUMX2PY2 function calculates the sum of the squares of corresponding values from two arrays.
=SUMX2PY2(array_x, array_y) SUMXMY2
The SUMXMY2 function calculates the sum of the squares of differences between corresponding values in two arrays. It is...
=SUMXMY2(array_x, array_y) TAN
Calculate the tangent of an angle (in radians) with Excel's TAN function.
=TAN(number) TANH
The TANH function calculates the hyperbolic tangent of a given angle, where the angle is expressed in radians. It is...
=TANH(number) TRUNC
Remove the decimal part of a number with TRUNC, keeping only the integer portion or a fixed number of decimal places.
=TRUNC(number, [num_digits]) Statistical functions
105 function s
Function Purpose Syntax
AVEDEV
The AVEDEV function in Excel calculates the average of the absolute deviations of data points from their average value....
=AVEDEV(number1, [number2,...]) AVERAGE
Calculate the arithmetic mean of numbers in a range or list.
=AVERAGE(number1, number2, ...) AVERAGEA
The AVERAGEA function calculates the average of a set of values, including numbers, text, logical values (TRUE or...
=AVERAGEA(value1, [value2], ...]) AVERAGEIF
Find the average of cells in a range that meet a single condition.
=AVERAGEIF(range, criteria, [average_range]) AVERAGEIFS
The AVERAGEIFS function calculates the average of a range of values based on multiple criteria. It allows you to specify...
=AVERAGEIFS(average_range, criteria_range1, criteria1, [criteria_range2, criteria2, ...]) BETA.DIST
The BETA.DIST function is used to calculate the probability density function or cumulative distribution function for a...
=BETA.DIST(x, alpha, beta, [cumulative], [lower_bound], [upper_bound]) BETA.INV
The BETA.INV function is used to calculate the inverse of the cumulative beta distribution for a specified probability.
=BETA.INV(Probability, Alpha, Beta, [A], [B]) BINOM.DIST
The BINOM.DIST function is used to calculate the probability of a certain number of successes in a fixed number of...
=BINOM.DIST(number_s, trials, probability_s, cumulative) BINOM.DIST.RANGE
The BINOM.DIST.RANGE function is used to calculate the probability of a certain number of successful events occurring...
=BINOM.DIST.RANGE(Number_s, Trials, Probability_s, Cumulative) BINOM.INV
The BINOM.INV function calculates the smallest value for which the cumulative binomial distribution is less than or...
=BINOM.INV(Trials, Probability_s, Probability_s, Cumulative) CHISQ.DIST
The CHISQ.DIST function calculates the probability of a chi-squared distribution, which is commonly used in statistical...
=CHISQ.DIST(x, deg_freedom, cumulative) CHISQ.DIST.RT
The CHISQ.DIST.RT function calculates the right-tailed probability of the chi-squared distribution, which is commonly...
=CHISQ.DIST.RT(x, degrees_freedom) CHISQ.INV
The CHISQ.INV function calculates the inverse of the chi-squared cumulative distribution function (CDF). It is useful in...
=CHISQ.INV(probability, degrees_freedom) CHISQ.INV.RT
The CHISQ.INV.RT function returns the inverse of the right-tailed probability of the chi-squared distribution. It is...
=CHISQ.INV.RT(probability, degrees_freedom) CHISQ.TEST
The CHISQ.TEST function is used to calculate the significance of the chi-squared statistic. This is commonly used in...
=CHISQ.TEST(actual_range, expected_range) CONFIDENCE.NORM
The CONFIDENCE.NORM function is used to calculate the confidence interval for a population mean, assuming a normal...
=CONFIDENCE.NORM(alpha, stdev, size) CONFIDENCE.T
The CONFIDENCE.T function calculates the confidence interval for a Student's t-distribution. It is commonly used in...
=CONFIDENCE.T(alpha, standard_dev, size) CORREL
The CORREL function is used to calculate the correlation coefficient between two sets of data in Excel. It is commonly...
=CORREL(array1, array2) COUNT
Count how many cells in a range contain numbers with Excel's COUNT function.
=COUNT(value1, [value2], ...) COUNTA
Count non-empty cells in Excel, regardless of whether they contain numbers, text, or errors.
=COUNTA(value1, [value2, ...]) COUNTBLANK
The COUNTBLANK function in Excel is used to count the number of empty cells within a specified range.
=COUNTBLANK(range) COUNTIF
Count the cells in a range that meet a single condition with Excel's COUNTIF function.
=COUNTIF(range, criteria) COUNTIFS
Count cells that meet two or more conditions at once.
=COUNTIFS(range1, criteria1, [range2, criteria2, ...]) COVARIANCE.P
The COVARIANCE.P function calculates the population covariance between two sets of values. It is commonly used in...
=COVARIANCE.P(array1, array2) COVARIANCE.S
The COVARIANCE.S function is used to calculate the sample covariance between two sets of data. It is commonly employed...
=COVARIANCE.S(array1, array2) DEVSQ
The DEVSQ function in Excel is used to calculate the sum of squares of deviations from the mean of a data set. It is...
=DEVSQ(number1, [number2, ... ]) EXPON.DIST
The EXPON.DIST function calculates the probability density or the cumulative distribution function for an exponential...
=EXPON.DIST(x, lambda, cumulative) F.DIST
The F.DIST function returns the cumulative probability of a specific F-statistic in a data set, using the...
=F.DIST(x, deg_freedom1, deg_freedom2, cumulative) F.DIST.RT
The F.DIST.RT function calculates the right-tailed F probability distribution. It is commonly used in statistical...
=F.DIST.RT(x, deg_freedom1, deg_freedom2) F.INV
The F.INV function calculates the inverse of the F probability distribution. It is commonly used in statistical analysis...
=F.INV(probability, degrees_freedom1, degrees_freedom2) F.INV.RT
The F.INV.RT function is used to calculate the inverse of the F probability distribution. It provides the value at which...
=F.INV.RT(probability, degrees_freedom1, degrees_freedom2) F.TEST
The F.TEST function is used to return the result of an F-test. It is commonly employed in statistical analysis to...
=F.TEST(array1, array2) FISHER
The FISHER function in Excel is used to calculate the Fisher transformation of a given value.
=FISHER(X) FISHERINV
The FISHERINV function in Excel is used to calculate the inverse Fisher transformation on a given value. This function...
=FISHERINV(Y) FORECAST
The FORECAST function is used to predict a future value based on existing values. It is commonly utilized in financial...
=FORECAST(x, known_y's, known_x's) FREQUENCY
The FREQUENCY function is used to calculate the frequency distribution of data points in a set of values. This function...
=FREQUENCY(Data_Array, Bins_Array) GAMMA
The GAMMA function calculates the gamma function of a given value. In mathematical terms, the gamma function is an...
=GAMMA(number) GAMMA.DIST
The GAMMA.DIST function calculates the gamma distribution probability for a given value in Excel. This function is...
=GAMMA.DIST(X, Alpha, Beta, Cumulative) GAMMA.INV
The GAMMA.INV function calculates the inverse of the gamma cumulative distribution function (CDF) for a specified...
=GAMMA.INV(Probability, Alpha, Beta) GAMMALN
The GAMMALN function returns the natural logarithm of the absolute value of the gamma function for a given numeric...
=GAMMALN(X) GAUSS
The GAUSS function in Excel is used to return the normal distribution of a specified value.
=GAUSS(Z) GEOMEAN
The GEOMEAN function calculates the geometric mean of a set of numbers. It is particularly useful in situations where...
=GEOMEAN(number1, [number2], [number3], ...) GROWTH
The GROWTH function is used to predict exponential growth based on existing data points. It calculates the predicted...
=GROWTH(known_y's, known_x's, new_x, const) HARMEAN
The HARMEAN function calculates the harmonic mean of a set of values. It is particularly useful in situations where...
=HARMEAN(number1, number2, ..., number255) HYPGEOM.DIST
The HYPGEOM.DIST function calculates the hypergeometric distribution in Excel. This function is useful in statistical...
=HYPGEOM.DIST(Sample_s, Number_sampled, Population_successes, Population, Cumulative) INTERCEPT
The INTERCEPT function calculates the point at which a given line intersects the y-axis based on a set of x and y...
=INTERCEPT(known_y's, known_x's) KURT
The KURT function calculates the kurtosis of a data set, which measures the sharpness of the peak or the flatness of the...
=KURT(number1, number2, ...) LARGE
The LARGE function in Excel returns the nth largest value from a range of data. It is useful for quickly identifying the...
=LARGE(array, n) LINEST
The LINEST function in Excel is used to calculate statistics for a line that best fits a set of data points by...
=LINEST(y, [x], [const], [stats]) LOGEST
The LOGEST function is used to calculate an exponential curve that best fits your data points. This function is commonly...
=LOGEST(Known_Y's, Known_X's, Const, Stats) LOGNORM.DIST
The LOGNORM.DIST function calculates the probability density function or the cumulative distribution function for a...
=LOGNORM.DIST(x, mean, standard_dev, cumulative) LOGNORM.INV
The LOGNORM.INV function returns the inverse of the standard normal cumulative distribution for a specified mean and...
=LOGNORM.INV(probability, mean, standard_dev) MAX
The MAX function in Excel is used to find the largest numeric value in a range of cells or an array. It is commonly...
=MAX(number1, [number2, ...]) MAXA
The MAXA function returns the largest numeric value in a range of cells, including numbers, dates, times, errors, and...
=MAXA(value1, [value2], ...) MAXIFS
The MAXIFS function returns the maximum value from a range of cells that meets multiple criteria. This function is handy...
=MAXIFS(Max_range, Criteria_range1, Criteria1, [Criteria_range2, Criteria2,...]) MEDIAN
The MEDIAN function in Excel returns the median (middle) value in a set of numbers. It is useful for finding the middle...
=MEDIAN(number1, [number2], [number3], ...) MIN
Find the smallest number in a range or list of values with Excel's MIN function.
=MIN(number1, [number2, ...]) MINA
The MINA function returns the minimum numeric value from a set of supplied arguments. It is an essential tool for...
=MINA(value1, [value2], [value3], ...) MINIFS
The MINIFS function returns the smallest numeric value in a range that meet multiple criteria.
=MINIFS(Min_range, Criteria_range1, Criteria1, [Criteria_range2, Criteria2, ...]) MODE.MULT
The MODE.MULT function in Excel calculates the multiple most frequently occurring values in a dataset. It is useful for...
=MODE.MULT(number1, [number2], ...) MODE.SNGL
The MODE.SNGL function in Excel returns the most frequently occurring number (mode) within a dataset. It is useful for...
=MODE.SNGL(number1, [number2, ...]) NEGBINOM.DIST
The NEGBINOM.DIST function calculates the negative binomial distribution, which models the number of failures that occur...
=NEGBINOM.DIST(Number_F, Number_S, Probability_S, Cumulative) NORM.DIST
The NORM.DIST function calculates the probability that a value falls within a given range in a normal distribution. It...
=NORM.DIST(x, mean, standard_dev, cumulative) NORM.INV
The NORM.INV function calculates the inverse of the standard normal cumulative distribution. It is commonly used in...
=NORM.INV(probability, mean, standard_dev) NORM.S.DIST
The NORM.S.DIST function in Excel calculates the standard normal cumulative distribution function for a specified value....
=NORM.S.DIST(Z, Cumulative) NORM.S.INV
The NORM.S.INV function calculates the inverse of the standard normal cumulative distribution for a specified...
=NORM.S.INV(probability) PEARSON
The PEARSON function is used to calculate the Pearson correlation coefficient between two sets of values. It is commonly...
=PEARSON(array1, array2) PERCENTILE.EXC
The PERCENTILE.EXC function calculates the k-th percentile for a given data set, excluding logical values and text. This...
=PERCENTILE.EXC(array, k) PERCENTILE.INC
The PERCENTILE.INC function returns the kth percentile of values in a range, where k is a value between 0 and 1,...
=PERCENTILE.INC(array, k) PERCENTRANK.EXC
The PERCENTRANK.EXC function calculates the rank of a value in a data set as a percentage, excluding 0 and 1 from the...
=PERCENTRANK.EXC(array, x, [significance]) PERCENTRANK.INC
The PERCENTRANK.INC function calculates the rank of a value in a data set as a percentage.
=PERCENTRANK.INC(array, x, significance) PERMUT
The PERMUT function calculates the number of permutations for a given number of objects in a set, considering a specific...
=PERMUT(number, number_chosen) PERMUTATIONA
The PERMUTATIONA function calculates the number of permutations for a given number of objects taken from a set with...
=PERMUTATIONA(Number, Number_chosen) PHI
The PHI function in Excel returns the value of the Gaussian function (also known as the standard normal cumulative...
=PHI(Z) POISSON.DIST
The POISSON.DIST function calculates the Poisson probability mass function, which represents the probability of a given...
=POISSON.DIST(x, mean, cumulative) PROB
The PROB function calculates the probability that values in a range are within a specified set of limits or that a...
=PROB(data_range, prob_range, [lower_limit], [upper_limit]) QUARTILE.EXC
The QUARTILE.EXC function is used to calculate the quartile of a dataset at a specified percentile. It is especially...
=QUARTILE.EXC(array, quart) QUARTILE.INC
QUARTILE.INC is an Excel function used to calculate quartiles (values that divide a data set into four equal parts)...
=QUARTILE.INC(array, quart) RANK.AVG
The RANK.AVG function assigns the rank of a specified value in a list of values, with tiebreakers handled by averaging...
=RANK.AVG(number, ref, [order]) RANK.EQ
The RANK.EQ function assigns a rank to a specified value within a list of values, with equal values receiving the same...
=RANK.EQ(number, ref, [order]) RSQ
The RSQ function in Excel is used to calculate the square of the Pearson product-moment correlation coefficient. This...
=RSQ(known_y's, known_x's) SKEW
The SKEW function calculates the skewness of a distribution based on a sample of data. Skewness measures the asymmetry...
=SKEW(number1, [number2, ...]) SKEW.P
The SKEW.P function calculates the skewness of a dataset. Skewness is a measure of the asymmetry of the distribution of...
=SKEW.P(number1, [number2],...) SLOPE
The SLOPE function in Excel is used to calculate the slope of a line based on a given set of data points. It is commonly...
=SLOPE(known_y's, known_x's) SMALL
The SMALL function in Excel is used to extract the nth smallest value from a set of values. It is handy when you need to...
=SMALL(array, k) STANDARDIZE
The STANDARDIZE function is used to normalize a given value by adjusting it based on the mean and standard deviation of...
=STANDARDIZE(x, mean, standard_dev) STDEV.P
The STDEV.P function calculates the standard deviation based on the entire population provided as arguments. It is used...
=STDEV.P(number1, number2, ...) STDEV.S
The STDEV.S function calculates the standard deviation for a sample set of data. It is commonly used in statistics to...
=STDEV.S(number1, [number2, ... ]) STDEVA
The STDEVA function calculates the standard deviation based on a sample, including numbers, text, and logical values,...
=STDEVA(value1, [value2, ...]) STDEVPA
STDEVPA is an Excel function used to calculate the standard deviation based on the entire population given as arguments....
=STDEVPA(number1, [number2, ...]) STEYX
The STEYX function calculates the standard error of the predicted y-values for each x in the regression of a dataset.
=STEYX(known_y's, known_x's) T.DIST
The T.DIST function calculates the probability of a Student's t-distribution, which is commonly used in hypothesis...
=T.DIST(x, degrees_freedom, Cumulative) T.DIST.2T
The T.DIST.2T function calculates the two-tailed probability of a Student's t-distribution. This function is used in...
=T.DIST.2T(x, deg_freedom) T.DIST.RT
The T.DIST.RT function calculates the one-tailed probability of the Student's t-distribution. It is useful in statistics...
=T.DIST.RT(x, degrees_freedom) T.INV
The T.INV function is used to calculate the two-tailed inverse of the Student's t-distribution. It is commonly utilized...
=T.INV(probability, deg_freedom) T.INV.2T
The T.INV.2T function calculates the two-tailed inverse of the Student's t-distribution. It is useful in statistics for...
=T.INV.2T(probability, deg_freedom) T.TEST
Return the p-value of a Student's t-test to check whether two data sets have the same mean.
=T.TEST(array1, array2, tails, type) TREND
The TREND function in Excel is used to predict future values based on existing data points. It calculates the linear...
=TREND(known_y's, known_x's, new_x's, const) TRIMMEAN
The TRIMMEAN function is used to calculate the mean (average) of a dataset after excluding a percentage of data points...
=TRIMMEAN(array, percent) VAR.P
The VAR.P function in Excel is used to calculate the variance of a population based on the entire population data set....
=VAR.P(number1, [number2], [number3], ...) VAR.S
The VAR.S function is used to calculate the variance of a sample dataset. It is commonly used in statistical analysis to...
=VAR.S(number1, [number2, ...]) VARA
The VARA function is used in Excel to calculate the variance of a sample of numbers. It is helpful in statistical...
=VARA(number1, [number2, ...]) VARPA
The VARPA function calculates the variance of a population sample in Excel. It is used to measure the dispersion of...
=VARPA(number1, [number2], [number3], [...]]) WEIBULL.DIST
The WEIBULL.DIST function in Excel calculates the Weibull distribution probability density function or the cumulative...
=WEIBULL.DIST(x, alpha, beta, cumulative) Z.TEST
The Z.TEST function is used to perform a z-test for the null hypothesis that the sample mean is equal to a specified...
=Z.TEST(array, value, [sigma]) Text functions
44 function s
Function Purpose Syntax
ARRAYTOTEXT
The ARRAYTOTEXT function is used to convert an array of values into a delimited text string, which can be useful for...
=ARRAYTOTEXT(array, delimiter, [quoting], [qualifier]) ASC
The ASC function in Excel is used to return the ASCII value of a character. This function is handy when you need to find...
=ASC(text) BAHTTEXT
Convert a number to Thai text in the Thai Baht currency format with BAHTTEXT.
=BAHTTEXT(number) CHAR
The CHAR function is used to return the character specified by a number. This function is commonly used to manipulate...
=CHAR(number) CLEAN
The CLEAN function in Excel is used to remove non-printable characters from a text string. It comes in handy when...
=CLEAN(text) CODE
The CODE function returns a numeric code for the first character in a text string. This function is useful for...
=CODE(text) CONCAT
The CONCAT function is used to combine multiple strings or cell references into a single string. It is a convenient way...
=CONCAT(text1, [text2], ...) CONCATENATE
Join two or more text strings into one with CONCATENATE, though Excel now recommends using CONCAT or TEXTJOIN instead.
=CONCATENATE(text1, [text2], ...) DBCS
The DBCS function is used to determine if a given text string contains double-byte characters (characters that require...
=DBCS(text) DOLLAR
The DOLLAR function converts a number to text using the currency format, with the appropriate currency symbol and commas...
=DOLLAR(number, decimals) EXACT
The EXACT function in Excel is used to compare two text strings for exact equality. It returns TRUE if the strings are...
=EXACT(text1, text2) FIND
Locate the position of a text string inside another text string with Excel's case-sensitive FIND function.
=FIND(substring, text, [start_num]) FINDB
The FINDB function is used to find the starting position of a specified substring within a text string. This function is...
=FINDB(find_text, within_text, [start_num]) FIXED
The FIXED function is used in Excel to format a number as text with a fixed number of decimal places. It is handy when...
=FIXED(number, decimals, no_commas) LEFT
The LEFT function is used to extract a specified number of characters from the left side of a text string. This function...
=LEFT(text, num_chars) LEFTB
Returns a specified number of bytes from the start of a text string in Excel. This function is useful when working with...
=LEFTB(text, num_bytes) LEN
Count the number of characters in a text string.
=LEN(text) LENB
The LENB function returns the number of bytes used to represent a text string. This is particularly useful when working...
=LENB(text) LOWER
The LOWER function converts text to lowercase in Excel. It is useful when you want to standardize text or make it more...
=LOWER(text) MID
Pull characters from the middle of a text string with MID, starting at any position you choose.
=MID(Text, Start_num, Num_chars) MIDB
The MIDB function returns a specific number of characters from the middle of a text string, starting at a specified...
=MIDB(Text, Start_num, Num_chars) NUMBERVALUE
The NUMBERVALUE function is used to convert text representations of numbers into actual numeric values in Excel. It is...
=NUMBERVALUE(text, [decimal_separator], [group_separator]) PROPER
The PROPER function in Excel converts text to proper case by capitalizing the first letter of each word and converting...
=PROPER(text) REGEXEXTRACT
Pull text out of a string using a regular expression pattern. Great for grabbing phone numbers, codes, or anything with...
=REGEXEXTRACT(text, pattern, [return_mode], [case_sensitivity]) REGEXREPLACE
Swap out parts of a text string that match a regular expression pattern. Great for cleaning data, reformatting values,...
=REGEXREPLACE(text, pattern, replacement, [occurrence], [case_sensitivity]) REPLACE
The REPLACE function is used to replace a specific number of characters in a text string, starting at a specified...
=REPLACE(old_text, start_num, num_chars, new_text) REPLACEB
The REPLACEB function is handy for replacing characters in a text string based on byte positions. It allows you to...
=REPLACEB(old_text, start_num, num_bytes, new_text) REPT
The REPT function repeats a text string a specified number of times. This function is handy for creating visual elements...
=REPT(text, number_times) RIGHT
The RIGHT function extracts a specified number of characters from the right side of a text string.
=RIGHT(text, num_chars) RIGHTB
The RIGHTB function returns a specified number of bytes from the end of a text string. This function is particularly...
=RIGHTB(text, num_bytes) SEARCH
The SEARCH function is used to find the position of a substring within a text string. This function is commonly used to...
=SEARCH(find_text, within_text, [start_num]) SEARCHB
The SEARCHB function is used to find the starting position of a substring within a text string, considering double-byte...
=SEARCHB(find_text, within_text, [start_num]) SUBSTITUTE
Replace specific text inside a string with new text using Excel's SUBSTITUTE function, matching by content rather than...
=SUBSTITUTE(text, old_text, new_text, [instance_num]) T
The T function in Excel is used to calculate the Student's t-distribution two-tailed probability.
=T(x, degrees_freedom) TEXT
The TEXT function allows you to format a number and convert it to text, using a specified number format. This function...
=TEXT(Value, Format_text) TEXTAFTER
Return the text that comes after a chosen character or word. Great for splitting strings without nesting MID, FIND, and...
=TEXTAFTER(text, delimiter, [instance_num], [match_mode], [match_end], [if_not_found]) TEXTBEFORE
Return the text that comes before a chosen character or word. Great for splitting strings without nesting LEFT, FIND,...
=TEXTBEFORE(text, delimiter, [instance_num], [match_mode], [match_end], [if_not_found]) TEXTJOIN
The TEXTJOIN function is used to combine multiple text strings into one string, with a specified delimiter separating...
=TEXTJOIN(delimiter, ignore_empty, text1, [text2], ...) TEXTSPLIT
Split text by a delimiter and spill the pieces across columns, rows, or both.
=TEXTSPLIT(text, col_delimiter, [row_delimiter], [ignore_empty], [match_mode], [pad_with]) TRIM
Remove extra spaces from text with Excel's TRIM function, leaving single spaces between words.
=TRIM(text) UNICHAR
The UNICHAR function is used to return the Unicode character that corresponds to the specified numerical value. It is...
=UNICHAR(number) UNICODE
The UNICODE function returns the Unicode value of the first character in a text string. It is commonly used to convert...
=UNICODE(text) UPPER
The UPPER function converts all lowercase letters in a text string to uppercase. It is useful for standardizing text or...
=UPPER(text) VALUE
Convert text that represents a number into a real number.
=VALUE(text) Web functions
2 function s
More functions
23 function s
Function Purpose Syntax
AMORDEGRC
The AMORDEGRC function is used to calculate the prorated depreciation of an asset for a specified accounting period...
=AMORDEGRC(Cost, Date purchase, Date start, Period, [Basis]) CALL
The CALL function in Excel is used to execute a dynamic array formula or array of defined names and return the result.
=CALL(function, arguments) CUBEKPIMEMBER
The CUBEKPIMEMBER function is used to retrieve a key performance indicator (KPI) from a cube in an OLAP database. This...
=CUBEKPIMEMBER(connection, member_unique_name) CUBEMEMBER
The CUBEMEMBER function is used to retrieve a member or tuple from a cube in an Online Analytical Processing (OLAP)...
=CUBEMEMBER(connection, member_expression, [member_unique_name]) CUBEMEMBERPROPERTY
The CUBEMEMBERPROPERTY function retrieves a specified property of a member in a cube. This function is useful when...
=CUBEMEMBERPROPERTY(Connection, Member_Expression, Property) CUBERANKEDMEMBER
The CUBERANKEDMEMBER function is used in Excel for OLAP (Online Analytical Processing) data sources to rank members in a...
=CUBERANKEDMEMBER(Set, Measure, Rank[, Caption]) CUBESET
The CUBESET function is used in Excel to create a calculated set of members or tuples by sending a set expression to the...
=CUBESET(connection, name, caption, expression) CUBESETCOUNT
The CUBESETCOUNT function is used to count the number of items in a set within a cube. This function is part of Excel's...
=CUBESETCOUNT(set) CUBEVALUE
The CUBEVALUE function retrieves data from a cube, which is a set of data arranged and summarized into a...
=CUBEVALUE(connection, member_expression, [tuple]) EUROCONVERT
The EUROCONVERT function converts a currency amount from one European currency to another based on the specified...
=EUROCONVERT(Amount, Source_currency, Target_currency, [Full_precision]) FORECAST.ETS
The FORECAST.ETS function is used to predict a future value or trend based on existing data points. This function is...
=FORECAST.ETS(values, timeline, new_timeline, seasonality, [data], [aggregation]) FORECAST.ETS.CONFINT
The FORECAST.ETS.CONFINT function in Excel is used to calculate the confidence interval for a forecasted value based on...
=FORECAST.ETS.CONFINT(target_date, values, data, probability, confidence_interval) FORECAST.ETS.SEASONALITY
The FORECAST.ETS.SEASONALITY function is utilized to estimate the seasonality of a time series data set. This function...
=FORECAST.ETS.SEASONALITY(values, timeline, data) FORECAST.ETS.STAT
The FORECAST.ETS.STAT function is used in Excel to predict a future value based on a series of existing values. This...
=FORECAST.ETS.STAT(target_date, known_y's, known_x's, new_x's, [seasonality], [data_completion]) FORECAST.LINEAR
The FORECAST.LINEAR function predicts a future value along a linear trend based on existing values. It is commonly used...
=FORECAST.LINEAR(x, known_y's, known_x's) GAMMALN.PRECISE
The GAMMALN.PRECISE function calculates the natural logarithm of the absolute value of the gamma function for a given...
=GAMMALN.PRECISE(number) INFO
The INFO function in Excel is used to retrieve information about the current operating environment or settings within...
=INFO(type_text) ISO.CEILING
The ISO.CEILING function rounds a number up to the nearest integer or multiple of significance based on the ISO...
=ISO.CEILING(number, significance) JIS
The JIS function converts a text string from full-width (double-byte) characters to half-width (single-byte) characters...
=JIS(text) PHONETIC
The PHONETIC function converts a text string into the phonetic (sounds-like) equivalent in English, helping to pronounce...
=PHONETIC(text) REGISTER.ID
The REGISTER.ID function is used to assign a unique sequential identification number to each unique value in a range....
=REGISTER.ID(value_range, [format_text]) RTD
The RTD function is used to retrieve real-time data from a program that supports COM automation. It is commonly used for...
=RTD(ProgID, Server, Topic, Item1, ...) WEBSERVICE
The WEBSERVICE function is used to retrieve data from a web service or API in Excel. It allows users to make HTTP...
=WEBSERVICE(url)