Office for Mac 2016
- number!Returns the hyperbolic cotangent of a number!is the angle in radians for which you want the hyperbolic cotangent! ...
- number!Returns the sign of a number: 1 if the number is positive, zero if the number is zero, or -1 if the number is negative!is ...
- number!Returns the tangent of an angle!is the angle in radians for which you want the tangent. Degrees PI()/180 = radians! ...
- number!Returns the Unicode character referenced by the given numeric value!is the Unicode number representing a character! ...
- number,base!Returns the logarithm of a number to the base you specify!is the positive real number for which you want the ...
- number,decimals!Converts a number to text, using currency format!is a number, a reference to a cell containing a number, ...
- number,decimals!Converts a number to text, using currency format!is a number, a reference to a cell containing a number, ...
- number,decimals,no_commas!Rounds a number to the specified number of decimals and returns the result as text with or without ...
- number,divisor!Returns the remainder after a number is divided by a divisor!is the number for which you want to find the ...
- number,form!Converts an Arabic numeral to Roman, as text!is the Arabic numeral you want to convert!is the number specifying ...
- number,from_unit,to_unit!Converts a number from one measurement system to another!is the value in from_units to convert!is ...
- number,multiple!Returns a number rounded to the desired multiple!is the value to round!is the multiple to which you want ...
- number,number_chosen!Returns the number of combinations for a given number of items!is the total number of items!is the number ...
- number,number_chosen!Returns the number of combinations with repetitions for a given number of items!is the total number ...
- number,number_chosen!Returns the number of permutations for a given number of objects (with repetitions) that can be selected ...
- number,number_chosen!Returns the number of permutations for a given number of objects that can be selected from the total ...
- number,num_digits!Rounds a number down, toward zero!is any real number that you want rounded down!is the number of digits ...
- number,num_digits!Rounds a number to a specified number of digits!is the number you want to round!is the number of digits ...
- number,num_digits!Rounds a number up, away from zero!is any real number that you want rounded up!is the number of digits ...
- number,num_digits!Truncates a number to an integer by removing the decimal, or fractional, part of the number!is the number ...
- number,places!Converts a binary number to hexadecimal!is the binary number you want to convert!is the number of characters ...
- number,places!Converts a binary number to octal!is the binary number you want to convert!is the number of characters to use! ...
- number,places!Converts a decimal number to binary!is the decimal integer you want to convert!is the number of characters ...
- number,places!Converts a decimal number to hexadecimal!is the decimal integer you want to convert!is the number of characters ...
- number,places!Converts a decimal number to octal!is the decimal integer you want to convert!is the number of characters to ...
- number,places!Converts a Hexadecimal number to binary!is the hexadecimal number you want to convert!is the number of characters ...
- number,places!Converts a hexadecimal number to octal!is the hexadecimal number you want to convert!is the number of characters ...
- number,places!Converts an octal number to binary!is the octal number you want to convert!is the number of characters to use! ...
- number,places!Converts an octal number to hexadecimal!is the octal number you want to convert!is the number of characters ...
- number,power!Returns the result of a number raised to a power!is the base number, any real number!is the exponent, to which ...
- number,radix!Converts a text representation of a number in a given base into a decimal number!is the number that you want ...
- number,radix,min_length!Converts a number into a text representation with the given radix (base)!is the number that you want ...
- number,ref,order!Returns the rank of a number in a list of numbers: its size relative to other values in the list; if more ...
- number,ref,order!Returns the rank of a number in a list of numbers: its size relative to other values in the list; if more ...
- number,ref,order!This function is available for compatibility with Excel 2008 and earlier.Returns the rank of a number in ...
- number,shift_amount!Returns a number shifted left by shift_amount bits!is the decimal representation of the binary number ...
- number,shift_amount!Returns a number shifted right by shift_amount bits!is the decimal representation of the binary number ...
- number,significance!Rounds a number down to the nearest multiple of significance!is the numeric value you want to round!is ...
- number,significance!Rounds a number down, to the nearest integer or to the nearest multiple of significance!is the numeric ...
- number,significance!Rounds a number up, to the nearest integer or to the nearest multiple of significance!is the value you ...
- number,significance!Rounds a number up, to the nearest integer or to the nearest multiple of significance!is the value you ...
- number,significance!Rounds a number up, to the nearest multiple of significance!is the value you want to round!is the multiple ...
- number,significance,mode!Rounds a number down, to the nearest integer or to the nearest multiple of significance!is the value ...
- number,significance,mode!Rounds a number up, to the nearest integer or to the nearest multiple of significance!is the value ...
- number,step!Tests whether a number is greater than a threshold value!is the value to test against step!is the threshold value! ...
- number1,number2!Returns a bitwise 'And' of two numbers!is the decimal representation of the binary number you want to evaluate!is ...
- number1,number2!Returns a bitwise 'Exclusive Or' of two numbers!is the decimal representation of the binary number you want ...
- number1,number2!Returns a bitwise 'Or' of two numbers!is the decimal representation of the binary number you want to evaluate!is ...
- number1,number2,.!Adds all the numbers in a range of cells!are 1 to 255 numbers to sum. Logical values and text are ignored ...
- number1,number2,.!Calculates standard deviation based on the entire population given as arguments (ignores logical values ...
- number1,number2,.!Calculates variance based on the entire population (ignores logical values and text in the population)!are ...
- number1,number2,.!Estimates standard deviation based on a sample (ignores logical values and text in the sample)!are 1 to ...
- number1,number2,.!Estimates variance based on a sample (ignores logical values and text in the sample)!are 1 to 255 numeric ...
- number1,number2,.!Multiplies all the numbers given as arguments!are 1 to 255 numbers, logical values, or text representations ...
- number1,number2,.!Returns a vertical array of the most frequently occurring, or repetitive, values in an array or range of ...
- number1,number2,.!Returns the average (arithmetic mean) of its arguments, which can be numbers or names, arrays, or references ...
- number1,number2,.!Returns the average of the absolute deviations of data points from their mean. Arguments can be numbers ...
- number1,number2,.!Returns the geometric mean of an array or range of positive numeric data!are 1 to 255 numbers or names, ...
- number1,number2,.!Returns the harmonic mean of a data set of positive numbers: the reciprocal of the arithmetic mean of reciprocals!are ...
- number1,number2,.!Returns the kurtosis of a data set!are 1 to 255 numbers or names, arrays, or references that contain numbers ...
- number1,number2,.!Returns the largest value in a set of values. Ignores logical values and text!are 1 to 255 numbers, empty ...
- number1,number2,.!Returns the median, or the number in the middle of the set of given numbers!are 1 to 255 numbers or names, ...
- number1,number2,.!Returns the most frequently occurring, or repetitive, value in an array or range of data!are 1 to 255 numbers, ...
- number1,number2,.!Returns the skewness of a distribution based on a population: a characterization of the degree of asymmetry ...
- number1,number2,.!Returns the skewness of a distribution: a characterization of the degree of asymmetry of a distribution ...
- number1,number2,.!Returns the smallest number in a set of values. Ignores logical values and text!are 1 to 255 numbers, empty ...
- number1,number2,.!Returns the sum of squares of deviations of data points from their sample mean!are 1 to 255 arguments, ...
- number1,number2,.!Returns the sum of the squares of the arguments. The arguments can be numbers, arrays, names, or references ...
- number1,number2,.!This function is available for compatibility with Excel 2008 and earlier.Calculates standard deviation ...
- number1,number2,.!This function is available for compatibility with Excel 2008 and earlier.Calculates variance based on the ...
- number1,number2,.!This function is available for compatibility with Excel 2008 and earlier.Estimates standard deviation based ...
- number1,number2,.!This function is available for compatibility with Excel 2008 and earlier.Estimates variance based on a ...
- number1,number2,.!This function is available for compatibility with Excel 2008 and earlier.Returns the most frequently occurring, ...
- number_f,number_s,probability_s!This function is available for compatibility with Excel 2008 and earlier.Returns the negative ...
- number_f,number_s,probability_s,cumulative!Returns the negative binomial distribution, the probability that there will be ...