...
| 公式 | 作用 | |||||
|---|---|---|---|---|---|---|
| 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 | 50从文本中删除所有不可打印的字符 |
| 49 | CODE | Text: Returns a numeric code for the first character in a text string | 51返回文本字符串中第一个字符的数字代码 | |||
| 50 | COLUMN | Lookup and reference: Returns the column number of a reference | 52返回引用的列号 | |||
| 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 | 54返回给定数量对象的组合数 | |||
| 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 | 56将实系数和虚系数转换为复数 | |||
| 55 | CONCATENATE | Text: Joins several text items into one text item | 57将多个文本项合并为一个文本项 | |||
| 56 | CONFIDENCE | Compatibility: Returns the confidence interval for a population mean | 58返回总体平均值的置信区间 | |||
| 57 | CONFIDENCE.NORM | Statistical: Returns the confidence interval for a population mean | 59返回总体平均值的置信区间 | |||
| 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 | COSHCOT | Math and trigonometry: Returns the hyperbolic cosine of a number返回数字的双曲余弦 | ||||
| 64 | COTCOTH | Math and trigonometry: Returns the hyperbolic cosine of a number返回角度的余切 | ||||
| 65 | COTHCOUNT | Math and trigonometry: Returns the cotangent of an angleStatistical: 计算参数列表中有多少个数字 | ||||
| 66 | COUNTCOUNTA | Statistical: Counts how many numbers are in the list of arguments计算参数列表中的值数 | ||||
| 67 | COUNTACOUNTBLANK | Statistical: Counts how many values are in the list of arguments计算范围内的空白单元格数 | ||||
| 68 | COUNTBLANKCOUNTIF | Statistical: Counts the number of blank cells within a range统计满足给定条件的范围内的单元格数 | ||||
| 69 | COUNTIFCOUNTIFS | 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 | 292||||
| 291 | TIMEVALUE | Date and time: Converts a time in the form of text to a serial number | 293将文本形式的时间转换为序列号 | |||
| 292 | TINV | Compatibility: Returns the inverse of the Student's t-distribution | 294返回Student-t分布的倒数 | |||
| 293 | TODAY | Date and time: Returns the serial number of today's date | 295返回今天日期的序列号 | |||
| 294 | TRANSPOSE | Lookup and reference: Returns the transpose of an array | 296返回数组的转置 | |||
| 295 | TREND | Statistical: Returns values along a linear trend | 297沿线性趋势返回值 | |||
| 296 | TRIM | Text: Removes spaces from text | 298从文本中删除空格 | |||
| 297 | TRIMMEAN | Statistical: Returns the mean of the interior of a data set | ||||
| 299298 | TRUE | Logical: Returns the logical value TRUE | 300返回逻辑值TRUE | |||
| 299 | TRUNC | Math and trigonometry: Truncates a number to an integer | 301将数字截断为整数 | |||
| 300 | UNICODE | Text: Returns the number (code point) that corresponds to the first character of the text | 302返回与文本的第一个字符对应的数字（代码点） | |||
| 301 | UNIQUE | Lookup and reference: Returns a list of unique values in a list or range | 303返回列表或范围中唯一值的列表 | |||
| 302 | UPPER | Text: Converts text to uppercase | 304将文本转换为大写 | |||
| 303 | VAR.P | Statistical: Calculates variance based on the entire population | 305基于整个总体计算方差 | |||
| 304 | VAR.S | Statistical: Estimates variance based on a sample | 306基于样本估计方差 | |||
| 305 | VARA | 308Statistical: 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 | 309基于整个总体（包括数字、文本和逻辑值）计算方差 | |||
| 308 | WEEKDAY | Date and time: Converts a serial number to a day of the week | 310将序列号转换为一周中的某一天 | |||
| 309 | WEEKNUM | Date and time: Converts a serial number to a number representing where the week falls numerically with a year | 311将序列号转换为一个数字，该数字表示一周与一年的数字一致 | |||
| 310 | WEIBULL.DIST | Statistical: Returns the Weibull distribution | 312返回威布尔分布 | |||
| 311 | WORKDAY | Date and time: Returns the serial number of the date before or after a specified number of workdays | 313返回指定工作日数之前或之后的日期序列号 | |||
| 312 | XNPV | Financial: Returns the net present value for a schedule of cash flows that is not necessarily periodic | 314返回不一定是周期性的现金流明细表的净现值 | |||
| 313 | XOR | Logical: Returns a logical exclusive OR of all arguments | 315返回所有参数的逻辑异或 | |||
| 314 | YEARFRAC | Date and time: Returns the year fraction representing the number of whole days between start_date and end_date 返回表示开始日期和结束日期之间的天数的年份分数 |