Brother International PDP350CJ Owner's Manual - English - Page 393
Example of VLOOKUP, VLOOKUPJane, A2:E5
View all Brother International PDP350CJ manuals
Add to My Manuals
Save this manual to your list of manuals |
Page 393 highlights
Function Description Example INDEX (range,column offset, row offset) Returns the value of the cell at the intersection of a row and column. The top row is 0,0. Range is the address defining the range. Column_offsetdefines the column offset in the specified range. Row_offset defines the row offset in the specified range. =INDEX(B1:H24,5,6) returns the contents of G7. ISERR (value) ISNUMBER (value) Returns 1 if an expression is an error or 0 if it is not. This function is particularly useful in IF statements. Returns 1 if an expression is a number or 0 if it is not. Useful in IF statements. =ISERR(B2) returns TRUE if the value in B2 is an error. =IF(ISERR(B2),",B2)returns an empty string if there is an error. Otherwise, the expression returns the contents of B2. =ISNUMBER(B2) returns TRUE. =IF(ISNUMBER(B2),",B2)returns an empty string if B2 contains a number. The expression returns the contents of B2 if B2 is not a number. ISSTRING (value) Returns 1 if an expression is a string or 0 if it is not. Useful in IF statements. =ISSTRING(B2) returns TRUE. =IF(ISSTRING(B2),",B2)returns an empty string if B2 contains a string. Otherwise, the expression returns the contents of B2. N (range) Returns the value from the first cell in a range if that cell contains a number, time, or date. If the cell contains text, the function returns 0 (zero). (Not available for use in Addressbook.) =N(B1:B13) returns 2365 if B1 contains 2365. NA () Stops the evaluation of a formula and generates #N/A# in the formula cell. NA is the abbreviation for Not Available." This function is useful if you are creating a spreadsheet and do not have all the required values. If a formula refers to a cell containing #N/A#, it returns #N/A# so that you do not inadvertently forget to complete the spreadsheet. You can type #N/A# directly into the cell. You must include the empty parentheses. ROWS (range) Number of rows in a range. =ROWS(B2:F65) returns 64. VLOOKUP (value, range, offset) Returns a value from a verticallookup table, allowing you to use a spreadsheet like a database. You can enter values in the table and then extract information from the columns of the table according to your specifications. VLOOKUP extracts information from vertical columns in the same way as HLOOKUP extracts from the horizontal rows. HLOOKUP and VLOOKUP assume the entries in the first row or column are sorted. They return the entry corresponding to the nearest ascending value that is not greater than value. These functions are useful when you have several alternatives to lookup," such as tax rates, commissions, or discounts. =VLOOKUP(Jane", A2:E5, 2) returns 11.00. See the example below. . Value is the value to be found in the first column of the table. Value can be a number, address, or text string. The first column of the table needs to be sorted. Range is the address of the range that defines the table. Offset defines which column contains the information. The first column is 0. Example of VLOOKUP: VLOOKUP("Jane",A2:E5,2) returns 11.00. Appendix 366