Article REPLACE replaces part of a text string, based on the number of characters you specify, with a different text string. Syntax REPLACE ( old_text , start_num , num...

Article Returns the arcsine, or inverse sine, of a number. The arcsine is the angle whose sine is number . The returned angle is given in radians in the range -pi/2 to...

Article Rounds a number to a specified number of digits. Syntax ROUND ( number , num_digits ) Number  Is the number you want to round. Num_digits  Specifies the number ...

Article 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 numb...

Article Returns the absolute value of a number. The absolute value of a number is the number without its sign. Syntax ABS ( number ) Number   is the real number of whic...

Article Returns the present value of an investment. The present value is the total amount that a series of future payments is worth now. For example, when you borrow mo...

Article Multiplies all the numbers given as arguments and returns the product. Syntax PRODUCT ( number1 , number2 , ... ) Number1, number2,...   are 1 to 30 numbers tha...

Article Returns the interest rate per period of an annuity. RATE is calculated by iteration and can have zero or more solutions. If the successive results of RATE do no...

Article Returns the average (arithmetic mean) of the arguments. Syntax AVERAGE ( number1 , number2 , ... ) Number1, number2, ...   are 1 to 30 numeric arguments for wh...

Article Returns the inverse of the cumulative beta probability distribution function. That is, if probability = BETADIST(x,...), then BETAINV(probability,...) = x. The ...

Article Converts degrees to radians. Syntax RADIANS ( angle ) Angle   is an angle in degrees that you want to convert. Example Formula Description (Result) =RADIANS(270...

Article Rounds a number down, toward zero. Syntax ROUNDDOWN ( number , num_digits ) Number   is any real number that you want rounded down. Num_digits   is the number o...

Article Rounds a number up, away from 0 (zero). Syntax ROUNDUP ( number , num_digits ) Number   is any real number that you want rounded up. Num_digits   is the number ...

Article Determines the sign of a number. Returns 1 if the number is positive, zero (0) if the number is 0, and -1 if the number is negative. Syntax SIGN ( number ) Numb...

Article Returns the average of the absolute deviations of data points from their mean. AVEDEV is a measure of the variability in a data set. Syntax AVEDEV ( number1 ,nu...

Article Returns the logical value TRUE if all of the arguments are TRUE; returns FALSE if one or more arguments is FALSE. Syntax AND ( logical1 , logical2 , ... ) Logic...

Article Returns the inverse hyperbolic cosine of a number. Number must be greater than or equal to 1. The inverse hyperbolic cosine is the value whose hyperbolic cosi...

Article Capitalizes the first letter and any other letters that follow a non-letter character in a text string. Converts all other letters in the text string to lowerca...

Article For Double-byte character set (DBCS) languages, changes full-width (double-byte) characters to half-width (single-byte) characters. Syntax ASC ( text ) Text   ...

Article Returns the cumulative beta probability distribution function. The cumulative beta probability distribution function is commonly used to study variation in the ...

Article SEARCH returns the number of the character at which a specific character or text string is first found, beginning with start_num. Use SEARCH to determine the lo...

Article Returns the arccosine, or inverse cosine, of a number. The arccosine is the angle whose cosine is number . The returned angle is given in radians in the range ...

Article Returns the seconds of a time value. The second is given as an integer in the range 0 (zero) to 59. Syntax SECOND ( serial_number ) Serial_number   is the time...

Article Calculates the average (arithmetic mean) of the values in the list of arguments. Unlike the AVERAGE functions, text and logical values such as TRUE and FALSE ar...

Article Returns the payment on the principal for a given period for an investment based on periodic, constant payments and a constant interest rate. Syntax PPMT ( rate ...