คู่มือฉบับสมบูรณ์เกี่ยวกับฟังก์ชันใน Excel

Fav

Excel function query

consult (a document etc)

บทนำเกี่ยวกับฟังก์ชันใน Excel:

1. ฟังก์ชัน Excel คือสูตรที่นิยามไว้ล่วงหน้าใน Excel ซึ่งใช้เพื่อทำการคำนวณ การวิเคราะห์ หรือการดำเนินการเฉพาะ

2. ฟังก์ชัน Excel สามารถทำให้กระบวนการคำนวณที่ซับซ้อนง่ายขึ้น และเพิ่มประสิทธิภาพการประมวลผลข้อมูล

3. ประเภทของฟังก์ชันใน Excel:

(1) ฟังก์ชันทางคณิตศาสตร์และตรีโกณมิติ: ดำเนินการคำนวณทางคณิตศาสตร์ เช่น การบวก ลบ คูณ หาร และการหาค่ารากที่สอง

(2) ฟังก์ชันทางสถิติ: ดำเนินการวิเคราะห์ทางสถิติกับข้อมูล เช่น การนับ การรวมผล การคำนวณค่าเฉลี่ย และการหาค่าสูงสุด/ต่ำสุด

(3) ฟังก์ชันข้อความ: ประมวลผลข้อมูลข้อความ เช่น การต่อข้อความ การดึงอักขระ และการเปลี่ยนรูปแบบตัวอักษร

(4) ฟังก์ชันวันที่และเวลา: ประมวลผลข้อมูลวันที่และเวลา เช่น การคืนวันที่ปัจจุบันและการคำนวณความแตกต่างของวันที่

(5) ฟังก์ชันเชิงตรรกะ: ดำเนินการเชิงตรรกะ เช่น การตรวจสอบเงื่อนไข การดำเนินการเชิงตรรกะ AND และการดำเนินการเชิงตรรกะ OR

(6) ฟังก์ชันการค้นหาและอ้างอิง: ค้นหาข้อมูลเฉพาะภายในตารางข้อมูล เช่น การค้นหาแบบแนวตั้งและการค้นหาแบบแนวนอน

(7) ฟังก์ชันฐานข้อมูล: ดำเนินการวิเคราะห์ทางสถิติกับข้อมูลในฐานข้อมูล

(8) หน้าที่ทางการเงิน: ดำเนินการคำนวณทางการเงิน เช่น การคำนวณมูลค่าปัจจุบัน มูลค่าอนาคต และจำนวนเงินที่ต้องชำระ

Excel Compatibility Functions

function (math.)	clarification
BETADIST	Back to Beta Cumulative Distribution Function
BETAINV	Returns the inverse of the cumulative distribution function of the specified Beta distribution
BINOMDIST	Returns the probability value of the binomial distribution
CHIDIST	Return the one-tailed probability of the χ2 distribution
CHIINV	Returns the inverse function of the one-tailed probability of the χ2 distribution
CHITEST	Returns the independence test value
CONFIDENCE	Returns the confidence interval for the overall mean
COVAR	Returns the covariance (the average of the products of pairs of deviations)
CRITBINOM	Returns the minimum value that makes the cumulative binomial distribution less than or equal to the critical value
EXPONDIST	Return to Exponential Distribution
FDIST	Return to F Probability Distribution
FINV	Returns the inverse function of the F probability distribution
FTEST	Return the result of the F-test
GAMMADIST	Back to γ-distribution
GAMMAINV	Returns the inverse function of the gamma cumulative distribution function
HYPGEOMDIST	Return to Hypergeometric Distributions
LOGINV	Returns the inverse function of the logarithmic cumulative distribution function
LOGNORMDIST	Returns the logarithmic cumulative distribution function
MODE	Returns the value with the highest number of occurrences within the dataset
NEGBINOMDIST	Return to Negative Binomial Distribution
NORMDIST	Return to Normal Cumulative Distribution
NORMINV	Returns the inverse function of the standard normal cumulative distribution
NORMSDIST	Return to Standard Normal Cumulative Distribution
NORMSINV	Returns the inverse function of the standard normal cumulative distribution function
PERCENTILE	Returns the kth percentile of values in the region
PERCENTRANK	Returns the percentage ranking of the values in the dataset
POISSON	Return to Poisson distribution
QUARTILE	Return the quartiles of a set of data
RANK	Returns the numerical ranking of a column of numbers
STDEV	Estimation of standard deviation based on sample
STDEVP	Calculate the standard deviation based on the entire sample population
TDIST	Return the t-distribution of students
TINV	Returns the inverse function of the student's t-distribution
TTEST	Returns the probability associated with the student's t-test
VAR	Estimating variance based on samples
VARP	Calculate the variance based on the sample population
WEIBULL	Return to Weibull distribution
ZTEST	Returns the one-tailed probability value of the z-test

