is a table of text, numbers, or logical values in which data is looked up. Table_array can be a reference to a range or a range name
is a logical value: to find the closest match in the top row (sorted in ascending order) = TRUE or omitted; find an exact ...
is a number: for Sunday=1 through Saturday=7, use 1; for Monday=1 through Sunday=7, use 2; for Monday=0 through Sunday=1, ...
is a parameter to the distribution, a positive number. If beta = 1, GAMMAINV returns the inverse of the standard gamma distribution ...
is a reference to a cell that contains an A1- or R1C1-style reference, a name defined as a reference, or a reference to a ...
is a table of text, numbers, or logical values in which data is looked up. Table_array can be a reference to a range or a ...
is a table of text, numbers, or logical values, in which data is retrieved. Table_array can be a reference to a range or ...
is a text string that gives a time in any one of the Microsoft Excel time formats (date information in the string is ignored) ...
is a text string that refers to the part of the PivotTable that contains the data you want to retrieve. See Help for more ...
is a value representing the timing of payment: payment at the beginning of the period = 1; payment at the end of the period ...