Excel 2007

  1. number!Returns the arcsine of a number in radians, in the range -Pi/2 to Pi/2!is the sine of the angle you want and must ...
  2. number!Returns the character specified by the code number from the character set for your computer!is a number between 1 ...
  3. 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 ...
  4. number!Returns the tangent of an angle!is the angle in radians for which you want the tangent. Degrees PI()/180 = radians! ...
  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 permutations for a given number of objects that can be selected from the total ...
  15. number,num_digits!Rounds a number down, toward zero!is any real number that you want rounded down!is the number of digits ...
  16. number,num_digits!Rounds a number to a specified number of digits!is the number you want to round!is the number of digits ...
  17. number,num_digits!Rounds a number up, away from zero!is any real number that you want rounded up!is the number of digits ...
  18. number,num_digits!Truncates a number to an integer by removing the decimal, or fractional, part of the number!is the number ...
  19. number,places!Converts a binary number to hexadecimal!is the binary number you want to convert!is the number of characters ...
  20. number,places!Converts a binary number to octal!is the binary number you want to convert!is the number of characters to use! ...
  21. number,places!Converts a decimal number to binary!is the decimal integer you want to convert!is the number of characters ...
  22. number,places!Converts a decimal number to hexadecimal!is the decimal integer you want to convert!is the number of characters ...
  23. number,places!Converts a decimal number to octal!is the decimal integer you want to convert!is the number of characters to ...
  24. number,places!Converts a Hexadecimal number to binary!is the hexadecimal number you want to convert!is the number of characters ...
  25. number,places!Converts a hexadecimal number to octal!is the hexadecimal number you want to convert!is the number of characters ...
  26. number,places!Converts an octal number to binary!is the octal number you want to convert!is the number of characters to use! ...
  27. number,places!Converts an octal number to hexadecimal!is the octal number you want to convert!is the number of characters ...
  28. number,power!Returns the result of a number raised to a power!is the base number, any real number!is the exponent, to which ...
  29. number,ref,order!Returns the rank of a number in a list of numbers: its size relative to other values in the list!is the ...
  30. number,significance!Rounds a number down, toward zero, to the nearest multiple of significance!is the numeric value you want ...
  31. number,significance!Rounds a number up, to the nearest integer or to the nearest multiple of significance!is the value you ...
  32. number,step!Tests whether a number is greater than a threshold value!is the value to test against step!is the threshold value! ...
  33. number1,number2,.!Adds all the numbers in a range of cells!are 1 to 255 numbers to sum. Logical values and text are ignored ...
  34. number1,number2,.!Calculates standard deviation based on the entire population given as arguments (ignores logical values ...
  35. number1,number2,.!Calculates variance based on the entire population (ignores logical values and text in the population)!are ...
  36. number1,number2,.!Estimates standard deviation based on a sample (ignores logical values and text in the sample)!are 1 to ...
  37. number1,number2,.!Estimates variance based on a sample (ignores logical values and text in the sample)!are 1 to 255 numeric ...
  38. number1,number2,.!Multiplies all the numbers given as arguments!are 1 to 255 numbers, logical values, or text representations ...
  39. number1,number2,.!Returns the average (arithmetic mean) of its arguments, which can be numbers or names, arrays, or references ...
  40. number1,number2,.!Returns the average of the absolute deviations of data points from their mean. Arguments can be numbers ...
  41. number1,number2,.!Returns the geometric mean of an array or range of positive numeric data!are 1 to 255 numbers or names, ...
  42. number1,number2,.!Returns the harmonic mean of a data set of positive numbers: the reciprocal of the arithmetic mean of reciprocals!are ...
  43. number1,number2,.!Returns the kurtosis of a data set!are 1 to 255 numbers or names, arrays, or references that contain numbers ...
  44. number1,number2,.!Returns the largest value in a set of values. Ignores logical values and text!are 1 to 255 numbers, empty ...
  45. number1,number2,.!Returns the median, or the number in the middle of the set of given numbers!are 1 to 255 numbers or names, ...
  46. number1,number2,.!Returns the most frequently occurring, or repetitive, value in an array or range of data!are 1 to 255 numbers, ...
  47. number1,number2,.!Returns the skewness of a distribution: a characterization of the degree of asymmetry of a distribution ...
  48. number1,number2,.!Returns the smallest number in a set of values. Ignores logical values and text!are 1 to 255 numbers, empty ...
  49. number1,number2,.!Returns the sum of squares of deviations of data points from their sample mean!are 1 to 255 arguments, ...
  50. number1,number2,.!Returns the sum of the squares of the arguments. The arguments can be numbers, arrays, names, or references ...
  51. number_f,number_s,probability_s!Returns the negative binomial distribution, the probability that there will be Number_f failures ...
  52. number_s,trials,probability_s,cumulative!Returns the individual term binomial distribution probability!is the number of successes ...
  53. Office 2003 Web Components cannot open data sources on Web servers. Please copy the data source to a local or network file ...
  54. old_text,start_num,num_bytes,new_text!Replaces part of a text string with a different text string. Use with double-byte character ...
  55. 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 ...
  56. One of the XML tables could not grow to accommodate all of the data. Possible causes for this are other tables, PivotTables, ...
  57. One or more cells in this workbook contain a conditional formatting type on a nonadjacent range (such as top/bottom N, top/bottom ...
  58. One or more cells in this workbook contain a conditional formatting type on a nonadjacent range (such as, top/bottom N, top/bottom ...
  59. One or more cells in this workbook contain a conditional formatting type that is not supported in earlier versions of Excel, ...
  60. One or more defined names in this workbook contain formulas that use more than the 255 characters allowed in the selected ...
  61. One or more formulas are referencing the header row. Turning off the header row may cause these formulas to return unexpected ...
  62. One or more formulas in this workbook are longer than the allowed limit of 8192 characters. Cell '|' contains one of these ...
  63. One or more formulas in this workbook are longer than the allowed limit of 8192 characters. To avoid this limitation, save ...
  64. One or more formulas or names are referencing the total row. Turning off the total row may cause these formulas or names ...
  65. One or more functions in this workbook are not available in earlier versions of Excel. When recalculated in earlier versions, ...
  66. One or more functions in this workbook are not available in this version of Excel. When recalculated, these functions will ...
  67. One or more names in this workbook are not valid in Excel 2007. Excel will permanently replace invalid characters in each ...
  68. One or more of the parameters are no longer valid. The parameters may have been overwritten by a PivotTable that has expanded, ...
  69. One or more PivotTable reports based on external sources have been marked for update on load. External data sources are used ...
  70. One or more rows were deleted from the table in Excel but the corresponding rows in the SharePoint list cannot be deleted. ...
  71. One or more tables linked to a server running Microsoft Windows SharePoint Services have been changed in an unexpected way. ...
  72. One or more worksheets in this workbook have names that contain square brackets:[]. To avoid unexpected results when referencing ...
  73. Only macro-free workbooks can be published to the server. The following features can not be published in a macro-free workbook: ...
  74. Only one picture can be inserted in each section of the |. To replace existing picture, press Replace. To keep existing picture, ...
  75. Only Visual Basic macros can be deleted using this dialog. Delete Microsoft Excel 4.0 macros by editing the macro sheets. ...