Excel 2016

  1. number1,number2!Returns a bitwise 'Exclusive Or' of two numbers!is the decimal representation of the binary number you want ...
  2. number1,number2!Returns a bitwise 'Or' of two numbers!is the decimal representation of the binary number you want to evaluate!is ...
  3. number1,number2,.!Adds all the numbers in a range of cells!are 1 to 255 numbers to sum. Logical values and text are ignored ...
  4. number1,number2,.!Calculates standard deviation based on the entire population given as arguments (ignores logical values ...
  5. number1,number2,.!Calculates variance based on the entire population (ignores logical values and text in the population)!are ...
  6. number1,number2,.!Estimates standard deviation based on a sample (ignores logical values and text in the sample)!are 1 to ...
  7. number1,number2,.!Estimates variance based on a sample (ignores logical values and text in the sample)!are 1 to 255 numeric ...
  8. number1,number2,.!Multiplies all the numbers given as arguments!are 1 to 255 numbers, logical values, or text representations ...
  9. number1,number2,.!Returns a vertical array of the most frequently occurring, or repetitive, values in an array or range of ...
  10. number1,number2,.!Returns the average (arithmetic mean) of its arguments, which can be numbers or names, arrays, or references ...
  11. number1,number2,.!Returns the average of the absolute deviations of data points from their mean. Arguments can be numbers ...
  12. number1,number2,.!Returns the geometric mean of an array or range of positive numeric data!are 1 to 255 numbers or names, ...
  13. number1,number2,.!Returns the harmonic mean of a data set of positive numbers: the reciprocal of the arithmetic mean of reciprocals!are ...
  14. number1,number2,.!Returns the kurtosis of a data set!are 1 to 255 numbers or names, arrays, or references that contain numbers ...
  15. number1,number2,.!Returns the largest value in a set of values. Ignores logical values and text!are 1 to 255 numbers, empty ...
  16. number1,number2,.!Returns the median, or the number in the middle of the set of given numbers!are 1 to 255 numbers or names, ...
  17. number1,number2,.!Returns the most frequently occurring, or repetitive, value in an array or range of data!are 1 to 255 numbers, ...
  18. number1,number2,.!Returns the skewness of a distribution based on a population: a characterization of the degree of asymmetry ...
  19. number1,number2,.!Returns the skewness of a distribution: a characterization of the degree of asymmetry of a distribution ...
  20. number1,number2,.!Returns the smallest number in a set of values. Ignores logical values and text!are 1 to 255 numbers, empty ...
  21. number1,number2,.!Returns the sum of squares of deviations of data points from their sample mean!are 1 to 255 arguments, ...
  22. number1,number2,.!Returns the sum of the squares of the arguments. The arguments can be numbers, arrays, names, or references ...
  23. number1,number2,.!This function is available for compatibility with (!idspnExcel_2007) and earlier.Calculates standard deviation ...
  24. number1,number2,.!This function is available for compatibility with (!idspnExcel_2007) and earlier.Calculates variance based ...
  25. number1,number2,.!This function is available for compatibility with (!idspnExcel_2007) and earlier.Estimates standard deviation ...
  26. number1,number2,.!This function is available for compatibility with (!idspnExcel_2007) and earlier.Estimates variance based ...
  27. number1,number2,.!This function is available for compatibility with (!idspnExcel_2007) and earlier.Returns the most frequently ...
  28. number_f,number_s,probability_s!This function is available for compatibility with Excel 2007 and earlier.Returns the negative ...
  29. number_f,number_s,probability_s,cumulative!Returns the negative binomial distribution, the probability that there will be ...
  30. number_s,trials,probability_s,cumulative!Returns the individual term binomial distribution probability!is the number of successes ...
  31. number_s,trials,probability_s,cumulative!This function is available for compatibility with (!idspnExcel_2007) and earlier.Returns ...
  32. Offline OLAP cubes cannot be created for PivotTables connected to filter controls. To create an offline OLAP cube, first ...
  33. Offline OLAP cubes cannot be created when multiple items (Cube Functions, PivotTables, Filter Controls) share the same connection. ...
  34. old_text,start_num,num_bytes,new_text!Replaces part of a text string with a different text string. Use with double-byte character ...
  35. 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 ...
  36. One of the data analysis add-ins can't be enabled. An error occurred and this add-in is no longer functioning properly. Try ...
  37. One of the XML tables could not grow to accommodate all of the data. Possible causes for this are other tables, PivotTables, ...
  38. One or more cells in this workbook contain a conditional formatting icon set arrangement that is not supported in earlier ...
  39. One or more cells in this workbook contain a conditional formatting icon set arrangement that is not supported in earlier ...
  40. One or more cells in this workbook contain a conditional formatting type on a nonadjacent range (such as top/bottom N, top/bottom ...
  41. One or more cells in this workbook contain a conditional formatting type on a nonadjacent range (such as, top/bottom N, top/bottom ...
  42. One or more cells in this workbook contain a conditional formatting type that is not supported in earlier versions of Excel, ...
  43. One or more cells in this workbook contain a data bar rule that uses a "Negative Value" setting. These data bars will not ...
  44. One or more cells in this workbook contain a data bar rule that uses a fill, border, or "bar direction" setting. These data ...
  45. One or more cells in this workbook contain a rule that will not be supported in earlier versions of Excel because there is ...
  46. One or more cells in this workbook contain a rule that will not display in Excel 2007 because it has an alternate data source. ...
  47. One or more cells in this workbook contain conditional formatting using the 'Text that contains' format with a cell reference ...
  48. One or more cells in this workbook contain conditional formatting using the 'Text that contains' format with a cell reference ...
  49. One or more cells in this workbook contain conditional formatting which refers to more than 8192 discontinuous areas of cells. ...
  50. One or more cells in this workbook contain conditional formatting which refers to values on other worksheets. These conditional ...
  51. One or more cells in this workbook contain conditional formatting which refers to values on other worksheets. These conditional ...
  52. One or more cells in this workbook contain data validation rules which refer to more than 8192 discontinuous areas of cells. ...
  53. One or more cells in this workbook contain data validation rules which refer to values on other worksheets. These data validation ...
  54. One or more cells in this workbook contain data validation rules which refer to values on other worksheets. These data validation ...
  55. One or more charts in this workbook contain leader lines that are not supported in earlier versions. This functionality will ...
  56. One or more charts in this workbook contain objects that have been filtered out and are now hidden. Earlier versions of Excel ...
  57. One or more charts in this workbook contain objects that have been filtered out and are now hidden. These charts will retain ...
  58. One or more connections didn't refresh or the refresh operation was cancelled. Would you like to refresh the remaining connections? ...
  59. One or more defined names in this workbook contain formulas that use more than the 255 characters allowed in the selected ...
  60. One or more field names used in the report are no longer valid. If you are changing the name of a field in your datasource, ...
  61. One or more fields are grouped in this PivotTable report. You cannot create sets with grouped fields. To create a set, first ...
  62. One or more formulas are referencing the header row. Turning off the header row may cause these formulas to return unexpected ...
  63. One or more formulas in this workbook are longer than the allowed limit of 8192 characters. Cell '|' contains one of these ...
  64. One or more formulas in this workbook are longer than the allowed limit of 8192 characters. To avoid this limitation, save ...
  65. One or more formulas or names are referencing the total row. Turning off the total row may cause these formulas or names ...
  66. One or more functions in this workbook are not available in earlier versions of Excel. When recalculated in earlier versions, ...
  67. One or more functions in this workbook are not available in earlier versions of Excel. When recalculated in earlier versions, ...
  68. One or more functions in this workbook are not available in this version of Excel. When recalculated, these functions will ...
  69. One or more functions in this workbook are not available in versions prior to Excel 2007. When recalculated in earlier versions, ...
  70. One or more hierarchies have grouped fields in the PivotTable. Slicers cannot be created for hierarchies with grouped fields. ...
  71. One or more names in this workbook are not valid in (!idspnExcel_Short). Excel will permanently replace invalid characters ...
  72. One or more objects in this workbook such as shapes, WordArt, or text boxes may allow text to overflow the object boundaries. ...
  73. One or more of the digital signatures in this workbook is invalid or could not be verified. An invalid signature may indicate ...
  74. One or more of the digital signatures in this workbook is recoverable or could not be verified. A recoverable signature may ...
  75. One or more of the fields chosen have "Include new items in manual filter" selected in the PivotTable. Slicers can only be ...