Excel function summary
Excel functional query
query
Excel function summary Introduction
About Excel functions:1. Excel functions are predefined formulas in Excel that are used to perform specific calculations, analyses, or operations.
2. Excel function can simplify complex calculation process and improve data processing efficiency.
3, Excel function type:(1), mathematics and trigonometric functions: Perform mathematical calculations such as addition, subtraction, multiplication, division, finding square roots, etc.
(2), statistical function: statistical analysis of data, such as counting, summing, average, maximum/minimum, etc.
(3), text function: processing text data, such as merging text, extracting characters, converting case and so on.
(4), date and time function: processes date and time data, such as returning the current date, calculating date differences, etc.
(5), logical function: to make logical judgments, such as conditional judgments, logic and, logic or.
(6), search and reference functions: find specific data in the data table, such as vertical search, horizontal search, and so on.
(7), database function: statistical analysis of database data.
(8), financial function: perform financial calculations, such as calculating present value, future value, payment amount, etc.
excel compatibility function
| function | illustrate |
|---|---|
| BETADIST | returns the beta cumulative distribution function |
| BETAINV | returns the inverse function of the cumulative distribution function of the specified beta distribution |
| BINOMDIST | returns the probability value of the binomial distribution |
| CHIDIST | returns the single-tail probability of the χ2 distribution |
| CHIINV | returns the inverse function of the one-tail probability of the χ2 distribution |
| CHITEST | return the independence test value |
| CONFIDENCE | returns the confidence interval for the population mean |
| COVAR | returns the covariance (average of the product of pairwise deviations) |
| CRITBINOM | returns the minimum value that makes the cumulative binomial distribution less than or equal to the critical value |
| EXPONDIST | return to the exponential distribution |
| FDIST | return to f probability distribution |
| FINV | returns the inverse function of the f probability distribution |
| FTEST | return the results of the f test |
| GAMMADIST | return to γ distribution |
| GAMMAINV | returns the inverse function of the γ cumulative distribution function |
| HYPGEOMDIST | return to the hypergeometric distribution |
| LOGINV | returns the inverse function of the logarithmic cumulative distribution function |
| LOGNORMDIST | returns the logarithmic cumulative distribution function |
| MODE | returns the value that appears most times in the dataset |
| NEGBINOMDIST | returns a negative binomial distribution |
| NORMDIST | return to normal cumulative distribution |
| NORMINV | returns the inverse function of the standard normal cumulative distribution |
| NORMSDIST | returns the standard normal cumulative distribution |
| NORMSINV | returns the inverse function of the standard normal cumulative distribution function |
| PERCENTILE | returns the value of the kth percentage point in the area |
| PERCENTRANK | returns the percentage ranking of values in the dataset |
| POISSON | return to poisson distribution |
| QUARTILE | returns the quartiles of a set of data |
| RANK | returns the numerical ranking of a column of numbers |
| STDEV | estimate standard deviation based on sample |
| STDEVP | calculate standard deviation based on the entire sample population |
| TDIST | return to the student's t distribution |
| TINV | returns the inverse function of the student's t distribution |
| TTEST | returns the probability related to the student's t test |
| VAR | estimate variance based on sample |
| 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 cube function
| function | illustrate |
|---|---|
| CUBEKPIMEMBER | returns the important performance indicator (kpi) attribute and displays the kpi name in the cell. a kpi is a measurable measure used to monitor unit performance, such as total monthly profit or quarterly employee adjustments. |
| CUBEMEMBER | returns a member or tuple in the cube. used to verify whether members or tuples exist within a cube. |
| CUBEMEMBERPROPERTY | returns the value of member attributes in the cube. used to verify that a member name exists in the cube and return the specified attribute of this member. |
| CUBERANKEDMEMBER | returns the nth or member in the set that is ranked. used to return one or more elements in the set, such as the best performing salesperson or the top 10 students. |
| CUBESET | defines the calculation set of members or tuples. the method is to send a collection expression to the cube on the server, which creates the collection and then returns the collection to microsoft excel. |
| CUBESETCOUNT | returns the number of items in the collection. |
| CUBEVALUE | returns summary values from cubes. |
excel database functions
| function | illustrate |
|---|---|
| DAVERAGE | returns the average value of the selected database entry |
| DCOUNT | calculate the number of cells in the database containing numbers |
| DCOUNTA | calculate the number of non-empty cells in the database |
| DGET | extracting 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 a specific field of a record in a database that meets the criteria |
| DSTDEV | estimate standard deviation based on sample of selected database entries |
| DSTDEVP | calculate standard deviation based on sample population of selected database entries |
| DSUM | summarize numbers in the field column of records in the database that meet the criteria |
| DVAR | estimate variance based on sample of selected database entries |
| DVARP | calculate variance based on sample population of selected database entries |
excel date and time functions
| function | illustrate |
|---|---|
| DATE | returns the serial number of a specific date |
| DATEVALUE | convert text format date to serial number |
| DAY | convert serial number to month date |
| DAYS360 | calculate the number of days in two days based on 360 days in a year |
| EDATE | returns the serial number of the date used to represent the number of months before or after the start date |
| EOMONTH | returns the serial number of the last day of the month before or after the specified number of months |
| HOUR | convert serial number to hours |
| MINUTE | convert serial number to minutes |
| MONTH | convert serial number to month |
| NETWORKDAYS | returns the number of days for the full working days during two days |
| NETWORKDAYS.INTL | returns the number of days for the full working day between two dates (using parameters to indicate how many days there are on the weekend and which days it is) |
| NOW | return the serial number of the current date and time |
| SECOND | convert serial number to seconds |
| TIME | returns the serial number of a specific time |
| TIMEVALUE | convert text format time to serial number |
| TODAY | return the serial number of today's date |
| WEEKDAY | convert serial number to sunday date |
| WEEKNUM | convert the serial number to a number that represents the week of the year |
| WORKDAY | returns the serial number of the specified date before or after several working days |
| WORKDAY.INTL | returns the serial number whose date is before or after the specified working day (using parameters to indicate how many days there are on the weekend and which days it is) |
| YEAR | convert serial number to year |
| YEARFRAC | returns the year fraction representing the number of days between start_date and end_date |
excel engineering functions
| function | illustrate |
|---|---|
| BESSELI | returns the corrected besseer function in(x) |
| BESSELJ | return to the besseer function jn(x) |
| BESSELK | returns the corrected besseer function kn(x) |
| BESSELY | return to the besseer function yn(x) |
| BIN2DEC | convert binary numbers to decimal numbers |
| BIN2HEX | convert binary numbers to hexadecimal numbers |
| BIN2OCT | convert binary numbers to octal numbers |
| COMPLEX | convert real and imaginary coefficients to complex numbers |
| CONVERT | convert numbers from one measurement system to another |
| DEC2BIN | convert decimal numbers to binary numbers |
| DEC2HEX | convert decimal numbers to hexadecimal numbers |
| DEC2OCT | convert decimal numbers to octal numbers |
| DELTA | check whether the two values are equal |
| ERF | return the error function |
| ERF.PRECISE | return the error function |
| ERFC | returns the complementary error function |
| ERFC.PRECISE | returns the complementary [erf] function from x to infinity integral |
| GESTEP | check if the number is greater than the threshold |
| HEX2BIN | convert hexadecimal number to binary number |
| HEX2DEC | convert hexadecimal number to decimal number |
| HEX2OCT | convert hexadecimal number to octal number |
| IMABS | returns the absolute value of complex numbers (modulus) |
| IMAGINARY | returns the virtual coefficient of complex numbers |
| IMARGUMENT | return the parameter theta, that is, the angle represented in radians |
| IMCONJUGATE | returns the conjugated complex number of complex numbers |
| IMCOS | returns the complex cosine |
| IMDIV | returns two plural quotients |
| IMEXP | returns the complex exponent |
| IMLN | returns the natural logarithm of complex numbers |
| IMLOG10 | returns the logarithm of the complex number with base 10 |
| IMLOG2 | returns the logarithm of the complex number with base 2 |
| IMPOWER | returns the integer power of complex numbers |
| IMPRODUCT | returns the product of complex numbers from 2 to 255 |
| IMREAL | returns the real coefficient of complex numbers |
| IMSIN | returns the complex sine |
| IMSQRT | returns the square root of the complex number |
| IMSUB | returns the difference between two complex numbers |
| IMSUM | returns the sum of multiple plural numbers |
| OCT2BIN | convert octal numbers to binary numbers |
| OCT2DEC | convert octal numbers to decimal numbers |
| OCT2HEX | convert octal numbers to hexadecimal numbers |
excel financial functions
| function | illustrate |
|---|---|
| ACCRINT | returns the accrued interest on the bonds that pay interest regularly |
| ACCRINTM | returns the accrued interest on the bonds that pay interest on the maturity date |
| AMORDEGRC | returns the depreciation value for each accounting period using the depreciation coefficient |
| AMORLINC | returns the depreciation value for each accounting period |
| COUPDAYBS | returns the number of days from the start of the interest payment period to the settlement date |
| COUPDAYS | returns the number of days of interest payment including settlement date |
| COUPDAYSNC | returns the number of days from settlement date to the next interest payment date |
| COUPNCD | return to the next interest payment date after the settlement date |
| COUPNUM | returns the number of interest payable between the settlement date and the expiration date |
| COUPPCD | return to the previous interest payment date before the settlement date |
| CUMIPMT | returns the accumulated interest paid between two payment periods |
| CUMPRINC | returns the principal paid for the loan between two payment periods |
| DB | use the fixed balance decrement method to return the depreciation value of an asset over a given period |
| DDB | use double decreasing balance method or other specified method to return the depreciation value of an asset over a given period |
| DISC | return to the discount rate of the bond |
| DOLLARDE | convert a price expressed in fractions to a price expressed in decimals |
| DOLLARFR | convert a price expressed in a decimal to a price expressed in a fraction |
| DURATION | returns the annual term of bonds that pay interest regularly |
| EFFECT | return to the annual effective interest rate |
| FV | return the future value of an investment |
| FVSCHEDULE | returns the future value of the initial principal calculated using a series of compound interest rates |
| INTRATE | return interest rates for fully invested bonds |
| IPMT | returns the interest paid for an investment over a given period |
| IRR | returns the internal rate of return on a series of cash flows |
| ISPMT | calculate the interest to be paid during a specific investment period |
| MDURATION | returns the macauley correction period for securities with a face value of rmb 100 |
| MIRR | returns internal rate of return calculated at different interest rates for positive and negative cash flows |
| NOMINAL | return to the nominal interest rate for the year |
| NPER | return the number of investment periods |
| NPV | returns the net present value of the investment calculated based on a series of periodic cash flows and discount rates |
| ODDFPRICE | return the current price of each bond with a face value of rmb 100 and the first period is an odd number |
| ODDFYIELD | returns the first period of the bonds with odd numbers |
| ODDLPRICE | return the current price of each bond with a face value of rmb 100 and the last period is an odd number |
| ODDLYIELD | returns the yield of the last odd bond |
| PMT | recurring payment amount returned to annuity |
| PPMT | returns the principal repaid for an investment over a given period |
| PRICE | return to the current price of each bond with a face value of rmb 100 and interest paid regularly |
| PRICEDISC | return to the current price of discounted bonds with a face value of rmb 100 |
| PRICEMAT | return the current price of each bond with a face value of rmb 100 and interest paid on the maturity date |
| PV | return the current value of the investment |
| RATE | return to the interest rate for each period of the annuity |
| RECEIVED | returns the amount recovered by the fully invested bond on the maturity date |
| SLN | returns the linear depreciation fee per period of fixed assets |
| SYD | returns the depreciation amount for each period calculated by the sum of years of a fixed asset |
| TBILLEQ | return to treasury bills equivalent bonds |
| TBILLPRICE | return to the price of treasury bills with a face value of rmb 100 |
| TBILLYIELD | return to treasury bills |
| VDB | use the decrement method to return the depreciation value of an asset over a given period or part of the period |
| XIRR | returns the internal rate of return of a set of cash flows that do not necessarily occur regularly |
| XNPV | returns the net present value of a set of cash flows that do not necessarily occur regularly |
| YIELD | returns the proceeds of bonds that pay interest regularly |
| YIELDDISC | returns annual returns on discounted bonds; for example, short-term treasury bonds |
| YIELDMAT | returns annual earnings for bonds that pay interest on maturity date |
excel information function
| function | illustrate |
|---|---|
| CELL | returns information about cell format, location, or content |
| ERROR.TYPE | returns the number corresponding to the error type |
| INFO | return information about the current operating environment |
| ISBLANK | if the value is empty, return |
| TRUEISERR | if the value is any error value other than #n/a, return |
| 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, return |
| 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 the number of data type that represents the value |
excel logical functions
| function | illustrate |
|---|---|
| AND | if all its parameters are true, return |
| TRUEFALSE | return logical value |
| FALSEIF | specify the logical detection to be performed |
| IFERROR | if the formula's calculation result is wrong, the value you specified will be returned; otherwise, the result of the formula will be returned. |
| NOT | inverse the logic of its parameters |
| OR | if either parameter is true, return |
| TRUETRUE | return the logical value true |
excel search and reference functions
| function | illustrate |
|---|---|
| ADDRESS | return referenced values in text to a single cell of the worksheet |
| AREAS | returns the number of regions involved in the reference |
| CHOOSE | select a value from the list of values |
| COLUMN | return the referenced column number |
| COLUMNS | returns the number of columns contained in the reference |
| GETPIVOTDATA | returns the data stored in the pivot table |
| HLOOKUP | find the first row of the array and return the value of the specified cell |
| HYPERLINK | create a shortcut or jump to open documents stored on a web server, intranet, or the internet |
| INDEX | use index to select a value from a reference or array |
| INDIRECT | returns the reference specified by the text value |
| LOOKUP | find values in vectors or arrays |
| MATCH | find values in reference or array |
| OFFSET | returns the reference offset from the given reference |
| ROW | return the referenced line number |
| ROWS | returns the number of rows in the reference |
| RTD | retrieve real-time data from a program that supports com automation (note this function is not available in microsoft excel starter 2010) |
| TRANSPOSE | returns the transposition of the array |
| VLOOKUP | find in the first column of the array and move between rows to return the value of the cell |
excel mathematics and trigonometric functions
| function | illustrate |
|---|---|
| ABS | return the absolute value of the number |
| ACOS | returns the inverse cosine value of the number |
| ACOSH | returns the inverse hyperbolic cosine value of the number |
| AGGREGATE | return to the aggregation in a list or database |
| ASIN | returns the inverse sine value of the number |
| ASINH | returns the inverse hyperbolic sine value of the number |
| ATAN | returns the arctangent value of the number |
| ATAN2 | returns the arctangent value of x and y coordinates |
| ATANH | returns the inverse hyperbolic tangent of the number |
| CEILING | round the number to the nearest integer or multiple of the specified cardinality |
| CEILING.PRECISE | round the number to the nearest integer or multiple of the specified cardinality. regardless of the symbol of the number, the number is rounded upward. |
| COMBIN | returns the number of combinations of objects for a given number |
| COS | returns the cosine value of the number |
| COSH | returns the hyperbolic cosine value of the number |
| DEGREES | convert radians to degrees |
| EVEN | round the number up to the nearest even number |
| EXP | return to the n power of e |
| FACT | return the factorial of the number |
| FACTDOUBLE | return the double factor of the number |
| FLOOR | round the number in the direction of the absolute value decreasing |
| FLOOR.PRECISE | round the number down to the nearest integer or multiple of the specified cardinality. regardless of the symbol of the number, the number is rounded downward. |
| GCD | return the maximum common divisor |
| INT | round the number down to the nearest integer |
| LCM | return the minimum common multiple |
| LN | returns the natural logarithm of the number |
| LOG | returns the logarithm of the number with the specified base |
| LOG10 | returns the logarithm of the number with base 10 |
| MDETERM | returns the value of the matrix determinant of the array |
| MINVERSE | returns the inverse matrix of the array |
| MMULT | returns the matrix product of two arrays |
| MOD | returns the remainder of division |
| MROUND | returns a number rounded to the desired multiple |
| MULTINOMIAL | returns a polynomial of a set of numbers |
| ODD | round the number up to the nearest odd number |
| PI | returns the value of pi |
| POWER | return the power of the number |
| PRODUCT | multiply its parameters |
| QUOTIENT | returns the integer part of division |
| RADIANS | convert degrees to radians |
| RAND | returns a random number between 0 and 1 |
| RANDBETWEEN | returns a random number between two specified numbers |
| ROMAN | convert arabic numerals to textual roman numerals |
| ROUND | round the number by the specified number of digits |
| ROUNDDOWN | round the number in the direction of the absolute value decreasing |
| ROUNDUP | round the number in the direction of the absolute value increasing |
| SERIESSUM | returns the sum of power series based on formula |
| SIGN | returns the symbol of the number |
| SIN | returns the sine value of the given angle |
| SINH | returns the hyperbolic sine value of the number |
| SQRT | return to the positive square root |
| SQRTPI | returns the square root of the product of a certain number and pi |
| SUBTOTAL | returns a summary of categories in a list or database |
| SUM | find the sum of parameters |
| SUMIF | summarize the specified cells by the given conditions |
| SUMIFS | add cells in the area that meet multiple criteria |
| SUMPRODUCT | returns the product sum of the corresponding array elements |
| SUMSQ | returns the sum of squares of parameters |
| SUMX2MY2 | returns the sum of the squared values in two arrays |
| SUMX2PY2 | returns the sum of squares of the corresponding values in two arrays |
| SUMXMY2 | returns the sum of squares of the corresponding value difference in two arrays |
| TAN | returns the tangent value of the number |
| TANH | returns the hyperbolic tangent value of the number |
| TRUNC | censor the number |
excel statistics function
| function | illustrate |
|---|---|
| AVEDEV | returns the absolute deviation average of data points from their average |
| AVERAGE | returns the average value of its parameters |
| AVERAGEA | returns the average value of its parameters, including numeric, text, and logical values |
| AVERAGEIF | returns the average value (arithmic average) of all cells in the area that meet the given condition |
| AVERAGEIFS | returns the average value of all cells that meet multiple criteria (arithmic average) |
| BETA.DIST | returns the beta cumulative distribution function |
| BETA.INV | returns the inverse function 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 | returns the single-tail probability of the χ2 distribution |
| CHISQ.INV | returns the cumulative beta probability density function |
| CHISQ.INV.RT | returns the inverse function of the one-tail probability of the χ2 distribution |
| CHISQ.TEST | return the independence test value |
| CONFIDENCE.NORM | returns the confidence interval for the population mean |
| CONFIDENCE.T | return confidence intervals for the population mean (using student's t distribution) |
| CORREL | returns the correlation coefficient between two datasets |
| COUNT | calculate the number of numbers in the parameter list |
| COUNTA | calculate the number of values in the parameter list |
| COUNTBLANK | calculate the number of blank cells in the area |
| COUNTIF | calculate the number of cells in the area that meet the given conditions |
| COUNTIFS | calculate the number of cells in the area that meet multiple criteria |
| COVARIANCE.P | returns the covariance (average of the product of pairwise deviations) |
| COVARIANCE.S | returns the sample covariance, i.e. the average value of the deviation product of each pair of data points in two data sets |
| DEVSQ | returns the sum of squares of deviations |
| EXPON.DIST | return to the 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 results of the f test |
| FISHER | returns fisher transform value |
| FISHERINV | returns the inverse function of fisher transformation |
| FORECAST | returns the value along the linear trend |
| FREQUENCY | returns the frequency distribution as a vertical array |
| GAMMA.DIST | return to γ distribution |
| GAMMA.INV | returns the inverse function of the γ 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 average |
| HYPGEOM.DIST | return to the hypergeometric distribution |
| INTERCEPT | return the intercept of the linear regression line |
| KURT | returns the peak value of the dataset |
| LARGE | returns the kth maximum value in the dataset |
| LINEST | returns the parameters of 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 value of the given set of numeric values |
| MIN | returns the minimum value in the parameter list |
| MINA | returns the minimum value in the parameter list, including numeric, text, and logical values |
| MODE.MULT | returns a vertical array of values with the highest frequency or repeated occurrences in a set of data or data areas |
| MODE.SNGL | returns the value that appears most times in the dataset |
| NEGBINOM.DIST | returns a 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 | returns the standard normal cumulative distribution |
| NORM.S.INV | returns the inverse function of the standard normal cumulative distribution function |
| PEARSON | returns the pearson product moment correlation coefficient |
| PERCENTILE.EXC | returns the kth percentile value of the value in a certain area, where k ranges from 0 to 1 (excluding 0 and 1) |
| PERCENTILE.INC | returns the value of the kth percentage point in the area |
| PERCENTRANK.EXC | returns the ranking of a value in the dataset as the percentage point value of the dataset, where the percentage point value ranges from 0 to 1 (excluding 0 and 1) |
| PERCENTRANK.INC | returns the percentage ranking of values in the dataset |
| PERMUT | returns the number of permutations for a given number of objects |
| POISSON.DIST | return to poisson distribution |
| PROB | returns the probability that the value in the area falls within the specified interval |
| QUARTILE.EXC | returns the quartile of the dataset based on the percentage point value, where the percentage point value ranges from 0 to 1 (excluding 0 and 1) |
| QUARTILE.INC | returns 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 | returns the asymmetry of the distribution |
| SLOPE | return the slope of the linear regression line |
| SMALL | returns the kth minimum value in the dataset |
| STANDARDIZE | returns normalized value |
| STDEV.P | calculate standard deviation based on the entire sample population |
| STDEV.S | estimate standard deviation based on sample |
| STDEVA | estimate standard deviation based on samples (including numbers, text, and logical values) |
| STDEVPA | calculate standard deviation based on population (including numerical, text, and logical values) |
| STEYX | returns the standard error generated when predicting the y value of each x by linear regression |
| T.DIST | returns the percentage point of the student's t distribution (probability) |
| T.DIST.2T | returns the percentage point of the student's t distribution (probability) |
| T.DIST.RT | return to the student's t distribution |
| T.INV | returns the t value of the student's 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 average of the dataset |
| T.TEST | returns the probability related to the student's t test |
| VAR.P | calculate the variance based on the sample population |
| VAR.S | estimate variance based on sample |
| VARA | estimate variance based on samples (including numbers, text, and logical values) |
| VARPA | calculate standard deviations based on populations, including numbers, text, and logical values |
| WEIBULL.DIST | return to weibull distribution |
| Z.TEST | returns the one-tailed probability value of the z test |
excel text functions
| function | illustrate |
|---|---|
| ASC | change the full-width (double-byte) english letters or katakana in a string to half-width (single-byte) characters |
| BAHTTEXT | convert numbers to text using ß (thai baht) currency format |
| CHAR | returns the character specified by the code number |
| CLEAN | delete all non-print characters in the text |
| CODE | returns the numeric code for the first character in the text string |
| CONCATENATE | merge several text items into one text item |
| RMB | convert numbers to text using rmb (rmb) currency format |
| EXACT | check whether the two text values are the same find, |
| FINDB | find another text value in one text value (case sensitive) |
| FIXED | set number format to text with fixed decimal places |
| JIS | change half-width (single byte) english letters or katakana in a string to full-width (double byte) characters left, |
| LEFTB | returns the leftmost character len in the text value, |
| LENB | returns the number of characters in the text string |
| LOWER | convert text to lowercase mid, |
| MIDB | returns a specific number of characters from a specified position in the text string |
| PHONETIC | extract pinyin (chinese character pronunciation) characters in text strings |
| PROPER | capitalize the initial letter of each word of the text value replace, |
| REPLACEB | replace characters in text |
| REPT | repeat text by a given number of times, |
| RIGHTB | returns the rightmost character search in the text value, |
| SEARCHB | find another text value in one text value (case insensitive) |
| SUBSTITUTE | replace old text with new text in text string |
| T | convert parameters to text |
| TEXT | format numbers and convert them to text |
| TRIM | delete spaces in text |
| UPPER | convert text to capitalization |
| VALUE | convert text parameters to numbers |
excel user-defined functions
| function | illustrate |
|---|---|
| CALL | calling a process in a dynamic link library or code source |
| EUROCONVERT | used to convert numbers into euro form, convert numbers from euro form to euro member currency form, or use the euro as an intermediate currency to convert numbers from one euro member currency to another euro member currency (triangle conversion relationship) |
| REGISTER.ID | returns the registered 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 the query from the worksheet, and return the query results as an array without macro programming |
Internet Business Promoter
![alipay incoming sound generator]()
alipay incoming sound generator
generate any amount of alipay incoming sound effects, you can download it for notification or alarm ringtones.
![Stroke number to Chinese character]()
Stroke number to Chinese character
Find the matching Chinese character by stroke count
![Curtain Calculator]()
Curtain Calculator
Quickly calculate the fabric data required for the curtain
![Online Calculator]()
Online Calculator
A convenient and efficient online calculator
![PX batch turn REM tool in CSS]()
PX batch turn REM tool in CSS
Batch convert PX units in CSS code to REM units
![File Hash]()
File Hash
online file Hash calculation tool
![RGB/ hex conversion]()
RGB/ hex conversion
RGB/HEX color conversion tool
![HTML/ASP Interconversion tool]()
HTML/ASP Interconversion tool
Online HTML code and ASP Interconversion tool
![HTML/UBB Interconversion tool]()
HTML/UBB Interconversion tool
Online HTML and UBB code conversion tool
![htpasswd generated online]()
htpasswd generated online
Different types of htpasswd encrypted content can be generated online
![placeholder picture generator]()
placeholder picture generator
A free tool for generating placeholder images online
![IP/ digital conversion]()
IP/ digital conversion
IPV4 address and numeric type IP translation
![Electronic wooden fish]()
Electronic wooden fish
Online artifact of merit
![IP address, Subnet mask calculator]()
IP address, Subnet mask calculator
Network and IP address calculator, submask calculator
![PHP function reference table]()
PHP function reference table
PHP online function reference list
![PornHub style logo generation tool]()
PornHub style logo generation tool
Generate Pornhub-style Logo picture online
![Rabbit Encryption and decryption Tool]()
Rabbit Encryption and decryption Tool
Rabbit Online Encryption Tool /Rabbit Online decryption Tool
![]()
![RIPEMD160 hash encryption]()
RIPEMD160 hash encryption
RIPEMD160 hash encryption online processor
![Half Angle/full Angle conversion]()
Half Angle/full Angle conversion
full-angle symbol and half-angle symbol conversion tool
![Speed converter]()
Speed converter
Speed online converter
![SVG to Base64]()
SVG to Base64
Convert SVG image to Base64 format online
![Text Add line number tool]()
Text Add line number tool
Add line numbers to text online tool
![Due Date Calculator]()
Due Date Calculator
Due date calculator, so that you can easily, conveniently and quickly calculate accurate due date