Excel multi-dimensional data set function

function (math.)	clarification
CUBEKPIMEMBER	返回重要性能指示器 (KPI) 属性，并在单元格中显示 KPI 名称。KPI是一种用于监控单位绩效的可计量度量值，如每月总利润或季度员工调整。
CUBEMEMBER	Returns a member or tuple in a multidimensional dataset. Used to verify that a member or tuple exists within a multidimensional dataset.
CUBEMEMBERPROPERTY	Returns the value of a member attribute in a multidimensional dataset. Used to verify that a member name exists within a multidimensional dataset and return the specified attribute for that member.
CUBERANKEDMEMBER	返回集合中的第 n 个或排在一定名次的成员。用来返回集合中的一个或多个元素，如业绩最好的销售人员或前10 名的学生。
CUBESET	定义成员或元组的计算集。方法是向服务器上的多维数据集发送一个集合表达式，此表达式创建集合，并随后将该集合返回到Microsoft Excel。
CUBESETCOUNT	Returns the number of items in the collection.
CUBEVALUE	Returns summarized values from a multidimensional dataset.

Excel database functions

function (math.)	clarification
DAVERAGE	Returns the average of the selected database entries
DCOUNT	Calculate the number of cells containing numbers in the database
DCOUNTA	Calculate the number of non-empty cells in the database
DGET	Extracts a single record from the database that meets the specified criteria
DMAX	Returns the maximum value of the selected database entry
DMIN	Returns the minimum value of the selected database entry
DPRODUCT	Multiply the values in specific fields of the eligible records in the database
DSTDEV	Estimated standard deviation based on a sample of selected database entries
DSTDEVP	Calculation of standard deviation based on sample totals of selected database entries
DSUM	Sums the numbers in the field columns of the eligible records in the database
DVAR	Estimation of variance based on a sample of selected database entries
DVARP	Calculation of variance based on sample totals of selected database entries

Excel date and time functions

function (math.)	clarification
DATE	Returns the serial number on a specific date
DATEVALUE	Convert text format dates to serial numbers
DAY	Converting serial numbers to day of month
DAYS360	Number of days in a two-day period based on a 360-day year
EDATE	Returns the serial number of the date used to indicate the number of months before or after the start date
EOMONTH	Returns the sequence number of the last day of the month before or after the specified number of months
HOUR	Converting serial numbers to hours
MINUTE	Converting serial numbers to minutes
MONTH	Convert serial numbers to months
NETWORKDAYS	Number of complete working days in the two-day period of return
NETWORKDAYS.INTL	Returns the number of complete weekday days between two dates (use parameters to indicate how many days are in the weekend and to specify which days)
NOW	Returns the sequence number of the current date and time
SECOND	Converting serial numbers to seconds
TIME	Returns the sequence number at a specific time
TIMEVALUE	Convert text format time to serial number
TODAY	Returns the serial number for today's date
WEEKDAY	Converting serial numbers to day of week dates
WEEKNUM	Convert the serial number to a number that represents the week as the first week of the year
WORKDAY	Returns the serial number for a specified number of business days before or after a date
WORKDAY.INTL	Returns the serial number of the day before or after the specified number of weekday days (use the parameter to indicate how many days are in the weekend and specify which days)
YEAR	Converting serial numbers to years
YEARFRAC	Returns the number of years representing the number of full days between start_date and end_date.

Excel Engineering Functions

