Excel 2016

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