Brother International PDP350CJ Owner's Manual - English - Page 392

Information Functions The information functions return information about a cell, range of cells, or field. Function Description Example CHOOSE (index, value1, value2,...) Returns the nth value in the list of arguments, where the first value is 0 and index indicates the nth value. Value can be from 0 to n-1. You can use as many values as you want. Index and values can be numbers, cell references, defined names, formulas, functions, or text. For example, if the values are the months of the year and the index is 5; then CHOOSE returns May. This function returns an error if your index is less than zero or greater than the number of values. =CHOOSE(5, A1, A2, A3, A4, A5, A6) returns the contents of cell A6. =CHOOSE(2,vanilla",chocolate",toasted almond", peach") returns toasted almond. COLS (range) Number of columns in a range. =COLS(B2:F65) returns 5. COUNT (value1, value2,...) The number of arguments, that is, the number of non-blank cells in a range. Values can be numbers, null, logical values, and dates. The arguments can only be a comma-separated list. =COUNT(23,42,65,23) returns 4. =COUNT(B3:B6) returns the number of non-blank cells in the range. ERR() Causes the formula to return the #ERROR# message. Particularly useful with IF functions to say, If the condition is false, then return #ERROR#." You must include the empty parentheses. =IF(A5>100,ERR(),A5)returns #ERROR# if the value in A5 is less than or equal to 100; otherwise, it returns the value in A5. HLOOKUP (value, range, offset) Returns a value from a horizontal lookup table. Allows you to use a spreadsheet table like a database. Enter values in the table and then extract information from the rows of the table according to your specifications. HLOOKUP extracts from the horizontal rows in the same way as VLOOKUP extracts information from vertical columns. 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. Useful when you have several alternatives to lookup," such as tax rates, commissions, or discounts. (HLOOKUP is not available for use in Addressbook.) Value is the value to be found in the first row of the table. Value can be a number, address, or text string. The first row of the table needs to be sorted. Range is the address of the range that defines the table. Offset defines which row contains the information. The offset of the top row is zero. =HLOOKUP(Jane",B1:E5,2) returns 11. (See chart below.) Example of HLOOKUP: Appendix 365