Abs
In Excel, the Abs function returns the absolute value of a number. The syntax for the Abs function is: Abs( number ) number is a numeric value.
Top
|
|
ACos
In Excel, the ACos function returns the arccosine (in radians) of a number. The syntax for the ACos function is: ACos( number ) number is a number between -1 and 1. It is the cosine of the angle that you wish to find.
Top
|
|
ACosh
In Excel, the ACosh function returns the inverse hyperbolic cosine of a number. The syntax for the ACosh function is: ACosh( number ) number is a number greater than or equal to 1.
Top
|
|
ASin
In Excel, the ASin function returns the arcsine (in radians) of a number. The syntax for the ASin function is: ASin( number ) number is a number between -1 and 1. It is the sine of the angle that you wish to find.
Top
|
|
ASinh
In Excel, the ASinh function returns the inverse hyperbolic sine of a number. The syntax for the ASinh function is: ASinh( number ) number is any number.
Top
|
|
ATan
In Excel, the ATan function returns the arctangent (in radians) of a number. The syntax for the ATan function is: ATan( number ) number is the tangent of the angle that you wish to find.
Top
|
|
ATan2
In Excel, the ATan2 function returns the arctangent (in radians) of (x,y) coordinates. The syntax for the ATan2 function is: ATan2( x-coordinate, y-coordinate ) x-coordinate is the x-coordinate of a point. y-coordinate is the y-coordinate of a point.
Top
|
|
ATanh
In Excel, the ATanh function returns the inverse hyperbolic tangent of a number. The syntax for the ATanh function is: ATanh( number ) number is a number between 1 and -1 (excluding the values of -1 and 1).
Top
|
|
Atn (VBA)
In Excel, the Atn function returns the arctangent of a number. The syntax for the Atn function is: Atn( number ) number is a numeric expression. For example: Atn(2) would return 1.10714871779409 Atn(2.51) would return 1.19166451926354 Atn(-3.25) would return -1.27229739520872 VBA Code The Atn function can only be used in VBA code. For example: Dim LNumber As Double LNumber = Atn(210) In this example, the variable called LNumber would now contain the value of 1.56603445802574.
Top
|
|
Average
In Excel, the Average function returns the average (arithmetic mean) of the numbers provided. The syntax for the Average function is: Average( number1, number2, ... number_n ) number1, number2, ... number_n are numeric values - they can be numbers, named ranges, arrays, or references to numbers. There can be up to 30 values entered.
Top
|
|
AverageA
In Excel, the AverageA function returns the average (arithmetic mean) of the numbers provided. The AverageA function is different from the Average function in that it treats TRUE as a value of 1 and FALSE as a value of 0. The syntax for the AverageA function is: AverageA( number1, number2, ... number_n ) number1, number2, ... number_n are numeric values - they can be numbers, named ranges, arrays, or references to numbers. There can be up to 30 values entered.
Top
|
|
Ceiling
In Excel, the Ceiling function returns a number rounded up based on a multiple of significance. The syntax for the Ceiling function is: Ceiling( number, significance ) number is the number that you wish to round up. significance is the multiple of significance that you wish to round a number to. Note: If the sign of the number and the significance parameters are different, the Ceiling function will return the #NUM! error.
Top
|
|
Combin
In Excel, the Combin function returns the combinations for a specified number of items. The syntax for the Combin function is: Combin( number, chosen ) number is the number of items. chosen is the number of items in a combination.
Top
|
|
Cos
In Excel, the Cos function returns the cosine of an angle. The syntax for the Cos function is: Cos( number ) number is a numeric value.
Top
|
|
Cosh
In Excel, the Cosh function returns the hyperbolic cosine of a number. The syntax for the Cosh function is: Cosh( number ) number is any number.
Top
|
|
Count
In Excel, the Count function counts the number of cells that contain numbers as well as the number of arguments that contain numbers. The syntax for the Count function is: Count( argument1, argument2, ... argument_n ) argument1, argument2, ... argument_n are either ranges of cells or values. There can be up to 30 arguments.
Top
|
|
CountA
In Excel, the CountA function counts the number of cells that are not empty as well as the number of arguments that contain values. The syntax for the CountA function is: CountA( argument1, argument2, ... argument_n ) argument1, argument2, ... argument_n are either ranges of cells or values. There can be up to 30 arguments.
Top
|
|
CountBlank
In Excel, the CountBlank function counts the number of empty cells in a range. The syntax for the CountBlank function is: CountBlank( range ) range is the range of cells to count empty cells.
Top
|
|
CountIf
In Excel, the CountIf function counts the number of cells in a range, that meets a given criteria. The syntax for the CountIf function is: CountIf( range, criteria ) range is the range of cells that you want to count based on the criteria. criteria is used to determine which cells to count.
Top
|
|
Degrees
In Excel, the Degrees function converts radians into degrees. The syntax for the Degrees function is: Degrees( radians ) radians is an angle in radians that you wish to convert to degrees.
Top
|
|
Even
In Excel, the Even function rounds a number up to the nearest even integer. If the number is negative, the number is rounded away from zero. The syntax for the Even function is: Even( number ) number is a numeric value.
Top
|
|
Exp
In Excel, the Exp function returns e raised to the nth power, where e = 2.71828183. The syntax for the Exp function is: Exp( number ) number is the power to raise e to.
Top
|
|
Fact
In Excel, the Fact function returns the factorial of a number. The syntax for the Fact function is: Fact( number ) number is a numeric value.
Top
|
|
Fix (VBA)
In Excel, the Fix function returns the integer portion of a number. The syntax for the Fix function is: Fix( expression ) expression is a numeric expression whose integer portion is returned. Note: If the expression is negative, the Fix function will return the first negative number that is greater than or equal to the expression. For example: Fix(210.67) would return 210 Fix(2.98) would return 2 Fix(-2.98) would return -2 VBA Code The Fix function can only be used in VBA code. For example: Dim LNumber As Double LNumber = Fix(210.67) In this example, the variable called LNumber would now contain the value of 210.
Top
|
|
Floor
In Excel, the Floor function returns a number rounded down based on a multiple of significance. The syntax for the Floor function is: Floor( number, significance ) number is the number that you wish to round down. significance is the multiple of significance that you wish to round a number to. Note: If the sign of the number and the significance parameters are different, the Floor function will return the #NUM! error.
Top
|
|
Int
In Excel, the Int function returns the integer portion of a number. The syntax for the Int function is: Int( expression ) expression is a numeric expression whose integer portion is returned. Note: If the expression is negative, the Int function will return the first negative number that is less than or equal to the expression.
Top
|
|
Large
In Excel, the Large function returns the nth largest value from a set of values. The syntax for the Large function is: Large( array, nth_position ) array is a range or array from which you want to return the nth largest value. nth_position is the position from the largest to return. Note: If nth_position is larger than the number of values in array, the Large function will return the #NUM! error. If array is empty, the Large function will return the #NUM! error.
Top
|
|
Ln
In Excel, the Ln function returns the natural logarithm of a number. The syntax for the Ln function is: Ln( number ) number is a numeric value that must be greater than 0.
Top
|
|
Log
In Excel, the Log function returns the logarithm of a number to a specified base. The syntax for the Log function is: Log( number, base ) number is a numeric value that must be greater than 0. base is optional. This is the base to use to calculate the logarithm of a number. If this parameter is omitted, the Log function will use a base of 10.
Top
|
|
Log10
In Excel, the Log10 function returns the base-10 logarithm of a number. The syntax for the Log10 function is: Log10( number ) number is a numeric value that must be greater than 0.
Top
|
|
Max
In Excel, the Max function returns the largest value from the numbers provided. The syntax for the Max function is: Max( number1, number2, ... number_n ) number1, number2, ... number_n are numeric values - they can be numbers, named ranges, arrays, or references to numbers. There can be up to 30 values entered.
Top
|
|
MaxA
In Excel, the MaxA function returns the largest value from the values provided. The MaxA function compares numbers, text, and logical values (TRUE or FALSE). The syntax for the MaxA function is: MaxA( value1, value2, ... value_n ) value1, value2, ... value_n are numbers, text representations of numbers, or logical values.numeric values. There can be up to 30 values entered.
Top
|
|
Mdeterm
In Excel, the Mdeterm function returns the matrix determinant of an array. The syntax for the Mdeterm function is: Mdeterm( array ) array is an array of numbers. The array must have the same number of rows as the number of columns. Note: If any of the cells in the array contain empty or non-numeric values, the Mdeterm function will return the #VALUE! error. If the array does not contain the same number of rows as the number of columns, the Mdeterm function will return the #VALUE! error.
Top
|
|
Min
In Excel, the Min function returns the smallest value from the numbers provided. The syntax for the Min function is: Min( number1, number2, ... number_n ) number1, number2, ... number_n are numeric values - they can be numbers, named ranges, arrays, or references to numbers. There can be up to 30 values entered.
Top
|
|
MinA
In Excel, the MinA function returns the smallest value from the values provided. The MinA function compares numbers, text, and logical values (TRUE or FALSE). The syntax for the MinA function is: MinA( value1, value2, ... value_n ) value1, value2, ... value_n are numbers, text representations of numbers, or logical values.numeric values. There can be up to 30 values entered
Top
|
|
Minverse
In Excel, the Minverse function returns the inverse matrix for a given matrix. The syntax for the Minverse function is: Minverse( array ) array is an array of numbers. The array must have the same number of rows as the number of columns. Note: If any of the cells in the array contain empty or non-numeric values, the Minverse function will return the #VALUE! error. If the array does not contain the same number of rows as the number of columns, the Minverse function will return the #VALUE! error.
Top
|
|
Mmult
In Excel, the Mmult function returns the matrix product of two arrays. The syntax for the Mmult function is: Mmult( array1, array2 ) array1is an array of numbers. array1 must have the same number of columns as the number of rows in array2. array2is an array of numbers. array1 must have the same number of columns as the number of rows in array2. Note: If any of the cells in the array contain empty or non-numeric values, the Mmult function will return the #VALUE! error. If the array1 does not contain the same number of columns as the number of rows in array2, the Mmult function will return the #VALUE! error.
Top
|
|
Mod
In Excel, the Mod function returns the remainder after a number is divided by a divisor. The syntax for the Mod function is: Mod( number, divisor ) number is a numeric value whose remainder you wish to find. divisor is the number used to divide the number parameter. If the divisor is 0, then the Mod function will return the #DIV/0! error.
Top
|
|
Odd
In Excel, the Odd function rounds a number up to the nearest odd integer. If the number is negative, the number is rounded away from zero. The syntax for the Odd function is: Odd( number ) number is a numeric value.
Top
|
|
Pi
In Excel, the Pi function returns the mathematical constant called pi, which is 3.14159265358979. The syntax for the Pi function is: Pi( )
Top
|
|
Power
In Excel, the Power function returns the result of a number raised to a given power. The syntax for the Power function is: Power( number, power ) number is a base number. power is the exponent used to raise the base number to.
Top
|
|
Product
In Excel, the Product function multiplies the numbers and returns the product. The syntax for the Product function is: Product( number1, number2, ... number_n ) number1, number2, ... number_n are the numbers to multiply together. There can be up to 30 numbers entered.
Top
|
|
Radians
In Excel, the Radians function converts degrees into radians. The syntax for the Radians function is: Radians( degrees ) degrees is an angle in degrees that you wish to convert to radians.
Top
|
|
Rand
In Excel, the Rand function returns a random number that is greater than or equal to 0 and less than 1. The Rand function returns a new random number each time your spreadsheet recalculates. The syntax for the Rand function is: Rand( ) Note: To create a random number between two numbers, you can use the following formula: =Rand()*(b-a)+a Where a is the smallest number and b is the largest number that you want to generate a random number for. Please note, that this formula will never generate a number at the highest end of the range. =Rand()*(25-10)+10 The formula above would generate a random number between 10 and 24.9999999.
Top
|
|
Rnd (VBA)
In Excel, the Rnd function allows you to generate a random number (integer value). You can specify the random number to be a value between 2 user-specified numbers. The syntax for the Rnd function is: Int ((upperbound - lowerbound + 1) * Rnd + lowerbound) upperbound is the highest value that the random number can be. lowerbound is the lowest value that the random number can be. For example: Int ((6 - 1 + 1) * Rnd + 1) would return a random number between 1 and 6. Int ((200 - 150 + 1) * Rnd + 150) would return a random number between 150 and 200 Int ((999 - 100 + 1) * Rnd + 100) would return a random number between 100 and 999 VBA Code The Rnd function can only be used in VBA code. For example: Dim LRandomNumber As Integer LRandomNumber = Int ((300 - 200 + 1) * Rnd + 200)
Top
|
|
Roman
In Excel, the Roman function converts a number to roman numeral. The syntax for the Roman function is: Roman( number, type ) number is the number that you wish to convert to roman numeral. type is optional. It is the type of roman numeral that you wish to convert to. type can be any of the following values: Value Explanation 0 Classic (default). 1 More concise. 2 More concise. 3 More concise. 4 Simplified. TRUE Classic. FALSE Simplified. If type is omitted, the Roman function will assume a type of 0. Note: If a negative number is entered as the number parameter, the Roman function will return the #VALUE! error. If a number greater than 3999 is entered as the number parameter, the Roman function will return the #VALUE! error.
Top
|
|
Round
In Excel, the Round function returns a number rounded to a specified number of digits. The syntax for the Round function is: Round( number, digits ) number is the number to round. digits is the number of digits to round the number to.
Top
|
|
RoundDown
In Excel, the RoundDown function returns a number rounded down to a specified number of digits. (Always rounds towards 0.) The syntax for the RoundDown function is: RoundDown( number, digits ) number is the number to round down. digits is the number of digits to round the number down to.
Top
|
|
RoundUp
In Excel, the RoundUp function returns a number rounded up to a specified number of digits. (Rounds away from 0.) The syntax for the RoundUp function is: RoundUp( number, digits ) number is the number to round up. digits is the number of digits to round the number up to.
Top
|
|
Sgn (VBA)
In Excel, the Sgn function returns the sign of a number (represented as an integer). The syntax for the Sgn function is: Sgn ( number ) number is the the number to return the sign for. Note: If number is greater than zero, the Sgn function will return 1. If number is equal to zero, the Sgn function will return 0. If number is less than zero, the Sng function will return -1. For example: Sgn(-123.67) would return -1 Sgn(0) would return 0 Sgn(123.67) would return 1 VBA Code The Sgn function can only be used in VBA code. For example: Dim LResult As Integer LResult = Sgn(56) In this example, the variable called LResult would now contain the value of 1.
Top
|
|
Sign
In Excel, the Sign function returns the sign of a number. If the number is positive, the Sign function will return 1. If the number is negative, the Sign function will return -1. If the number is 0, the Sign function will return 0. The syntax for the Sign function is: Sign( number ) number is the number that you wish to return the sign for.
Top
|
|
Sin
In Excel, the Sin function returns the sine of an angle. The syntax for the Sin function is: Sin( number ) number is a numeric value
Top
|
|
Sinh
In Excel, the Sinh function returns the hyperbolic sine of a number. The syntax for the Sinh function is: Sinh( number ) number is a numeric value.
Top
|
|
Small
In Excel, the Small function returns the nth smallest value from a set of values. The syntax for the Small function is: Small( array, nth_position ) array is a range or array from which you want to return the nth smallest value. nth_position is the position from the smallest to return. Note: If nth_position is larger than the number of values in array, the Large function will return the #NUM! error. If array is empty, the Large function will return the #NUM! error.
Top
|
|
Sqrt
In Excel, the Sqrt function returns the square root of a number. The syntax for the Sqrt function is: Sqrt( number ) number is a positive number that you wish to return the square root for. Note: If a negative number is entered in the number parameter, the Sqrt function will return the #NUM! error.
Top
|
|
Subtotal
In Excel, the Subtotal function returns the subtotal of the numbers in a column in a list or database. The syntax for the Subtotal function is: Subtotal( method, range1, range2, ... range_n ) method is type of subtotal that you'd like to create. It can be one of the following values: Value Explanation 1 AVERAGE 2 COUNT 3 COUNTA 4 MAX 5 MIN 6 PRODUCT 7 STDEV 8 STDEVP 9 SUM 10 VAR 11 VARP range1, range2, ... range_n are the ranges of cells that you want to subtotal.
Top
|
|
Sum
In Excel, the Sum function adds all numbers in a range of cells and returns the result. The syntax for the Sum function is: Sum( number1, number2, ... number_n ) or Sum ( cell1:cell2 )
Top
|
|
SumIf
In Excel, the SumIf function adds all numbers in a range of cells, based on a given criteria. The syntax for the SumIf function is: SumIf( range, criteria, sum_range ) range is the range of cells that you want to apply the criteria against. criteria is used to determine which cells to add. sum_range are the cells to sum.
Top
|
|
SumProduct
In Excel, the SumProduct function multiplies the corresponding items in the arrays and returns the sum of the results. The syntax for the SumProduct function is: SumProduct( array1, array2, ... array_n ) array1, array2, ... array_n are the ranges of cells or arrays that you wish to multiply. All arrays must have the same number of rows and columns. You must enter at least 2 arrays and you can have up to 30 arrays. Note: If all arrays provided as parameters do not have the same number of rows and columns, the SumProduct function will return the #VALUE! error. If there are non-numeric values in the arrays, these values are treated as 0's by the SumProduct function.
Top
|
|
SumSq
In Excel, the SumSq function returns the sum of the squares of a series of values. The syntax for the SumSq function is: SumSq( value1, value2, ... value_n ) value1, value2, ... value_n are a series of numeric values that are to be squared and then summed together. There can be up to 30 values.
Top
|
|
SumX2mY2
In Excel, the SumX2mY2 function returns the sum of the difference of squares between two arrays. The syntax for the SumX2mY2 function is: SumX2mY2( array1, array2 ) array1 and array2 are two ranges or arrays.
Top
|
|
SumX2pY2
In Excel, the SumX2pY2 function calculates the sum of the squares of corresponding items in the arrays and returns the sum of the results. The syntax for the SumX2pY2 function is: SumX2pY2( array1, array2 ) array1 and array are two ranges or arrays.
Top
|
|
SumXmY2
In Excel, the SumXmY2 function calculates the sum of the squares of the differences between corresponding items in the arrays and returns the sum of the results. The syntax for the SumXmY2 function is: SumXmY2( array1, array2 ) array1 and array are two ranges or arrays.
Top
|
|
Tan
In Excel, the Tan function returns the tangent of an angle. The syntax for the Tan function is: Tan( number ) number is a numeric value.
Top
|
|
Tanh
In Excel, the Tanh function returns the hyperbolic tangent of a number. The syntax for the Tanh function is: Tanh( number ) number is a numeric value.
Top
|
|
Trunc
In Excel, the Trunc function returns a number truncated to a specified number of digits. The syntax for the Trunc function is: Trunc( number, digits ) number is the number to truncate. digits is optional. It is the number of decimal places to display in the resulting truncated number. If this parameter is omitted, the Trunc function will assume 0.
Top
|
|
Val (VBA)
In Excel, the Val function accepts a string as input and returns the numbers found in that string. The syntax for the Val function is: Val( string ) string is a string expression. Note: The Val function will stop reading the string once it encounters the first non-numeric character. This does not include spaces.
Top
|
|
Var
In Excel, the Var function returns the variance of a population based on a sample of numbers. The syntax for the Var function is: Var( number1, number2, ... number_n ) number1, number2, ... number_n are the sample numbers. There can be up to 30 numbers entered.
Top
|
|
VarA
In Excel, the VarA function returns the variance of a population based on a sample of numbers, text, and logical values (ie: TRUE or FALSE). The syntax for the VarA function is: VarA( value1, value2, ... value_n ) value1, value2, ... value_n are the sample values. They can be numbers, text, and logical values. Values that are TRUE are evaluated as 1. Values that are FALSE or text values are evaluated as 0. There can be up to 30 values entered.
Top
|
|
VarP
In Excel, the VarP function returns the variance of a population based on an entire population of numbers. The syntax for the VarP function is: VarP( number1, number2, ... number_n ) number1, number2, ... number_n are the population numbers. There can be up to 30 numbers entered.
Top
|
|
VarPA
In Excel, the VarPA function returns the variance of a population based on an entire population of numbers, text, and logical values (ie: TRUE or FALSE). The syntax for the VarPA function is: VarPA( value1, value2, ... value_n ) value1, value2, ... value_n are the population values. They can be numbers, text, and logical values. Values that are TRUE are evaluated as 1. Values that are FALSE or text values are evaluated as 0. There can be up to 30 values entered.
Top
|
|
