Office for Mac 2016

  1. number!Returns the hyperbolic cotangent of a number!is the angle in radians for which you want the hyperbolic cotangent! ...
  2. 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 ...
  3. number!Returns the tangent of an angle!is the angle in radians for which you want the tangent. Degrees PI()/180 = radians! ...
  4. number!Returns the Unicode character referenced by the given numeric value!is the Unicode number representing a character! ...
  5. number,base!Returns the logarithm of a number to the base you specify!is the positive real number for which you want the ...
  6. number,decimals!Converts a number to text, using currency format!is a number, a reference to a cell containing a number, ...
  7. number,decimals!Converts a number to text, using currency format!is a number, a reference to a cell containing a number, ...
  8. number,decimals,no_commas!Rounds a number to the specified number of decimals and returns the result as text with or without ...
  9. number,divisor!Returns the remainder after a number is divided by a divisor!is the number for which you want to find the ...
  10. number,form!Converts an Arabic numeral to Roman, as text!is the Arabic numeral you want to convert!is the number specifying ...
  11. number,from_unit,to_unit!Converts a number from one measurement system to another!is the value in from_units to convert!is ...
  12. number,multiple!Returns a number rounded to the desired multiple!is the value to round!is the multiple to which you want ...
  13. number,number_chosen!Returns the number of combinations for a given number of items!is the total number of items!is the number ...
  14. number,number_chosen!Returns the number of combinations with repetitions for a given number of items!is the total number ...
  15. number,number_chosen!Returns the number of permutations for a given number of objects (with repetitions) that can be selected ...
  16. number,number_chosen!Returns the number of permutations for a given number of objects that can be selected from the total ...
  17. number,num_digits!Rounds a number down, toward zero!is any real number that you want rounded down!is the number of digits ...
  18. number,num_digits!Rounds a number to a specified number of digits!is the number you want to round!is the number of digits ...
  19. number,num_digits!Rounds a number up, away from zero!is any real number that you want rounded up!is the number of digits ...
  20. number,num_digits!Truncates a number to an integer by removing the decimal, or fractional, part of the number!is the number ...
  21. number,places!Converts a binary number to hexadecimal!is the binary number you want to convert!is the number of characters ...
  22. number,places!Converts a binary number to octal!is the binary number you want to convert!is the number of characters to use! ...
  23. number,places!Converts a decimal number to binary!is the decimal integer you want to convert!is the number of characters ...
  24. number,places!Converts a decimal number to hexadecimal!is the decimal integer you want to convert!is the number of characters ...
  25. number,places!Converts a decimal number to octal!is the decimal integer you want to convert!is the number of characters to ...
  26. number,places!Converts a Hexadecimal number to binary!is the hexadecimal number you want to convert!is the number of characters ...
  27. number,places!Converts a hexadecimal number to octal!is the hexadecimal number you want to convert!is the number of characters ...
  28. number,places!Converts an octal number to binary!is the octal number you want to convert!is the number of characters to use! ...
  29. number,places!Converts an octal number to hexadecimal!is the octal number you want to convert!is the number of characters ...
  30. number,power!Returns the result of a number raised to a power!is the base number, any real number!is the exponent, to which ...
  31. number,radix!Converts a text representation of a number in a given base into a decimal number!is the number that you want ...
  32. number,radix,min_length!Converts a number into a text representation with the given radix (base)!is the number that you want ...
  33. 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 ...
  34. 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 ...
  35. number,ref,order!This function is available for compatibility with Excel 2008 and earlier.Returns the rank of a number in ...
  36. number,shift_amount!Returns a number shifted left by shift_amount bits!is the decimal representation of the binary number ...
  37. number,shift_amount!Returns a number shifted right by shift_amount bits!is the decimal representation of the binary number ...
  38. number,significance!Rounds a number down to the nearest multiple of significance!is the numeric value you want to round!is ...
  39. number,significance!Rounds a number down, to the nearest integer or to the nearest multiple of significance!is the numeric ...
  40. number,significance!Rounds a number up, to the nearest integer or to the nearest multiple of significance!is the value you ...
  41. number,significance!Rounds a number up, to the nearest integer or to the nearest multiple of significance!is the value you ...
  42. number,significance!Rounds a number up, to the nearest multiple of significance!is the value you want to round!is the multiple ...
  43. number,significance,mode!Rounds a number down, to the nearest integer or to the nearest multiple of significance!is the value ...
  44. number,significance,mode!Rounds a number up, to the nearest integer or to the nearest multiple of significance!is the value ...
  45. number,step!Tests whether a number is greater than a threshold value!is the value to test against step!is the threshold value! ...
  46. number1,number2!Returns a bitwise 'And' of two numbers!is the decimal representation of the binary number you want to evaluate!is ...
  47. number1,number2!Returns a bitwise 'Exclusive Or' of two numbers!is the decimal representation of the binary number you want ...
  48. number1,number2!Returns a bitwise 'Or' of two numbers!is the decimal representation of the binary number you want to evaluate!is ...
  49. number1,number2,.!Adds all the numbers in a range of cells!are 1 to 255 numbers to sum. Logical values and text are ignored ...
  50. number1,number2,.!Calculates standard deviation based on the entire population given as arguments (ignores logical values ...
  51. number1,number2,.!Calculates variance based on the entire population (ignores logical values and text in the population)!are ...
  52. number1,number2,.!Estimates standard deviation based on a sample (ignores logical values and text in the sample)!are 1 to ...
  53. number1,number2,.!Estimates variance based on a sample (ignores logical values and text in the sample)!are 1 to 255 numeric ...
  54. number1,number2,.!Multiplies all the numbers given as arguments!are 1 to 255 numbers, logical values, or text representations ...
  55. number1,number2,.!Returns a vertical array of the most frequently occurring, or repetitive, values in an array or range of ...
  56. number1,number2,.!Returns the average (arithmetic mean) of its arguments, which can be numbers or names, arrays, or references ...
  57. number1,number2,.!Returns the average of the absolute deviations of data points from their mean. Arguments can be numbers ...
  58. number1,number2,.!Returns the geometric mean of an array or range of positive numeric data!are 1 to 255 numbers or names, ...
  59. number1,number2,.!Returns the harmonic mean of a data set of positive numbers: the reciprocal of the arithmetic mean of reciprocals!are ...
  60. number1,number2,.!Returns the kurtosis of a data set!are 1 to 255 numbers or names, arrays, or references that contain numbers ...
  61. number1,number2,.!Returns the largest value in a set of values. Ignores logical values and text!are 1 to 255 numbers, empty ...
  62. number1,number2,.!Returns the median, or the number in the middle of the set of given numbers!are 1 to 255 numbers or names, ...
  63. number1,number2,.!Returns the most frequently occurring, or repetitive, value in an array or range of data!are 1 to 255 numbers, ...
  64. number1,number2,.!Returns the skewness of a distribution based on a population: a characterization of the degree of asymmetry ...
  65. number1,number2,.!Returns the skewness of a distribution: a characterization of the degree of asymmetry of a distribution ...
  66. number1,number2,.!Returns the smallest number in a set of values. Ignores logical values and text!are 1 to 255 numbers, empty ...
  67. number1,number2,.!Returns the sum of squares of deviations of data points from their sample mean!are 1 to 255 arguments, ...
  68. number1,number2,.!Returns the sum of the squares of the arguments. The arguments can be numbers, arrays, names, or references ...
  69. number1,number2,.!This function is available for compatibility with Excel 2008 and earlier.Calculates standard deviation ...
  70. number1,number2,.!This function is available for compatibility with Excel 2008 and earlier.Calculates variance based on the ...
  71. number1,number2,.!This function is available for compatibility with Excel 2008 and earlier.Estimates standard deviation based ...
  72. number1,number2,.!This function is available for compatibility with Excel 2008 and earlier.Estimates variance based on a ...
  73. number1,number2,.!This function is available for compatibility with Excel 2008 and earlier.Returns the most frequently occurring, ...
  74. number_f,number_s,probability_s!This function is available for compatibility with Excel 2008 and earlier.Returns the negative ...
  75. number_f,number_s,probability_s,cumulative!Returns the negative binomial distribution, the probability that there will be ...