Page History

...

5051525456575859292293294295296297298300301302303304305306308309310311312313314315

	公式	作用
1	ABS	Math and trigonometry: Returns the absolute value of a number返回数字的绝对值
2	ACCRINT	Financial: Returns the accrued interest for a security that pays periodic interest返回支付定期利息的证券的应计利息
3	ACOS	Math and trigonometry: Returns the arccosine of a number返回数字的反余弦
4	ACOSH	Math and trigonometry: Returns the inverse hyperbolic cosine of a number返回数字的反双曲余弦
5	ACOT	Math and trigonometry: Returns the arccotangent of a number 返回数字的余切
6	ACOTH	Math and trigonometry: Returns the hyperbolic arccotangent of a number 返回数字的双曲余切
7	AGGREGATE	Math and trigonometry: Returns an aggregate in a list or database返回列表或数据库中的聚合
8	AND	Logical: Returns TRUE if all of its arguments are TRUE 如果其所有参数均为TRUE，则返回TRUE
9	ARABIC	Math and trigonometry: Converts a Roman number to Arabic, as a number 将罗马数字转换为阿拉伯数字
10	ASIN	Math and trigonometry: Returns the arcsine of a number 返回数字的反正弦
11	ASINH	Math and trigonometry: Returns the inverse hyperbolic sine of a number返回数字的反双曲正弦
12	ATAN	Math and trigonometry: Returns the arctangent of a number返回数字的反正切
13	ATAN2	Math and trigonometry: Returns the arctangent from x- and y-coordinates从x坐标和y坐标返回反正切
14	ATANH	Math and trigonometry: Returns the inverse hyperbolic tangent of a number返回数字的反双曲正切
15	AVEDEV	Statistical: Returns the average of the absolute deviations of data points from their mean返回数据点与其平均值的绝对偏差的平均值
16	AVERAGE	Statistical: Returns the average of its arguments返回其参数的平均值
17	AVERAGEA	Statistical: Returns the average of its arguments, including numbers, text, and logical values返回其参数的平均值，包括数字、文本和逻辑值
18	AVERAGEIF	Statistical: Returns the average (arithmetic mean) of all the cells in a range that meet a given criteria返回满足给定条件的范围内所有单元格的平均值（算术平均值）
19	AVERAGEIFS	Statistical: Returns the average (arithmetic mean) of all cells that meet multiple criteria.返回满足多个条件的所有单元格的平均值（算术平均值）
20	BASE	Math and trigonometry: Converts a number into a text representation with the given radix (base)	21	BESSELI	Engineering: Returns the modified Bessel function In(x)将数字转换为具有给定基数（基数）的文本表示形式
21	BESSELI	Engineering: 返回（x）中修改过的贝塞尔函数
22	BESSELJ	Engineering: Returns the Bessel function Jn(x)返回贝塞尔函数Jn（x）
23	BESSELK	Engineering: Returns the modified Bessel function Kn(x) 返回修改后的贝塞尔函数Kn（x）
24	BESSELY	Engineering: Returns the Bessel function Yn(x)返回贝塞尔函数Yn（x）
25	BETA.DIST	Statistical: Returns the beta cumulative distribution function 返回beta累积分布函数
26	BETA.INV	Statistical: Returns the inverse of the cumulative distribution function for a specified beta distribution	27	BETADIST	Compatibility: Returns the beta cumulative distribution function返回指定beta分布的累积分布函数的倒数
27	BETADIST	Compatibility: 返回beta累积分布函数
28	BETAINV	Compatibility: Returns the inverse of the cumulative distribution function for a specified beta distribution返回指定beta分布的累积分布函数的倒数
29	BIN2DEC	Engineering: Converts a binary number to decimal
30	BIN2HEX	Engineering: Converts a binary number to hexadecimal将二进制数转换为十六进制数
31	BIN2OCT	Engineering: Converts a binary number to octal 返回单个项的二项分布概率
32	BINOM.DIST	Statistical: Returns the individual term binomial distribution probability 返回单个项的二项分布概率
33	BINOM.DIST.RANGE	Statistical: Returns the probability of a trial result using a binomial distribution使用二项分布返回试验结果的概率
34	BINOM.INV	Statistical: Returns the smallest value for which the cumulative binomial distribution is less than or equal to a criterion value返回累积二项分布小于或等于标准值的最小值
35	BINOMDIST	Compatibility: Returns the individual term binomial distribution probability 返回单个项的二项分布概率
36	BITAND	Engineering: Returns a 'Bitwise And' of two numbers返回两个数字的“按位And”
37	BITLSHIFT	Engineering: Returns a value number shifted left by shift_amount bits返回按移位量位左移的数值
38	BITOR	Engineering: Returns a bitwise OR of 2 numbers返回2个数字的按位或
39	BITRSHIFT	Engineering: Returns a value number shifted right by shift_amount bits返回按移位量位右移的数值
40	BITXOR	Engineering: Returns a bitwise 'Exclusive Or' of two numbers返回两个数字的按位“异或”
41	CEILING	Math and trigonometry: Rounds a number to the nearest integer or to the nearest multiple of significance将数字舍入为最接近的整数或最接近的有效倍数
42	CHAR	Text: Returns the character specified by the code number返回由代码编号指定的字符
43	CHISQ.DIST	Statistical: Returns the cumulative beta probability density function返回累积贝塔概率密度函数
44	CHISQ.DIST.RT	Statistical: Returns the one-tailed probability of the chi-squared distribution返回卡方分布的单尾概率
45	CHISQ.INV	Statistical: Returns the cumulative beta probability density function返回累积贝塔概率密度函数
46	CHISQ.INV.RT	Statistical: Returns the inverse of the one-tailed probability of the chi-squared distribution
47	CHOOSE	Lookup and reference: Chooses a value from a list of values从值列表中选择一个值
48	CHOOSE	Lookup and reference: Chooses a value from a list of values	49	CLEAN	Text: Removes all nonprintable characters from text	从文本中删除所有不可打印的字符
49	CODE	Text: Returns a numeric code for the first character in a text string	返回文本字符串中第一个字符的数字代码
50	COLUMN	Lookup and reference: Returns the column number of a reference	返回引用的列号
51	COLUMNS	Lookup and reference: Returns the number of columns in a reference
5352	COMBIN	Math and trigonometry: Returns the number of combinations for a given number of objects	返回给定数量对象的组合数
53	COMBINA	Math and trigonometry: Returns the number of combinations with repetitions for a given number of items	55	返回给定项目数的重复组合数
54	COMPLEX	Engineering: Converts real and imaginary coefficients into a complex number	将实系数和虚系数转换为复数
55	CONCATENATE	Text: Joins several text items into one text item	将多个文本项合并为一个文本项
56	CONFIDENCE	Compatibility: Returns the confidence interval for a population mean	返回总体平均值的置信区间
57	CONFIDENCE.NORM	Statistical: Returns the confidence interval for a population mean	返回总体平均值的置信区间
58	CONFIDENCE.T	Statistical: Returns the confidence interval for a population mean, using a Student's t distribution
60	CONVERT	Engineering: Converts a number from one measurement system to another
61	CORREL	Statistical: Returns the correlation coefficient between two data sets
62	COS:使用Student t分布返回总体平均值的置信区间
59	CONVERT	Engineering: 将数字从一个测量系统转换为另一个测量系统
60	CORREL	Statistical: 返回两个数据集之间的相关系数
61	COS	Math and trigonometry: 返回数字的余弦
62	COSH	Math and trigonometry: Returns the cosine of a number 返回数字的双曲余弦
63	COSH COT	Math and trigonometry: Returns the hyperbolic cosine of a number返回数字的双曲余弦
64	COT COTH	Math and trigonometry: Returns the hyperbolic cosine of a number返回角度的余切
65	COTH COUNT	Math and trigonometry: Returns the cotangent of an angleStatistical: 计算参数列表中有多少个数字
66	COUNT COUNTA	Statistical: Counts how many numbers are in the list of arguments计算参数列表中的值数
67	COUNTA COUNTBLANK	Statistical: Counts how many values are in the list of arguments计算范围内的空白单元格数
68	COUNTBLANK COUNTIF	Statistical: Counts the number of blank cells within a range统计满足给定条件的范围内的单元格数
69	COUNTIF COUNTIFS	Statistical: Counts the number of cells within a range that meet the given criteria
70	COUNTIFS	Statistical: Counts the number of cells within a range that meet multiple criteria
71	COVARIANCE.统计满足多个条件的范围内的单元格数
70	COVARIANCE.P	Statistical: Returns covariance, the average of the products of paired deviations
7271	COVARIANCE.S	Statistical: Returns the sample covariance, the average of the products deviations for each data point pair in two data sets
7372	CSC	Math and trigonometry: Returns the cosecant of an angle
7473	CSCH	Math and trigonometry: Returns the hyperbolic cosecant of an angle
7574	CUMIPMT	Financial: Returns the cumulative interest paid between two periods
7675	CUMPRINC	Financial: Returns the cumulative principal paid on a loan between two periods
7776	DATEVALUE	Date and time: Converts a date in the form of text to a serial number
7877	DAY	Date and time: Converts a serial number to a day of the month
7978	DAYS	Date and time: Returns the number of days between two dates
8079	DAYS360	Date and time: Calculates the number of days between two dates based on a 360-day year
8180	DB	Financial: Returns the depreciation of an asset for a specified period by using the fixed-declining balance method
8281	DDB	Financial: Returns the depreciation of an asset for a specified period by using the double-declining balance method or some other method that you specify
8382	DEC2BIN	Engineering: Converts a decimal number to binary
8483	DEC2HEX	Engineering: Converts a decimal number to hexadecimal
8584	DEC2OCT	Engineering: Converts a decimal number to octal
8685	DECIMAL	Math and trigonometry: Converts a text representation of a number in a given base into a decimal number
8786	DEGREES	Math and trigonometry: Converts radians to degrees
8887	DELTA	Engineering: Tests whether two values are equal
8988	DEVSQ	Statistical: Returns the sum of squares of deviations
9089	DOLLARDE	Financial: Converts a dollar price, expressed as a fraction, into a dollar price, expressed as a decimal number
9190	DOLLARFR	Financial: Converts a dollar price, expressed as a decimal number, into a dollar price, expressed as a fraction
9291	EFFECT	Financial: Returns the effective annual interest rate
9392	EOMONTH	Date and time: Returns the serial number of the last day of the month before or after a specified number of months
9493	ERF	Engineering: Returns the error function
9594	ERFC	Engineering: Returns the complementary error function
9695	EVEN	Math and trigonometry: Rounds a number up to the nearest even integer
9796	EXACT	Text: Checks to see if two text values are identical
9897	EXP	Math and trigonometry: Returns e raised to the power of a given number
9998	EXPON.DIST	Statistical: Returns the exponential distribution
10099	EXPONDIST	Compatibility: Returns the exponential distribution
101100	F.DIST	Statistical: Returns the F probability distribution
102101	F.DIST.RT	Statistical: Returns the F probability distribution
103102	F.INV	Statistical: Returns the inverse of the F probability distribution
104103	F.INV.RT	Statistical: Returns the inverse of the F probability distribution
105104	FACTDOUBLE	Math and trigonometry: Returns the double factorial of a number
106105	FALSE	Logical: Returns the logical value FALSE
107106	FDIST	Compatibility: Returns the F probability distribution
108107	FINV	Statistical: Returns the inverse of the F probability distribution
109108	FISHER	Statistical: Returns the Fisher transformation
110109	FISHERINV	Statistical: Returns the inverse of the Fisher transformation
111110	FLOOR	Compatibility: Rounds a number down, toward zero
112111	FORECAST	Statistical: Returns a value along a linear trend
113112	FREQUENCY	Statistical: Returns a frequency distribution as a vertical array
114113	FV	Financial: Returns the future value of an investment
115114	FVSCHEDULE	Financial: Returns the future value of an initial principal after applying a series of compound interest rates
116115	GAMMA.DIST	Statistical: Returns the gamma distribution
117116	GAMMA.INV	Statistical: Returns the inverse of the gamma cumulative distribution
118117	GAMMADIST	Compatibility: Returns the gamma distribution
119118	GAMMAINV	Compatibility: Returns the inverse of the gamma cumulative distribution
120119	GAMMALN	Statistical: Returns the natural logarithm of the gamma function, Γ(x)
121120	GAMMALN.PRECISE	Statistical: Returns the natural logarithm of the gamma function, Γ(x)
122121	GAUSS	Statistical: Returns 0.5 less than the standard normal cumulative distribution
123122	GCD	Math and trigonometry: Returns the greatest common divisor
124123	GEOMEAN	Statistical: Returns the geometric mean
125124	GESTEP	Engineering: Tests whether a number is greater than a threshold value
126125	GROWTH	Statistical: Returns values along an exponential trend
127126	HEX2BIN	Engineering: Converts a hexadecimal number to binary
128127	HEX2DEC	Engineering: Converts a hexadecimal number to decimal
129128	HEX2OCT	Engineering: Converts a hexadecimal number to octal
130129	HOUR	Date and time: Converts a serial number to an hour
131130	HYPGEOM.DIST	Statistical: Returns the hypergeometric distribution
132131	HYPGEOMDIST	Compatibility: Returns the hypergeometric distribution
133132	IMABS	Engineering: Returns the absolute value (modulus) of a complex number
134133	IMAGINARY	Engineering: Returns the imaginary coefficient of a complex number
135134	IMARGUMENT	Engineering: Returns the argument theta, an angle expressed in radians
136135	IMCONJUGATE	Engineering: Returns the complex conjugate of a complex number
137136	IMCOS	Engineering: Returns the cosine of a complex number
138137	IMCOSH	Engineering: Returns the hyperbolic cosine of a complex number
139138	IMCOT	Engineering: Returns the cotangent of a complex number
140139	IMCSC	Engineering: Returns the cosecant of a complex number
141140	IMCSCH	Engineering: Returns the hyperbolic cosecant of a complex number
142141	IMDIV	Engineering: Returns the quotient of two complex numbers
143142	IMEXP	Engineering: Returns the exponential of a complex number
144143	IMLN	Engineering: Returns the natural logarithm of a complex number
145144	IMLOG10	Engineering: Returns the base-10 logarithm of a complex number
146145	IMLOG2	Engineering: Returns the base-2 logarithm of a complex number
147146	IMPOWER	Engineering: Returns a complex number raised to an integer power
148147	IMPRODUCT	Engineering: Returns the product of complex numbers
149148	IMREAL	Engineering: Returns the real coefficient of a complex number
150149	IMSEC	Engineering: Returns the secant of a complex number
151150	IMSECH	Engineering: Returns the hyperbolic secant of a complex number
152151	IMSIN	Engineering: Returns the sine of a complex number
153152	IMSINH	Engineering: Returns the hyperbolic sine of a complex number
154153	IMSQRT	Engineering: Returns the square root of a complex number
155154	IMSUB	Engineering: Returns the difference between two complex numbers
156155	IMSUM	Engineering: Returns the sum of complex numbers
157156	IMTAN	Engineering: Returns the tangent of a complex number
158157	INT	Math and trigonometry: Rounds a number down to the nearest integer
159158	INTERCEPT	Statistical: Returns the intercept of the linear regression line
160159	IPMT	Financial: Returns the interest payment for an investment for a given period
161160	IRR	Financial: Returns the internal rate of return for a series of cash flows
162161	ISBLANK	Information: Returns TRUE if the value is blank
163162	ISEVEN	Information: Returns TRUE if the number is even
164163	ISLOGICAL	Information: Returns TRUE if the value is a logical value
165164	ISNONTEXT	Information: Returns TRUE if the value is not text
166165	ISNUMBER	Information: Returns TRUE if the value is a number
167166	ISODD	Information: Returns TRUE if the number is odd
168167	ISODD	Information: Returns TRUE if the number is odd
169168	ISOWEEKNUM	Date and time: Returns the number of the ISO week number of the year for a given date
170169	ISTEXT	Information: Returns TRUE if the value is text
171170	LCM	Math and trigonometry: Returns the least common multiple
172171	LEFT	Text: Returns the leftmost characters from a text value
173172	LEN	Text: Returns the number of characters in a text string
174173	LINEST	Statistical: Returns the parameters of a linear trend
175174	LN	Math and trigonometry: Returns the natural logarithm of a number
176175	LOG	Math and trigonometry: Returns the logarithm of a number to a specified base
177176	LOG10	Math and trigonometry: Returns the base-10 logarithm of a number
178177	LOGEST	Statistical: Returns the parameters of an exponential trend
179178	LOGNORM.DIST	Statistical: Returns the cumulative lognormal distribution
180179	LOGNORM.INV	Statistical: Returns the inverse of the lognormal cumulative distribution
181180	LOGNORMDIST	Compatibility: Returns the cumulative lognormal distribution
182181	LOWER	Text: Converts text to lowercase
183182	MAX	Statistical: Returns the maximum value in a list of arguments
184183	MAXA	Statistical: Returns the maximum value in a list of arguments, including numbers, text, and logical values
185184	MEDIAN	Statistical: Returns the median of the given numbers
186185	MIN	Statistical: Returns the minimum value in a list of arguments
187186	MINA	Statistical: Returns the smallest value in a list of arguments, including numbers, text, and logical values
188187	MINUTE	Date and time: Converts a serial number to a minute
189188	MIRR	Financial: Returns the internal rate of return where positive and negative cash flows are financed at different rates
190189	MOD	Math and trigonometry: Returns the remainder from division
191190	MODE.MULT	Statistical: Returns a vertical array of the most frequently occurring, or repetitive values in an array or range of data
192191	MODE.SNGL	Statistical: Returns the most common value in a data set
193192	MONTH	Date and time: Converts a serial number to a month
194193	MROUND	Math and trigonometry: Returns a number rounded to the desired multiple
195194	MULTINOMIAL	Math and trigonometry: Returns the multinomial of a set of numbers
196195	NEGBINOM.DIST	Statistical: Returns the negative binomial distribution
197196	NEGBINOMDIST	Compatibility: Returns the negative binomial distribution
198197	NETWORKDAYS	Date and time: Returns the number of whole workdays between two dates
199198	NOMINAL	Financial: Returns the annual nominal interest rate
200199	NORM.DIST	Statistical: Returns the normal cumulative distribution
201200	NORM.INV	Compatibility: Returns the inverse of the normal cumulative distribution
202201	NORM.S.DIST	Statistical: Returns the standard normal cumulative distribution
203202	NORM.S.INV	Statistical: Returns the inverse of the standard normal cumulative distribution
204203	NORMDIST	Compatibility: Returns the normal cumulative distribution
205204	NORMINV	Statistical: Returns the inverse of the normal cumulative distribution
206205	NORMSDIST	Compatibility: Returns the standard normal cumulative distribution
207206	NORMSINV	Compatibility: Returns the inverse of the standard normal cumulative distribution
208207	NOT	Logical: Reverses the logic of its argument
209208	NOW	Date and time: Returns the serial number of the current date and time
210209	NPER	Financial: Returns the number of periods for an investment
211210	NPV	Financial: Returns the net present value of an investment based on a series of periodic cash flows and a discount rate
212211	OCT2DEC	Engineering: Converts an octal number to decimal
213212	OCT2HEX	Engineering: Converts an octal number to hexadecimal
214213	ODD	Math and trigonometry: Rounds a number up to the nearest odd integer
215214	OR	Logical: Returns TRUE if any argument is TRUE
216215	PEARSON	Statistical: Returns the Pearson product moment correlation coefficient
217216	PERMUT	Statistical: Returns the number of permutations for a given number of objects
218217	PERMUTATIONA	Statistical: Returns the number of permutations for a given number of objects (with repetitions) that can be selected from the total objects
219218	PHI	Statistical: Returns the value of the density function for a standard normal distribution
220219	PI	Math and trigonometry: Returns the value of pi
221220	PMT	Financial: Returns the periodic payment for an annuity
222221	POISSON.DIST	Statistical: Returns the Poisson distribution
223222	POWER	Math and trigonometry: Returns the result of a number raised to a power
224223	PPMT	Financial: Returns the payment on the principal for an investment for a given period
225224	PROB	Statistical: Returns the probability that values in a range are between two limits
226225	PRODUCT	Math and trigonometry: Multiplies its arguments
227226	PROPER	Text: Capitalizes the first letter in each word of a text value
228227	PV	Financial: Returns the present value of an investment
229228	QUARTILE.EXC	Statistical: Returns the quartile of the data set, based on percentile values from 0..1, exclusive
230229	QUARTILE.INC	Statistical: Returns the quartile of a data set
231230	QUOTIENT	Math and trigonometry: Returns the integer portion of a division
232231	RAND	Math and trigonometry: Returns a random number between 0 and 1
233232	RANDBETWEEN	Math and trigonometry: Returns a random number between the numbers you specify
234233	RANK.AVG	Statistical: Returns the rank of a number in a list of numbers
235234	RANK.EQ	Statistical: Returns the rank of a number in a list of numbers
236235	RATE	Financial: Returns the interest rate per period of an annuity
237236	REPT	Text: Repeats text a given number of times
238237	RIGHT	Text: Returns the rightmost characters from a text value
239238	ROMAN	Math and trigonometry: Converts an arabic numeral to roman, as text
240239	ROUND	Math and trigonometry: Rounds a number to a specified number of digits
241240	ROUNDDOWN	Math and trigonometry: Rounds a number down, toward zero
242241	ROUNDUP	Math and trigonometry: Rounds a number up, away from zero
243242	ROW	Lookup and reference: Returns the row number of a reference
244243	ROWS	Lookup and reference: Returns the number of rows in a reference
245244	RRI	Financial: Returns an equivalent interest rate for the growth of an investment
246245	RSQ	Statistical: Returns the square of the Pearson product moment correlation coefficient
247246	SEC	Math and trigonometry: Returns the secant of an angle
248247	SECH	Math and trigonometry: Returns the hyperbolic secant of an angle
249248	SECOND	Date and time: Converts a serial number to a second
250249	SERIESSUM	Math and trigonometry: Returns the sum of a power series based on the formula
251250	SIGN	Math and trigonometry: Returns the sign of a number
252251	SIN	Math and trigonometry: Returns the sine of the given angle
253252	SINH	Math and trigonometry: Returns the hyperbolic sine of a number
254253	SKEW	Statistical: Returns the skewness of a distribution
255254	SKEW.P	Statistical: Returns the skewness of a distribution based on a population: a characterization of the degree of asymmetry of a distribution around its mean
256255	SLN	Financial: Returns the straight-line depreciation of an asset for one period
257256	SLOPE	Statistical: Returns the slope of the linear regression line
258257	SMALL	Statistical: Returns the k-th smallest value in a data set
259258	SQRT	Math and trigonometry: Returns a positive square root
260259	SQRTPI	Math and trigonometry: Returns the square root of (number * pi)
261260	STANDARDIZE	Statistical: Returns a normalized value
262261	STDEV.P	Statistical: Calculates standard deviation based on the entire population
263262	STDEV.S	Statistical: Estimates standard deviation based on a sample
264263	STDEVA	Statistical: Estimates standard deviation based on a sample, including numbers, text, and logical values
265264	STDEVP	Compatibility: Calculates standard deviation based on the entire population
266265	STDEVPA	Statistical: Calculates standard deviation based on the entire population, including numbers, text, and logical values
267266	STEYX	Statistical: Returns the standard error of the predicted y-value for each x in the regression
268267	SUBSTITUTE	Text: Substitutes new text for old text in a text string
269268	SUBTOTAL	Math and trigonometry: Returns a subtotal in a list or database
270269	SUM	Math and trigonometry: Adds its arguments
271270	SUMIF	Math and trigonometry: Adds the cells specified by a given criteria, only two params SUMIF(RANGE, CRITERIA)
272271	SUMIFS	Math and trigonometry: Adds the cells in a range that meet multiple criteria, only two params SUMIFS(RANGE, CRITERIA)
273272	SUMPRODUCT	Math and trigonometry: Returns the sum of the products of corresponding array components
274273	SUMSQ	Math and trigonometry: Returns the sum of the squares of the arguments
275274	SUMX2MY2	Math and trigonometry: Returns the sum of the difference of squares of corresponding values in two arrays
276275	SUMX2PY2	Math and trigonometry: Returns the sum of the sum of squares of corresponding values in two arrays
277276	SUMXMY2	Math and trigonometry: Returns the sum of squares of differences of corresponding values in two arrays
278277	SWITCH	Logical: Evaluates an expression against a list of values and returns the result corresponding to the first matching value. If there is no match, an optional default value may be returned.
279278	SYD	Financial: Returns the sum-of-years' digits depreciation of an asset for a specified period
280279	T.DIST	Statistical: Returns the Percentage Points (probability) for the Student t-distribution
281280	T.DIST.2T	Statistical: Returns the Percentage Points (probability) for the Student t-distribution
282281	T.DIST.RT	Statistical: Returns the Student's t-distribution
283282	T.INV	Statistical: Returns the t-value of the Student's t-distribution as a function of the probability and the degrees of freedom
284283	T.INV.2T	Statistical: Returns the inverse of the Student's t-distribution
285284	TAN	Math and trigonometry: Returns the tangent of a number
286285	TANH	Math and trigonometry: Returns the hyperbolic tangent of a number
287286	TBILLEQ	Financial: Returns the bond-equivalent yield for a Treasury bill
288287	TBILLPRICE	Financial: Returns the price per $100 face value for a Treasury bill
289288	TBILLYIELD	Financial: Returns the yield for a Treasury bill
290289	TDIST	Compatibility: Returns the Student's t-distribution
291290	TIME	Date and time: Returns the serial number of a particular time
291	TIMEVALUE	Date and time: Converts a time in the form of text to a serial number	将文本形式的时间转换为序列号
292	TINV	Compatibility: Returns the inverse of the Student's t-distribution	返回Student-t分布的倒数
293	TODAY	Date and time: Returns the serial number of today's date	返回今天日期的序列号
294	TRANSPOSE	Lookup and reference: Returns the transpose of an array	返回数组的转置
295	TREND	Statistical: Returns values along a linear trend	沿线性趋势返回值
296	TRIM	Text: Removes spaces from text	从文本中删除空格
297	TRIMMEAN	Statistical: Returns the mean of the interior of a data set
299298	TRUE	Logical: Returns the logical value TRUE	返回逻辑值TRUE
299	TRUNC	Math and trigonometry: Truncates a number to an integer	将数字截断为整数
300	UNICODE	Text: Returns the number (code point) that corresponds to the first character of the text	返回与文本的第一个字符对应的数字（代码点）
301	UNIQUE	Lookup and reference: Returns a list of unique values in a list or range	返回列表或范围中唯一值的列表
302	UPPER	Text: Converts text to uppercase	将文本转换为大写
303	VAR.P	Statistical: Calculates variance based on the entire population	基于整个总体计算方差
304	VAR.S	Statistical: Estimates variance based on a sample	基于样本估计方差
305	VARA	Statistical: Estimates variance based on a sample, including numbers, text, and logical values
307	VARP	Compatibility: Calculates variance based on the entire population
基于样本估计方差，包括数字、文本和逻辑值
306	VARP	Compatibility: 基于整个总体计算方差
307	VARPA	Statistical: Calculates variance based on the entire population, including numbers, text, and logical values	基于整个总体（包括数字、文本和逻辑值）计算方差
308	WEEKDAY	Date and time: Converts a serial number to a day of the week	将序列号转换为一周中的某一天
309	WEEKNUM	Date and time: Converts a serial number to a number representing where the week falls numerically with a year	将序列号转换为一个数字，该数字表示一周与一年的数字一致
310	WEIBULL.DIST	Statistical: Returns the Weibull distribution	返回威布尔分布
311	WORKDAY	Date and time: Returns the serial number of the date before or after a specified number of workdays	返回指定工作日数之前或之后的日期序列号
312	XNPV	Financial: Returns the net present value for a schedule of cash flows that is not necessarily periodic	返回不一定是周期性的现金流明细表的净现值
313	XOR	Logical: Returns a logical exclusive OR of all arguments	返回所有参数的逻辑异或
314	YEARFRAC	Date and time: Returns the year fraction representing the number of whole days between start_date and end_date 返回表示开始日期和结束日期之间的天数的年份分数

Page tree

Versions Compared

Old Version 3

New Version Current

Key