function (math.)	clarification
BESSELI	Returns the modified Bessel function In(x)
BESSELJ	Return the Bessel function Jn(x)
BESSELK	Returns the modified Bessel function Kn(x)
BESSELY	Returns the Bessel function Yn(x)
BIN2DEC	Converting Binary Numbers to Decimal Numbers
BIN2HEX	Converting Binary Numbers to Hexadecimal Numbers
BIN2OCT	Converting Binary Numbers to Octal Numbers
COMPLEX	Converting real and imaginary coefficients to complex numbers
CONVERT	Converting numbers from one metric system to another
DEC2BIN	Converting decimal numbers to binary numbers
DEC2HEX	Converting decimal numbers to hexadecimal numbers
DEC2OCT	Converting Decimal Numbers to Octal Numbers
DELTA	Tests whether two values are equal
ERF	Returns the error function
ERF.PRECISE	Returns the error function
ERFC	Return the complementary error function
ERFC.PRECISE	Complementary [ERF] function that returns an integral from x to infinity
GESTEP	Check if the number is greater than the threshold
HEX2BIN	Converting hexadecimal numbers to binary numbers
HEX2DEC	Converting hexadecimal numbers to decimal numbers
HEX2OCT	Converting hexadecimal numbers to octal numbers
IMABS	Returns the absolute value of a complex number (modulus)
IMAGINARY	Returns the imaginary coefficient of a complex number
IMARGUMENT	Returns theta, the angle in radians.
IMCONJUGATE	Returns the conjugate complex of a complex number
IMCOS	Returns the cosine of a complex number
IMDIV	Returns the quotient of two complex numbers
IMEXP	Returns the exponent of a complex number
IMLN	Returns the natural logarithm of a complex number
IMLOG10	Returns the logarithm of a complex number with a base of 10.
IMLOG2	Returns the logarithm of a complex number with base 2.
IMPOWER	Returns an integer power of a complex number
IMPRODUCT	Returns the product of complex numbers from 2 to 255.
IMREAL	Returns the real coefficients of a complex number
IMSIN	Returns the sine of a complex number
IMSQRT	Returns the square root of a complex number
IMSUB	Returns the difference between two complex numbers
IMSUM	Returns the sum of multiple complex numbers
OCT2BIN	Converting octal numbers to binary numbers
OCT2DEC	Converting octal numbers to decimal numbers
OCT2HEX	Converting octal numbers to hexadecimal numbers

Excel Financial Functions

function (math.)	clarification
ACCRINT	Return of accrued interest on bonds with periodic interest payments
ACCRINTM	Return of accrued interest on bonds paying interest at maturity
AMORDEGRC	Returns the depreciated value for each accounting period for which a depreciation factor is used
AMORLINC	Return the depreciated value for each accounting period
COUPDAYBS	Return the number of days between the start of the interest payment period and the settlement date
COUPDAYS	Returns the number of days in the interest payment period that includes the settlement date
COUPDAYSNC	Returns the number of days between the settlement date and the next interest payment date
COUPNCD	Return to the next interest payment date after the settlement date
COUPNUM	Number of times interest payable between settlement date and maturity date is returned
COUPPCD	Return to the last interest payment date prior to the settlement date
CUMIPMT	Return of interest payments accrued between payment periods
CUMPRINC	Return of principal payments accrued on the loan between payment periods
DB	Return the depreciated value of an asset over a given period using the declining fixed-balance approach
DDB	Returns the depreciated value of an asset over a given period, using the double-declining-balance method or other specified methods
DISC	Discount rate for return bonds
DOLLARDE	Converting prices expressed as fractions to prices expressed as decimals
DOLLARFR	Converting prices expressed as decimals into prices expressed as fractions
DURATION	Return to annual maturity of bonds with periodic interest payments
EFFECT	Return to annual effective interest rate
FV	Returning the future value of an investment
FVSCHEDULE	Returns the future value of the initial principal calculated by applying a series of compound interest rates
INTRATE	Return to interest rates for fully invested bonds
IPMT	Returns interest paid on an investment over a given period of time
IRR	Return the internal rate of return for a range of cash flows
ISPMT	Calculation of interest to be paid over a given investment period
MDURATION	Return to Macauley's amendment period for a hypothetical security with a par value of ¥100.
MIRR	Returns the internal rate of return for positive and negative cash flows at different interest rates.
NOMINAL	Nominal interest rate for the year of return
NPER	Number of periods for which investments were returned
NPV	Returns the net present value of an investment based on a series of periodic cash flows and a discount rate.
ODDFPRICE	Return the current price of each bond with a par value of ¥100 and an odd number of first issues.
ODDFYIELD	Returns on bonds with an odd number of first issues
ODDLPRICE	Return the current price of each bond with a par value of ¥100 and an odd number of last issues
ODDLYIELD	Returns on bonds with an odd number of last issues
PMT	Return to periodic payments of annuities
PPMT	Return of principal repaid on an investment over a given period of time
PRICE	Return the current price of each ¥100 bond that pays interest regularly.
PRICEDISC	Returns the current price of each discounted bond with a face value of ¥100.
PRICEMAT	Return the current price of each bond with a par value of ¥100 that pays interest at maturity.
PV	Return to present value of investment
RATE	Return to the interest rate for each period of the annuity
RECEIVED	Return of fully invested bonds to be recovered at maturity
SLN	Return of linear depreciation charge per period on fixed assets
SYD	Return the amount of depreciation per period for a fixed asset based on the sum-of-the-years depreciation method.
TBILLEQ	Return of equivalent bond proceeds on Treasury bills
TBILLPRICE	Returns the price of a Treasury bill with a face value of ￥100.
TBILLYIELD	Returns on Treasury Bills
VDB	Using the declining balance method, return the depreciated value of an asset over a given period or part thereof.
XIRR	Returns the internal rate of return on a set of cash flows that do not necessarily occur on a regular basis
XNPV	Returns the net present value of a set of cash flows that do not necessarily occur on a regular basis
YIELD	Returns on bonds with periodic interest payments
YIELDDISC	Returns the annual return on discounted bonds; for example, short-term Treasury bills
YIELDMAT	Returns the annual return on bonds that pay interest at maturity

