Excel for Macintosh 2016

  1. number,radix,min_length!Converts a number into a text representation with the given radix (base)!is the number that you want ...
  2. 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 ...
  3. 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 ...
  4. number,ref,order!This function is available for compatibility with Excel 2008 and earlier.Returns the rank of a number in ...
  5. number,shift_amount!Returns a number shifted left by shift_amount bits!is the decimal representation of the binary number ...
  6. number,shift_amount!Returns a number shifted right by shift_amount bits!is the decimal representation of the binary number ...
  7. number,significance!Rounds a number down to the nearest multiple of significance!is the numeric value you want to round!is ...
  8. number,significance!Rounds a number down, to the nearest integer or to the nearest multiple of significance!is the numeric ...
  9. number,significance!Rounds a number up, to the nearest integer or to the nearest multiple of significance!is the value you ...
  10. number,significance!Rounds a number up, to the nearest integer or to the nearest multiple of significance!is the value you ...
  11. number,significance!Rounds a number up, to the nearest multiple of significance!is the value you want to round!is the multiple ...
  12. number,significance,mode!Rounds a number down, to the nearest integer or to the nearest multiple of significance!is the value ...
  13. number,significance,mode!Rounds a number up, to the nearest integer or to the nearest multiple of significance!is the value ...
  14. number,step!Tests whether a number is greater than a threshold value!is the value to test against step!is the threshold value! ...
  15. number1,number2!Returns a bitwise 'And' of two numbers!is the decimal representation of the binary number you want to evaluate!is ...
  16. number1,number2!Returns a bitwise 'Exclusive Or' of two numbers!is the decimal representation of the binary number you want ...
  17. number1,number2!Returns a bitwise 'Or' of two numbers!is the decimal representation of the binary number you want to evaluate!is ...
  18. number1,number2,.!Adds all the numbers in a range of cells!are 1 to 255 numbers to sum. Logical values and text are ignored ...
  19. number1,number2,.!Calculates standard deviation based on the entire population given as arguments (ignores logical values ...
  20. number1,number2,.!Calculates variance based on the entire population (ignores logical values and text in the population)!are ...
  21. number1,number2,.!Estimates standard deviation based on a sample (ignores logical values and text in the sample)!are 1 to ...
  22. number1,number2,.!Estimates variance based on a sample (ignores logical values and text in the sample)!are 1 to 255 numeric ...
  23. number1,number2,.!Multiplies all the numbers given as arguments!are 1 to 255 numbers, logical values, or text representations ...
  24. number1,number2,.!Returns a vertical array of the most frequently occurring, or repetitive, values in an array or range of ...
  25. number1,number2,.!Returns the average (arithmetic mean) of its arguments, which can be numbers or names, arrays, or references ...
  26. number1,number2,.!Returns the average of the absolute deviations of data points from their mean. Arguments can be numbers ...
  27. number1,number2,.!Returns the geometric mean of an array or range of positive numeric data!are 1 to 255 numbers or names, ...
  28. number1,number2,.!Returns the harmonic mean of a data set of positive numbers: the reciprocal of the arithmetic mean of reciprocals!are ...
  29. number1,number2,.!Returns the kurtosis of a data set!are 1 to 255 numbers or names, arrays, or references that contain numbers ...
  30. number1,number2,.!Returns the largest value in a set of values. Ignores logical values and text!are 1 to 255 numbers, empty ...
  31. number1,number2,.!Returns the median, or the number in the middle of the set of given numbers!are 1 to 255 numbers or names, ...
  32. number1,number2,.!Returns the most frequently occurring, or repetitive, value in an array or range of data!are 1 to 255 numbers, ...
  33. number1,number2,.!Returns the skewness of a distribution based on a population: a characterization of the degree of asymmetry ...
  34. number1,number2,.!Returns the skewness of a distribution: a characterization of the degree of asymmetry of a distribution ...
  35. number1,number2,.!Returns the smallest number in a set of values. Ignores logical values and text!are 1 to 255 numbers, empty ...
  36. number1,number2,.!Returns the sum of squares of deviations of data points from their sample mean!are 1 to 255 arguments, ...
  37. number1,number2,.!Returns the sum of the squares of the arguments. The arguments can be numbers, arrays, names, or references ...
  38. number1,number2,.!This function is available for compatibility with Excel 2008 and earlier.Calculates standard deviation ...
  39. number1,number2,.!This function is available for compatibility with Excel 2008 and earlier.Calculates variance based on the ...
  40. number1,number2,.!This function is available for compatibility with Excel 2008 and earlier.Estimates standard deviation based ...
  41. number1,number2,.!This function is available for compatibility with Excel 2008 and earlier.Estimates variance based on a ...
  42. number1,number2,.!This function is available for compatibility with Excel 2008 and earlier.Returns the most frequently occurring, ...
  43. number_f,number_s,probability_s!This function is available for compatibility with Excel 2008 and earlier.Returns the negative ...
  44. number_f,number_s,probability_s,cumulative!Returns the negative binomial distribution, the probability that there will be ...
  45. number_s,trials,probability_s,cumulative!Returns the individual term binomial distribution probability!is the number of successes ...
  46. number_s,trials,probability_s,cumulative!This function is available for compatibility with Excel 2008 and earlier.Returns ...
  47. old_text,start_num,num_bytes,new_text!Replaces part of a text string with a different text string. Use with double-byte character ...
  48. old_text,start_num,num_chars,new_text!Replaces part of a text string with a different text string!is text in which you want ...
  49. OLE Objects cannot be active while debugging.Your code may execute differently in the debug window because the currently ...
  50. On a chart sheet, you can size and move the entire chart area. Choose Page Setup from the File menu, and then select the ...
  51. On some black and white printers, the printed copy may look better if you choose Page Setup from the File menu, and then ...
  52. One or more cells in this workbook contain a conditional formatting icon set arrangement that is not supported in earlier ...
  53. One or more cells in this workbook contain a conditional formatting icon set arrangement that is not supported in earlier ...
  54. One or more cells in this workbook contain a conditional formatting type on a nonadjacent range (such as top/bottom N, top/bottom ...
  55. One or more cells in this workbook contain a conditional formatting type on a nonadjacent range (such as, top/bottom N, top/bottom ...
  56. One or more cells in this workbook contain a conditional formatting type that is not supported in earlier versions of Excel, ...
  57. One or more cells in this workbook contain a data bar rule that uses a "Negative Value" setting. These data bars will not ...
  58. One or more cells in this workbook contain a data bar rule that uses a fill, border, or "bar direction" setting. These data ...
  59. One or more cells in this workbook contain a rule that will not be supported in earlier versions of Excel because there is ...
  60. One or more cells in this workbook contain a rule that will not display in Excel 2007 because it has an alternate data source. ...
  61. One or more cells in this workbook contain conditional formatting using the 'Text that contains' format with a cell reference ...
  62. One or more cells in this workbook contain conditional formatting using the 'Text that contains' format with a cell reference ...
  63. One or more cells in this workbook contain conditional formatting which refers to more than 8192 discontinuous areas of cells. ...
  64. One or more cells in this workbook contain conditional formatting which refers to values on other worksheets. These conditional ...
  65. One or more cells in this workbook contain conditional formatting which refers to values on other worksheets. These conditional ...
  66. One or more cells in this workbook contain data validation rules which refer to more than 8192 discontinuous areas of cells. ...
  67. One or more cells in this workbook contain data validation rules which refer to values on other worksheets. These data validation ...
  68. One or more cells in this workbook contain data validation rules which refer to values on other worksheets. These data validation ...
  69. One or more columns cannot accept the information you're trying to import.The information you are trying to import does not ...
  70. One or more defined names in this workbook contain formulas that use more than the 255 characters allowed in the selected ...
  71. One or more formulas are referencing the header row. Turning off the header row may cause these formulas to return unexpected ...
  72. One or more formulas in this workbook are longer than the allowed limit of 8192 characters. Cell '|' contains one of these ...
  73. One or more formulas in this workbook are longer than the allowed limit of 8192 characters. To avoid this limitation, save ...
  74. One or more formulas or names are referencing the total row. Turning off the total row may cause these formulas or names ...
  75. One or more functions in this workbook are not available in earlier versions of Excel. When recalculated in earlier versions, ...