The custom width of the image in pixels.
In a list or database, DSUM provides the sum of the numbers in fields (columns) of records that match your specified conditions.
Returns the week number of a specific date. For example, the week containing January 1 is the first week of the year, and is numbered week 1. There are two systems used for this function:
Returns the natural logarithm of a complex number in x + yi or x + yj text format.
Returns the cosecant of a complex number in x+yi or x+yj text format.
Tests whether two values are equal. Returns 1 if number1 = number2; returns 0 otherwise. Use this function to filter a set of values. For example, by summing several DELTA functions you calculate the count of equal pairs. This function is also known as the Kronecker Delta function.
The function described in this Help topic converts half-width (single-byte) letters within a character string to full-width (double-byte) characters. The name of the function (and the characters that it converts) depends upon your language settings. For Japanese, this function changes half-width (single-byte) English letters or katakana within a character string to full-width (double-byte) characters.
Returns the modified Bessel function, which is equivalent to the Bessel function evaluated for purely imaginary arguments.
Returns a number that is rounded down to the nearest integer or to the nearest multiple of significance. Regardless of the sign of the number, the number is rounded down. However, if the number or the significance is zero, zero is returned.
Converts an octal number to decimal.
Returns the number (code point) corresponding to the first character of the text.
Returns the row number of a reference.
Estimates standard deviation based on a sample. The standard deviation is a measure of how widely values are dispersed from the average value (the mean).
Applies a LAMBDA function to each column and returns an array of the results
Returns the normal distribution for the specified mean and standard deviation. This function has a very wide range of applications in statistics, including hypothesis testing. If mean or standard_dev is nonnumeric, NORM.DIST returns the #VALUE! error value.
Use the NOT function, one of the logical functions, when you want to make sure one value is not equal to another. One common use for the NOT function is to expand the usefulness of other functions that perform logical tests. For example, the IF function performs a logical test and then returns one value if the test evaluates to TRUE and another value if the test evaluates to FALSE. By using the NOT function as the logical_test argument of the IF function, you can test many different conditions instead of just one.
Extracts a single value from a column of a list or database that matches conditions that you specify.
WRAPROWS function
Returns number rounded up, away from zero, to the nearest multiple of significance. For example, if you want to avoid using pennies in your prices and your product is priced at $4.42, use the formula =CEILING(4.42,0.05) to round prices up to the nearest nickel.
Returns the cumulative interest paid on a loan between start_period and end_period.
Returns TRUE if number is even, or FALSE if number is odd.
Returns TRUE if number is odd, or FALSE if number is even.
REGEXTEST Function
Compares two text strings and returns TRUE if they are exactly the same, FALSE otherwise. EXACT is case-sensitive but ignores formatting differences. Use EXACT to test text being entered into a document.
The MAXIFS function returns the maximum value among cells specified by a given set of conditions or criteria: numbers, dates, text, etc. This feature is available on Windows or Mac if you have Office 2019, or if you have a Microsoft 365 subscription. If you are a Microsoft 365 subscriber, make sure you have the latest version of Office.
Use the COUNTBLANK function, one of the Statistical functions, to count the number of empty cells in a range of cells.
Returns a random integer number between the numbers you specify. A new random integer number is returned every time the worksheet is calculated.
Repeats text a given number of times. Use REPT to fill a cell with a number of instances of a text string.
Returns the inverse hyperbolic tangent of a number. Number must be between -1 and 1 (excluding -1 and 1). The inverse hyperbolic tangent is the value whose hyperbolic tangent is number, so ATANH(TANH(number)) equals number.
Removes all nonprintable characters from text. Use CLEAN on text imported from other applications that contains characters that may not print with your operating system. For example, you can use CLEAN to remove some low-level computer code that is frequently at the beginning and end of data files and cannot be printed.
Returns the depreciation of an asset for a specified period using the double-declining balance method or some other method you specify.
Returns the depreciation of an asset for a specified period using the fixed-declining balance method.
The FLOOR function in Excel rounds a specified number down to the nearest specified multiple of significance. Negative numbers are rounded down (further negative) to nearest whole multiple below zero.
Returns the modified internal rate of return for a series of periodic cash flows. MIRR considers both the cost of the investment and the interest received on reinvestment of cash.
Returns the nominal annual interest rate, given the effective rate and the number of compounding periods per year.
Returns an equivalent interest rate for the growth of an investment.
Scan the array by column. By default, the array is scanned by row. Scanning determines whether the values are ordered by row or by column.
Returns an array formed by 'mapping' each value in the array(s) to a new value by applying a lambda to create a new value
Returns the cumulative principal paid on a loan between start_period and end_period.
Learn about the RANDARRAY function for creating arrays of random numbers between 0 and 1. RANDARRAY is in a class of functions called dynamic arrays.
Returns a member or tuple from the cube. Use to validate that the member or tuple exists in the cube.
The MINIFS function returns the minimum value among cells specified by a given set of conditions or criteria.
The TREND function returns values along a linear trend. It fits a straight line (using the method of least squares) to the array's known_y's and known_x's. TREND returns the y-values along that line for the array of new_x's that you specify.
Returns the gamma distribution. You can use this function to study variables that may have a skewed distribution. The gamma distribution is commonly used in queuing analysis. This function is provided for backward compatibility; consider using the GAMMA.DIST function instead.
Returns the complementary ERF function integrated between x and infinity.
The BETAINV functionr eturns the inverse of the cumulative beta probability density function for a specified beta distribution.
Returns the double factorial of a number.
Returns covariance, the average of the products of deviations for each data point pair in two data sets. Use covariance to determine the relationship between two data sets. For example, you can examine whether greater income accompanies greater levels of education.
Returns the arctangent, or inverse tangent, of a number. The arctangent is the angle whose tangent is number. The returned angle is given in radians in the range -pi/2 to pi/2.
Converts a hexadecimal number to decimal.
Returns a bitwise 'AND' of two numbers.
Returns the confidence interval for a population mean, using a normal distribution. The confidence interval is a range of values. Your sample mean, x, is at the center of this range and the range is x ± CONFIDENCE. For example, if x is the sample mean of delivery times for products ordered through the mail, x ± CONFIDENCE is a range of population means. For any population mean, μ0, in this range, the probability of obtaining a sample mean further from μ0 than x is greater than alpha; for any population mean, μ0, not in this range, the probability of obtaining a sample mean further from μ0 than x is less than alpha. In other words, assume that we use x, standard_dev, and size to construct a two-tailed test at significance level alpha of the hypothesis that the population mean is μ0. Then we will not reject that hypothesis if μ0 is in the confidence interval and will reject that hypothesis if μ0 is not in the confidence interval. The confidence interval does not allow us to infer that there is probability 1 – alpha that our next package will take a delivery time that is in the confidence interval. For more information about the new functions, see CONFIDENCE.NORM function and CONFIDENCE.T function.
Returns a complex number in x + yi or x + yj text format raised to a power.
This function returns the normal distribution for the specified mean and standard deviation. This function has a very wide range of applications in statistics, including hypothesis testing.
Returns the value from the chi-squared (χ2) distribution for the statistic and the appropriate degrees of freedom. You can use χ2 tests to determine whether hypothesized results are verified by an experiment.
Returns the inverse hyperbolic sine of a number. The inverse hyperbolic sine is the value whose hyperbolic sine is number, so ASINH(SINH(number)) equals number.
Returns the inverse hyperbolic cotangent of a number.
Converts a binary number to decimal.
Returns the inverse of the normal cumulative distribution for the specified mean and standard deviation. This function is provided for backward compatibility; consider using the NORM.INV function instead.
CRITBINOM function