Excel information function

function (math.)	clarification
CELL	Returns information about the format, position or content of a cell
ERROR.TYPE	Returns a number corresponding to the type of error
INFO	Returns information about the current operating environment
ISBLANK	If the value is null, return
TRUEISERR	If the value is any error value other than #N/A, return the
TRUEISERROR	If the value is any error value, return
TRUEISEVEN	If the number is even, return
TRUEISLOGICAL	If the value is a logical value, return
TRUEISNA	If the value is the error value #N/A, then return the
TRUEISNONTEXT	If the value is not text, return
TRUEISNUMBER	If the value is a number, return
TRUEISODD	If the number is odd, return
TRUEISREF	If the value is a reference value, return
TRUEISTEXT	If the value is text, return
TRUEN	Returns the value converted to a number
NA	Returns the error value #N/
ATYPE	Returns a number representing the data type of the value

Excel Logic Functions

function (math.)	clarification
AND	If all its arguments are TRUE, it returns
TRUEFALSE	Returns a logical value
FALSEIF	Specify the logical tests to be performed
IFERROR	If the formula's calculation results in an error, return the value you specified; otherwise return the formula's result
NOT	Logical inversion of its parameters
OR	If either parameter is TRUE, then return the
TRUETRUE	Returns the logical value TRUE

Excel find and reference functions

function (math.)	clarification
ADDRESS	Returns referenced values to individual cells in the worksheet as text.
AREAS	Returns the number of regions involved in the reference
CHOOSE	Select a value from the list of values
COLUMN	Returns the referenced column number
COLUMNS	Returns the number of columns contained in the reference
GETPIVOTDATA	Returns the data stored in the pivot table
HLOOKUP	Finds the first row of an array and returns the value of the specified cell
HYPERLINK	Create shortcuts or jumps to open documents stored on a Web server, Intranet, or the Internet.
INDEX	Selecting values from references or arrays using indexes
INDIRECT	Returns a reference specified by a text value
LOOKUP	Finding values in vectors or arrays
MATCH	Finding values in references or arrays
OFFSET	Returns the reference offset from a given reference
ROW	Returns the referenced line number
ROWS	Returns the number of lines in the reference
RTD	从支持 COM 自动化的程序中检索实时数据（注意此function (math.)在 Microsoft Excel Starter 2010中不可用）
TRANSPOSE	Returns the transpose of an array
VLOOKUP	Look in the first column of the array and then move between rows to return the value of the cell

