Page 261 - Excel Data Analysis

14 537547 AppB.qxd 3/4/03 11:57 AM Page 247

EXCEL FUNCTION QUICK REFERENCE B

INFORMATION FUNCTIONS

FUNCTION DESCRIPTION
CELL(info_type[, reference]) Determines formatting, location, or contents of the specified cell.
ERROR.TYPE(error_val) Determines the error type for the selected cell.
INFO(type_text) Finds information about the current operating system.
ISBLANK(value) Checks for a blank cell.
ISERR(value) Checks for any errors except #N/A.
ISERROR(value) Checks for any errors.
ISEVEN(number) Checks if a number is even.
ISLOGICAL(value) Checks for a logical value.
ISNA(value) Checks for a #N/A value.
ISNONTEXT(value) Checks for any non-text value.
ISODD(number) Checks if a number is odd.
ISREF(value) Checks for a reference.
ISTEXT(value) Checks for text.
N(value) Converts a value to a number.
NA() Returns an error value of #N/A.
TYPE(value) Finds the type of the specified value.

LOGICAL FUNCTIONS

FUNCTION DESCRIPTION
AND(logical1[, logical2, ...]) Returns a value of True if all arguments evaluate to True.
FALSE() Returns a value of False.
IF(logical_test, value_if_true, [value_if_false]) Performs conditions based on whether a condition is True or
False.
NOT() Reverses the value of an argument.
OR(logical1[, logical2, ...]) Returns a value of True if any of the arguments evaluate to True.
TRUE() Returns a value of True.

247