Microsoft Office Tutorials and References

In Depth Information

**Financial Functions**

Returns the present value for a schedule of cash flows that are not

necessarily periodic.

XNPV

Returns the yield of the security based on a yield that pays

periodic interest.

YIELD

Returns the annual yield for a discounted security.

YIELDDISC

Returns the annual yield based on a security that pays interest at

maturity.

YIELDMAT

Information Functions

CELL

Returns information about a cellâ€™s location, formatting, or contents

in the upper-left cell in a reference.

Counts the number of empty cells in a specified range.

COUNTBLANK

Returns the corresponding number value associated with an error

type in Microsoft Excel.

ERROR.TYPE

Returns operating environment information.

INFO

Returns the value associated with the number of empty cells.

ISBLANK

Returns the error value associated with an error in Microsoft

Excel, except
#NA
.

ISERR

Returns the error value associated with an error in Microsoft

Excel.

ISERROR

Returns
TRUE
or
FALSE
if the number is even or odd,
TRUE
being

even and
FALSE
being odd.

ISEVEN

Returns
TRUE
if the value is logical.

ISLOGICAL

Returns the value associated with the error type
#NA
.

ISNA

Returns the value of any item that is nontext and returns
TRUE
if

the value refers to a blank cell.

ISNONTEXT

Returns a value if the cell has a number.

ISNUMBER

Returns
FALSE
if the number is even and
TRUE
if the number is odd.

ISODD

Returns the value associated with a reference.

ISREF

Returns the value converted to a number.

N

Returns the error value associated with
#NA
.

NA

Returns the type of value, for example, Number = 1, Text = 2,

Logical Value = 4, Error Value = 16, and Array = 64. Use type

when the behavior of another function depends on the type of

value in a particular cell.

TYPE

Returns the logical value
TRUE
or
FALSE
associated with text.

U