Excel math and trigonometry

function (math.)	clarification
ABS	Returns the absolute value of a number
ACOS	Returns the inverse cosine of a number
ACOSH	Returns the inverse hyperbolic cosine of a number
AGGREGATE	Returns a list or an aggregation from the database
ASIN	Returns the arctangent of a number
ASINH	Returns the inverse hyperbolic sine of a number
ATAN	Returns the arctangent of a number
ATAN2	Returns the arctangent of the X and Y coordinates.
ATANH	Returns the inverse hyperbolic tangent of the number
CEILING	Rounds numbers to the nearest whole number or to the nearest multiple of a specified base number
CEILING.PRECISE	Rounds a number to the nearest integer or the nearest multiple of the specified base. The number is rounded upward regardless of the sign of the number.
COMBIN	Returns the number of combinations of the given number of objects
COS	Returns the cosine of a number
COSH	Returns the hyperbolic cosine of a number
DEGREES	Converting radians to degrees
EVEN	Round numbers up to the nearest even number
EXP	Returns the nth power of e
FACT	Returns the factorial of a number
FACTDOUBLE	Returns the double factorial of a number
FLOOR	Rounding numbers in the direction of decreasing absolute value
FLOOR.PRECISE	Rounds a number down to the nearest integer or the nearest multiple of the specified base. The number is rounded down regardless of the sign of the number.
GCD	Return the greatest common divisor
INT	Round numbers down to the nearest whole number
LCM	Returns the least common multiple
LN	Returns the natural logarithm of a number
LOG	Returns the logarithm of a number with the specified base.
LOG10	Returns the logarithm of a number with a base of 10.
MDETERM	Returns the value of the matrix determinant of the array
MINVERSE	Returns the inverse matrix of an array
MMULT	Returns the matrix product of two arrays
MOD	Returns the remainder of the division
MROUND	Returns a number rounded to the desired multiple
MULTINOMIAL	A polynomial that returns a set of numbers
ODD	Rounding numbers up to the nearest odd number
PI	Returns the value of pi
POWER	Returns the power of a number
PRODUCT	Multiply its parameters
QUOTIENT	Returns the integer part of the division
RADIANS	Converting degrees to radians
RAND	Returns a random number between 0 and 1
RANDBETWEEN	Returns a random number between two specified numbers.
ROMAN	Conversion of Arabic numerals to text-based Roman numerals
ROUND	Round numbers to specified number of places
ROUNDDOWN	Rounding numbers in the direction of decreasing absolute value
ROUNDUP	Rounding numbers in the direction of increasing absolute value
SERIESSUM	Returns the sum of a power series based on the formula
SIGN	Return the sign of the number
SIN	Returns the sine of the given angle
SINH	Returns the hyperbolic sine of a number
SQRT	Returns the positive square root
SQRTPI	Returns the square root of the product of a number and pi.
SUBTOTAL	Returns a list or a summary of categories in the database
SUM	Sum the parameters
SUMIF	Sums up the specified cells according to the given conditions.
SUMIFS	Adding cells to a region that satisfy multiple conditions
SUMPRODUCT	Returns the sum of the products of the corresponding array elements
SUMSQ	Returns the sum of the squares of the arguments
SUMX2MY2	Returns the sum of the squared differences of the corresponding values in the two arrays.
SUMX2PY2	Returns the sum of the squares of the corresponding values in the two arrays.
SUMXMY2	Returns the sum of the squares of the differences of the corresponding values in the two arrays.
TAN	Returns the tangent of a number
TANH	Returns the hyperbolic tangent of the number
TRUNC	truncate and round numbers to the nearest integer

Excel statistical functions

