Excel 2016
- Microsoft Query is already running, but is not responding to (!idspnExcel_NV). Switch to Microsoft Query and make sure that ...
- Microsoft Query is busy editing another query for (!idspnExcel_NV). You can not edit more than one query at a time from within ...
- module_text,procedure,type_text!Returns the register ID of the specified dynamic link library (DLL) or code resource that ...
- module_text,procedure,type_text,function_text,argument_text,macro_type,category,shortcut_text,help_topic,function_help,argument_help1,.! ...
- Multiple filters are applied to one or more fields in the PivotTable.If you leave the Allow multiple filters per field check ...
- Negative or zero values cannot be plotted correctly on log charts. Only positive values can be interpreted on a logarithmic ...
- Negative or zero values cannot be plotted correctly on log charts. Only positive values can be interpreted on a logarithmic ...
- Negative or zero values cannot be plotted correctly on log charts. Only positive values can be interpreted on a logarithmic ...
- No data is currently displayed in this external data range. As a result, you can't hide the row numbers.Either refresh the ...
- No data was imported because no elements have been mapped. Use Range.XPath.SetValue to map XML elements onto the worksheet. ...
- No more system timer resources are available.Close one or more programs to free up resources, then try the operation again. ...
- No printers are installed. To install a printer click the File tab, and then click Print. Click No Printers Installed, and ...
- No printers are installed. To install a printer, point to Settings on the Windows Start menu, click Printers, and then double-click ...
- nominal_rate,npery!Returns the effective annual interest rate!is the nominal interest rate!is the number of compounding periods ...
- Not all data from the external data source could be displayed. With the PivotTable report selected, refresh the data by clicking ...
- Not enough memory is available to save the data along with the PivotTable report. To continue saving the report without the ...
- nper,pmt,pv,fv,type,guess!Returns the interest rate per period of a loan or an investment. For example, use 6%/4 for quarterly ...
- nper,pv,fv!Returns an equivalent interest rate for the growth of an investment!is the number of periods for the investment!is ...
- number!Returns e raised to the power of a given number!is the exponent applied to the base e. The constant e equals 2.71828182845904, ...
- number!Returns the absolute value of a number, a number without its sign!is the real number for which you want the absolute ...
- number!Returns the arccosine of a number, in radians in the range 0 to Pi. The arccosine is the angle whose cosine is Number!is ...
- 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 ...
- number!Returns the character specified by the code number from the character set for your computer!is a number between 1 ...
- number!Returns the hyperbolic cotangent of a number!is the angle in radians for which you want the hyperbolic cotangent! ...
- 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!Returns the Unicode character referenced by the given numeric value!is the Unicode number representing a character! ...
- 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 combinations with repetitions for a given number of items!is the total number ...
- number,number_chosen!Returns the number of permutations for a given number of objects (with repetitions) that can be selected ...
- 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,radix!Converts a text representation of a number in a given base into a decimal number!is the number that you want ...
- number,radix,min_length!Converts a number into a text representation with the given radix (base)!is the number that you want ...
- 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 ...
- 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 ...
- number,ref,order!This function is available for compatibility with (!idspnExcel_2007) and earlier.Returns the rank of a number ...
- number,shift_amount!Returns a number shifted left by shift_amount bits!is the decimal representation of the binary number ...
- number,shift_amount!Returns a number shifted right by shift_amount bits!is the decimal representation of the binary number ...
- number,significance!Rounds a number down to the nearest multiple of significance!is the numeric value you want to round!is ...
- number,significance!Rounds a number down, to the nearest integer or to the nearest multiple of significance!is the numeric ...
- number,significance!Rounds a number up, to the nearest integer or to the nearest multiple of significance!is the value you ...
- number,significance!Rounds a number up, to the nearest integer or to the nearest multiple of significance!is the value you ...
- number,significance!Rounds a number up, to the nearest multiple of significance!is the value you want to round!is the multiple ...
- number,significance,mode!Rounds a number down, to the nearest integer or to the nearest multiple of significance!is the value ...
- number,significance,mode!Rounds a number up, to the nearest integer or to the nearest multiple of significance!is the value ...
- 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!Returns a bitwise 'And' of two numbers!is the decimal representation of the binary number you want to evaluate!is ...
- number1,number2!Returns a bitwise 'Exclusive Or' of two numbers!is the decimal representation of the binary number you want ...
- number1,number2!Returns a bitwise 'Or' of two numbers!is the decimal representation of the binary number you want to evaluate!is ...
- 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 ...