Miscellaneous Functions

 Return to the Index
COUNTBLANK | ISBLANK | ISEVEN | ISLOGICAL | ISNONTEXT | ISNUMBER | ISODD | ISREF | ISTEXT | N | TYPE | AND | FALSE | IF | NOT | OR | TRUE

COUNTBLANK
Returns the number of cells that do not have a value or formulas that return "".

Syntax:

COUNTBLANK(range)

Range is any range of cells.

Example:

COUNTBLANK(A1:B3)
ISBLANK
Returns true if the value is "" or the cell does not have a value.

Syntax:

ISBLANK(value)

Value is any value, cell reference, or expression.

Example:

isblank("hi") equals false
ISEVEN
Returns true if the number is even.

Syntax:

ISEVEN(number)

Number is any real number.

Example:

iseven(2) equals true
ISLOGICAL
Returns true if the value is a logical value.

Syntax:

ISLOGICAL(value)

Value is any value, cell reference, or expression.

Example:

islogical(true() equals= true
ISNONTEXT
Returns true if the value is not text.

Syntax:

ISNONTEXT(value)

Value is any value, cell reference, or expression.

Example:

isnontext(3) equals true
ISNUMBER
Returns true if the value is a number.

Syntax:

ISNUMBER(value)

Value is any value, cell reference, or expression.

Example:

isnumber(3) equals true
ISODDD
Returns true if the number is odd.

Syntax:

ISODDD(number)

Number is any real number.

Example:

isoddd(3) equals true
ISREF
Returns true if the value is a cell reference.

Syntax:

ISREF(value)

Value is any value, cell reference, or expression.

Example:

isref("hi") equals false
ISTEXT
Returns true if the value is text.

Syntax:

ISTEXT(value)

Value is any value, cell reference, or expression.

Example:

istext("hi") equals true
N
Returns the value converted a number.

Syntax:

N(value)

Value is any value, cell reference, or expression.

Example:

n(3) equals 3.0
TYPE
Returns an integer indicating the type of a value.
    Value  Returns
    -----  -------
    Number    1 
    Text      2 
    Logical   4 
    Error    16 
    Array    64

Syntax:

TYPE(value)

Value is any value, cell reference, or expression.

Example:

type(3) equals 1
AND
Returns true if all arguments are true.

Syntax:

AND(logical1, logical2, ...)

logical1, logical2, ... is one or more logical values.

Example:

and(2 = 2, 3 >= 1) equals true
FALSE
Returns the logical false constant.

Syntax:

FALSE()

Example:

if(false() = "three", "five") equals five
IF
Returns one value if the condition specified evaluates to true and another value if it evaluates to false.

Syntax:

IF(condition, value_if_true, value_if_false)

Condition is a logical test to evaluate.
value_if_true is a value to return if condition is true.
value_if_false is a value to return if condition is false.

Example:

if(3 < 5, "three", "five") equals three
NOT
Returns the inverse of the logical value.

Syntax:

NOT(logical)

logical is a logical value.

Example:

not(3 > 5) equals true
OR
Returns true if any one argument is true.

Syntax:

OR(logical1, logical2, ...)

logical1, logical2, ... is one or more logical values.

Example:

or(1 < 2, 4 > 5) equals true
TRUE
Returns the logical true constant.

Syntax:

TRUE()

Example:

or(5 >= 5, false() = true()) equals true
Copyright 2003-2005 Diamond Edge, Inc. All rights reserved.