function (math.)	clarification
AVEDEV	Returns the mean of the absolute deviations of the data points from their mean values
AVERAGE	Returns the average of its arguments
AVERAGEA	Returns the average of its arguments, including numeric, text, and logical values
AVERAGEIF	Returns the average (arithmetic mean) of all cells in the region that meet the given conditions
AVERAGEIFS	Returns the average (arithmetic mean) of all cells that satisfy multiple conditions
BETA.DIST	Back to Beta Cumulative Distribution Function
BETA.INV	Returns the inverse of the cumulative distribution function of the specified Beta distribution
BINOM.DIST	Returns the probability value of the binomial distribution
BINOM.INV	Returns the minimum value that makes the cumulative binomial distribution less than or equal to the critical value
CHISQ.DIST	Returns the cumulative Beta probability density function
CHISQ.DIST.RT	Return the one-tailed probability of the χ2 distribution
CHISQ.INV	Returns the cumulative Beta probability density function
CHISQ.INV.RT	Returns the inverse function of the one-tailed probability of the χ2 distribution
CHISQ.TEST	Returns the independence test value
CONFIDENCE.NORM	Returns the confidence interval for the overall mean
CONFIDENCE.T	Return confidence intervals for the overall mean (using students' t-distribution)
CORREL	Returns the correlation coefficient between two data sets
COUNT	Calculate the number of digits in the parameter list
COUNTA	Counts the number of values in the parameter list
COUNTBLANK	Calculate the number of blank cells in a region
COUNTIF	Calculate the number of cells in the region that meet the given conditions
COUNTIFS	Calculate the number of cells in a region that match multiple conditions
COVARIANCE.P	Returns the covariance (the average of the products of pairs of deviations)
COVARIANCE.S	Returns the sample covariance, which is the average of the product of the deviations of each pair of data points in the two data sets
DEVSQ	Returns the sum of the squares of the deviations
EXPON.DIST	Return to Exponential Distribution
F.DIST	Return to F Probability Distribution
F.DIST.RT	Return to F Probability Distribution
F.INV	Returns the inverse function of the F probability distribution
F.INV.RT	Returns the inverse function of the F probability distribution
F.TEST	Return the result of the F-test
FISHER	Return Fisher transformed value
FISHERINV	Returns the inverse function of the Fisher transform
FORECAST	Returns the value along the linear trend
FREQUENCY	Returns the frequency distribution as a vertical array
GAMMA.DIST	Back to γ-distribution
GAMMA.INV	Returns the inverse function of the gamma cumulative distribution function
GAMMALN	returns the natural logarithm of the Γ function, Γ(x)
GAMMALN.PRECISE	returns the natural logarithm of the Γ function, Γ(x)
GEOMEAN	Returns the geometric mean
GROWTH	Returns the value along the exponential trend
HARMEAN	Returns the harmonic mean
HYPGEOM.DIST	Return to Hypergeometric Distributions
INTERCEPT	Return the intercept of the linear regression line
KURT	Returns the peak of the dataset
LARGE	Returns the kth largest value in the data set
LINEST	Returns the parameters of a linear trend
LOGEST	Returns the parameters of the exponential trend
LOGNORM.DIST	Returns the logarithmic cumulative distribution function
LOGNORM.INV	Returns the inverse function of the logarithmic cumulative distribution
MAX	Returns the maximum value in the parameter list
MAXA	Returns the maximum value in the parameter list, including numeric, text and logical values
MEDIAN	Returns the median of the given set of values
MIN	Returns the smallest value in the argument list
MINA	Returns the smallest value in the parameter list, including numbers, text and logical values
MODE.MULT	Returns a vertical array of the most frequent or recurring values in a set of data or data region
MODE.SNGL	Returns the value with the highest number of occurrences within the dataset
NEGBINOM.DIST	Return to Negative Binomial Distribution
NORM.DIST	Return to Normal Cumulative Distribution
NORM.INV	Returns the inverse function of the standard normal cumulative distribution
NORM.S.DIST	Return to Standard Normal Cumulative Distribution
NORM.S.INV	Returns the inverse function of the standard normal cumulative distribution function
PEARSON	Return Pearson product moment correlation coefficient
PERCENTILE.EXC	Returns the kth percentile of a value in a region, where k ranges from 0 to 1 (excluding 0 and 1).
PERCENTILE.INC	Returns the kth percentile of values in the region
PERCENTRANK.EXC	将某个数值在数据集中的排位作为数据集的百分点值返回，此处的百分点值的范围为0 到 1（不含 0 和1）
PERCENTRANK.INC	Returns the percentage ranking of the values in the dataset
PERMUT	Returns the number of permutations of the given number of objects
POISSON.DIST	Return to Poisson distribution
PROB	Returns the probability that a value in the region falls within the specified interval
QUARTILE.EXC	Returns the quartiles of the data set based on percentile values, which in this case range from 0 to 1 (excluding 0 and 1)
QUARTILE.INC	Return the quartiles of a set of data
RANK.AVG	Returns the numerical ranking of a column of numbers
RANK.EQ	Returns the numerical ranking of a column of numbers
RSQ	Returns the square of the Pearson Product Moment Correlation Coefficient
SKEW	Return the asymmetry of the distribution
SLOPE	Return the slope of the linear regression line
SMALL	Returns the kth smallest value in the data set
STANDARDIZE	Returns the normalized value
STDEV.P	Calculate the standard deviation based on the entire sample population
STDEV.S	Estimation of standard deviation based on sample
STDEVA	Estimation of standard deviation based on samples (including numeric, textual and logical values)
STDEVPA	Calculate the standard deviation based on the totality (including numeric, textual and logical values)
STEYX	Returns the standard error generated when predicting the y-value for each x through linear regression
T.DIST	Return the percentile (probability) of the t-distribution of students
T.DIST.2T	Return the percentile (probability) of the student's t-distribution
T.DIST.RT	Return the t-distribution of students
T.INV	Return the t-value of the student t-distribution as a function of probability and degrees of freedom
T.INV.2T	Returns the inverse function of the student's t-distribution
TREND	Returns the value along the linear trend
TRIMMEAN	Returns the internal mean of the data set
T.TEST	Returns the probability associated with the student's t-test
VAR.P	Calculate the variance based on the sample population
VAR.S	Estimating variance based on samples
VARA	Estimating variance based on samples (including numbers, text and logistic values)
VARPA	Calculate the standard deviation based on the totality (including numeric, textual and logical values)
WEIBULL.DIST	Return to Weibull distribution
Z.TEST	Returns the one-tailed probability value of the z-test

Excel text function

function (math.)	clarification
ASC	Change full-width (double-byte) alphabetic or katakana characters in a string to half-width (single-byte) characters
BAHTTEXT	Converting numbers to text using the ß (Thai baht) currency format
CHAR	Returns the character specified by the code number
CLEAN	Remove all non-printing characters from the text
CODE	Returns the numeric code of the first character in a text string
CONCATENATE	Combine several text items into one text item
RMB	Converting numbers to text using the ¥ (RMB) currency format
EXACT	Checks if two text values are the same FIND,
FINDB	Finding a text value within another text value (case sensitive)
FIXED	Formatting numbers as text with a fixed number of decimal places
JIS	Changes a half-width (single-byte) English letter or katakana in a string to the full-width (double-byte) character LEFT,
LEFTB	Returns the leftmost character LEN in the text value,
LENB	Returns the number of characters in a text string
LOWER	Converts text to lowercase MID,
MIDB	Returns a specified number of characters from a specified position in a text string.
PHONETIC	Extract pinyin (Chinese character note) characters from text strings
PROPER	Capitalize the first letter of each word of the text value REPLACE,
REPLACEB	Replacing characters in text
REPT	Repeats the text RIGHT a given number of times,
RIGHTB	Returns the rightmost character SEARCH in the text value,
SEARCHB	Find another text value within a text value (case insensitive)
SUBSTITUTE	Replacing old text with new text in a text string
T	Convert parameters to text
TEXT	Formatting numbers and converting them to text
TRIM	Remove spaces from text
UPPER	Convert text to uppercase
VALUE	Convert text parameters to numbers

Excel user-defined functions

function (math.)	clarification
CALL	Calling a procedure in a dynamic link library or code source
EUROCONVERT	用于将数字转换为欧元形式，将数字由欧元形式转换为欧元成员国货币形式，或利用欧元作为中间货币将数字由某一欧元成员国货币转化为另一欧元成员国货币形式（三角转换关系）
REGISTER.ID	Returns the registration number of the specified Dynamic Link Library (DLL) or code source that has been registered.
SQL.REQUEST	Connect to an external data source and run a query from a worksheet, then return the query results as an array without macro programming.