Brother Ensemble PDP-100J, Owner'S Manual

Page: 393 / 440

Appendix 366
Function Description
Example
(range,column
offset, row offset)
Returns the value of the !! ( ( #(&'($#
$ &$+ # $!)"# . The top row is 0,0.
Range is the address defining the range.
Column_offset defines 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.
(value)
Returns 1 if an expression ' # &&$& or 0 if it
is not. This function is particularly 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.
(value)
Returns 1 if an expression ' #)"& or 0 if it
is not. Useful in IF statements.
=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.
(value)
Returns 1 if an expression ' '(&# 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.
(range)
Returns the value from the &'( !! # &#
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.
()
Stops the evaluation of a formula and generates
#N/A# in the formula cell. NA is the
abbreviation for  $( *!! ." 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
directly into the cell. You must include the
emptyparentheses.
(range)
Number of &$+' # &# . =ROWS(B2:F65) returns 64.
(value,
range, offset)
Returns a value from a *&(!!$$ )% (! ,
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.