Excel for Macintosh 2016
- 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 Excel 2008 and earlier.Returns the rank of a number in ...
- 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 ...
- 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 a vertical array of the most frequently occurring, or repetitive, values in an array or range of ...
- 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 based on a population: a characterization of the degree of asymmetry ...
- 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 ...
- number1,number2,.!This function is available for compatibility with Excel 2008 and earlier.Calculates standard deviation ...
- number1,number2,.!This function is available for compatibility with Excel 2008 and earlier.Calculates variance based on the ...
- number1,number2,.!This function is available for compatibility with Excel 2008 and earlier.Estimates standard deviation based ...
- number1,number2,.!This function is available for compatibility with Excel 2008 and earlier.Estimates variance based on a ...
- number1,number2,.!This function is available for compatibility with Excel 2008 and earlier.Returns the most frequently occurring, ...
- number_f,number_s,probability_s!This function is available for compatibility with Excel 2008 and earlier.Returns the negative ...
- number_f,number_s,probability_s,cumulative!Returns the negative binomial distribution, the probability that there will be ...
- number_s,trials,probability_s,cumulative!Returns the individual term binomial distribution probability!is the number of successes ...
- number_s,trials,probability_s,cumulative!This function is available for compatibility with Excel 2008 and earlier.Returns ...
- 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 ...
- OLE Objects cannot be active while debugging.Your code may execute differently in the debug window because the currently ...
- On a chart sheet, you can size and move the entire chart area. Choose Page Setup from the File menu, and then select the ...
- On some black and white printers, the printed copy may look better if you choose Page Setup from the File menu, and then ...
- One or more cells in this workbook contain a conditional formatting icon set arrangement that is not supported in earlier ...
- One or more cells in this workbook contain a conditional formatting icon set arrangement that is not supported in earlier ...
- 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 cells in this workbook contain a data bar rule that uses a "Negative Value" setting. These data bars will not ...
- One or more cells in this workbook contain a data bar rule that uses a fill, border, or "bar direction" setting. These data ...
- One or more cells in this workbook contain a rule that will not be supported in earlier versions of Excel because there is ...
- One or more cells in this workbook contain a rule that will not display in Excel 2007 because it has an alternate data source. ...
- One or more cells in this workbook contain conditional formatting using the 'Text that contains' format with a cell reference ...
- One or more cells in this workbook contain conditional formatting using the 'Text that contains' format with a cell reference ...
- One or more cells in this workbook contain conditional formatting which refers to more than 8192 discontinuous areas of cells. ...
- One or more cells in this workbook contain conditional formatting which refers to values on other worksheets. These conditional ...
- One or more cells in this workbook contain conditional formatting which refers to values on other worksheets. These conditional ...
- One or more cells in this workbook contain data validation rules which refer to more than 8192 discontinuous areas of cells. ...
- One or more cells in this workbook contain data validation rules which refer to values on other worksheets. These data validation ...
- One or more cells in this workbook contain data validation rules which refer to values on other worksheets. These data validation ...
- One or more columns cannot accept the information you're trying to import.The information you are trying to import does not ...
- 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, ...