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
Search JabSto ::




Custom Search