is the text you want to find. Use double quotes (empty text) to match the first character in Within_text; wildcard characters not allowed
is the range of cells that contains the conditions you specify. The range includes a column label and one cell below the ...
is the rate at which the balance declines. If Factor is omitted, it is assumed to be 2 (the double-declining balance method) ...
is the row number in table_array from which the matching value should be returned. The first row of values in the table is ...
is the second array or range of data and can be numbers or names, arrays, or references that contain numbers (blanks are ...
is the text you want to find. Use double quotes (empty text) to match the first character in Within_text; wildcard characters ...
is the value that is returned if Logical_test is TRUE. If omitted, TRUE is returned. You can nest up to seven IF functions ...
is the value to test: if Value is or refers to text, T returns Value; if Value is not text, T returns double quotes (empty ...
is the value you use to find the value you want in the array, a number, text, or logical value, or a reference to one of ...
is used to calculate other columns. Are you sure you want to delete it? If you delete |0, calculations will be adjusted in ...