Excel 2007
- 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 ...
- number!Returns the tangent of an angle!is the angle in radians for which you want the tangent. Degrees PI()/180 = radians! ...
- number,base!Returns the logarithm of a number to the base you specify!is the positive real number for which you want the ...
- number,decimals!Converts a number to text, using currency format!is a number, a reference to a cell containing a number, ...
- number,decimals!Converts a number to text, using currency format!is a number, a reference to a cell containing a number, ...
- number,decimals,no_commas!Rounds a number to the specified number of decimals and returns the result as text with or without ...
- number,divisor!Returns the remainder after a number is divided by a divisor!is the number for which you want to find the ...
- number,form!Converts an Arabic numeral to Roman, as text!is the Arabic numeral you want to convert!is the number specifying ...
- number,from_unit,to_unit!Converts a number from one measurement system to another!is the value in from_units to convert!is ...
- number,multiple!Returns a number rounded to the desired multiple!is the value to round!is the multiple to which you want ...
- number,number_chosen!Returns the number of combinations for a given number of items!is the total number of items!is the number ...
- number,number_chosen!Returns the number of permutations for a given number of objects that can be selected from the total ...
- number,num_digits!Rounds a number down, toward zero!is any real number that you want rounded down!is the number of digits ...
- number,num_digits!Rounds a number to a specified number of digits!is the number you want to round!is the number of digits ...
- number,num_digits!Rounds a number up, away from zero!is any real number that you want rounded up!is the number of digits ...
- number,num_digits!Truncates a number to an integer by removing the decimal, or fractional, part of the number!is the number ...
- number,places!Converts a binary number to hexadecimal!is the binary number you want to convert!is the number of characters ...
- number,places!Converts a binary number to octal!is the binary number you want to convert!is the number of characters to use! ...
- number,places!Converts a decimal number to binary!is the decimal integer you want to convert!is the number of characters ...
- number,places!Converts a decimal number to hexadecimal!is the decimal integer you want to convert!is the number of characters ...
- number,places!Converts a decimal number to octal!is the decimal integer you want to convert!is the number of characters to ...
- number,places!Converts a Hexadecimal number to binary!is the hexadecimal number you want to convert!is the number of characters ...
- number,places!Converts a hexadecimal number to octal!is the hexadecimal number you want to convert!is the number of characters ...
- number,places!Converts an octal number to binary!is the octal number you want to convert!is the number of characters to use! ...
- number,places!Converts an octal number to hexadecimal!is the octal number you want to convert!is the number of characters ...
- number,power!Returns the result of a number raised to a power!is the base number, any real number!is the exponent, to which ...
- 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 ...
- number,significance!Rounds a number down, toward zero, to the nearest multiple of significance!is the numeric value you want ...
- number,significance!Rounds a number up, to the nearest integer or to the nearest multiple of significance!is the value you ...
- number,step!Tests whether a number is greater than a threshold value!is the value to test against step!is the threshold value! ...
- number1,number2,.!Adds all the numbers in a range of cells!are 1 to 255 numbers to sum. Logical values and text are ignored ...
- number1,number2,.!Calculates standard deviation based on the entire population given as arguments (ignores logical values ...
- number1,number2,.!Calculates variance based on the entire population (ignores logical values and text in the population)!are ...
- number1,number2,.!Estimates standard deviation based on a sample (ignores logical values and text in the sample)!are 1 to ...
- number1,number2,.!Estimates variance based on a sample (ignores logical values and text in the sample)!are 1 to 255 numeric ...
- number1,number2,.!Multiplies all the numbers given as arguments!are 1 to 255 numbers, logical values, or text representations ...
- number1,number2,.!Returns the average (arithmetic mean) of its arguments, which can be numbers or names, arrays, or references ...
- number1,number2,.!Returns the average of the absolute deviations of data points from their mean. Arguments can be numbers ...
- number1,number2,.!Returns the geometric mean of an array or range of positive numeric data!are 1 to 255 numbers or names, ...
- number1,number2,.!Returns the harmonic mean of a data set of positive numbers: the reciprocal of the arithmetic mean of reciprocals!are ...
- number1,number2,.!Returns the kurtosis of a data set!are 1 to 255 numbers or names, arrays, or references that contain numbers ...
- number1,number2,.!Returns the largest value in a set of values. Ignores logical values and text!are 1 to 255 numbers, empty ...
- number1,number2,.!Returns the median, or the number in the middle of the set of given numbers!are 1 to 255 numbers or names, ...
- number1,number2,.!Returns the most frequently occurring, or repetitive, value in an array or range of data!are 1 to 255 numbers, ...
- number1,number2,.!Returns the skewness of a distribution: a characterization of the degree of asymmetry of a distribution ...
- number1,number2,.!Returns the smallest number in a set of values. Ignores logical values and text!are 1 to 255 numbers, empty ...
- number1,number2,.!Returns the sum of squares of deviations of data points from their sample mean!are 1 to 255 arguments, ...
- number1,number2,.!Returns the sum of the squares of the arguments. The arguments can be numbers, arrays, names, or references ...
- number_f,number_s,probability_s!Returns the negative binomial distribution, the probability that there will be Number_f failures ...
- number_s,trials,probability_s,cumulative!Returns the individual term binomial distribution probability!is the number of successes ...
- Office 2003 Web Components cannot open data sources on Web servers. Please copy the data source to a local or network file ...
- old_text,start_num,num_bytes,new_text!Replaces part of a text string with a different text string. Use with double-byte character ...
- 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 ...
- One of the XML tables could not grow to accommodate all of the data. Possible causes for this are other tables, PivotTables, ...
- One or more cells in this workbook contain a conditional formatting type on a nonadjacent range (such as top/bottom N, top/bottom ...
- One or more cells in this workbook contain a conditional formatting type on a nonadjacent range (such as, top/bottom N, top/bottom ...
- One or more cells in this workbook contain a conditional formatting type that is not supported in earlier versions of Excel, ...
- One or more defined names in this workbook contain formulas that use more than the 255 characters allowed in the selected ...
- One or more formulas are referencing the header row. Turning off the header row may cause these formulas to return unexpected ...
- One or more formulas in this workbook are longer than the allowed limit of 8192 characters. Cell '|' contains one of these ...
- One or more formulas in this workbook are longer than the allowed limit of 8192 characters. To avoid this limitation, save ...
- One or more formulas or names are referencing the total row. Turning off the total row may cause these formulas or names ...
- One or more functions in this workbook are not available in earlier versions of Excel. When recalculated in earlier versions, ...
- One or more functions in this workbook are not available in this version of Excel. When recalculated, these functions will ...
- One or more names in this workbook are not valid in Excel 2007. Excel will permanently replace invalid characters in each ...
- One or more of the parameters are no longer valid. The parameters may have been overwritten by a PivotTable that has expanded, ...
- One or more PivotTable reports based on external sources have been marked for update on load. External data sources are used ...
- One or more rows were deleted from the table in Excel but the corresponding rows in the SharePoint list cannot be deleted. ...
- One or more tables linked to a server running Microsoft Windows SharePoint Services have been changed in an unexpected way. ...
- One or more worksheets in this workbook have names that contain square brackets:[]. To avoid unexpected results when referencing ...
- Only macro-free workbooks can be published to the server. The following features can not be published in a macro-free workbook: ...
- Only one picture can be inserted in each section of the |. To replace existing picture, press Replace. To keep existing picture, ...
- Only Visual Basic macros can be deleted using this dialog. Delete Microsoft Excel 4.0 macros by editing the macro sheets. ...
- Opening the VBA project in this file requires a component that is not currently installed. This file will be opened without ...
- Opening the VBA project in this file requires a component that is not currently installed. This file will be opened without ...