Microsoft Office Tutorials and References
In Depth Information
YIELD
Returns the yield on a security that pays periodic interest.
Returns the annual yield for a discounted security, for example, a Treasury
bill.
YIELDDISC
YIELDMAT
Returns the annual yield of a security that pays interest at maturity.
* Indicates a function introduced in Excel 2013.
Table A-7: Information Category Functions
Function
What It Does
CELL
Returns information about the formatting, location, or contents of a cell.
ERROR.TYPE Returns a number corresponding to an error type.
INFO
Returns information about the current operating environment.
ISBLANK
Returns TRUE if the value is blank.
ISERR
Returns TRUE if the value is any error value except #N/A.
ISERROR
Returns TRUE if the value is any error value.
ISEVEN
Returns TRUE if the number is even.
ISFORMULA* Returns TRUE if there is a reference to a cell that contains a formula.
ISLOGICAL
Returns TRUE if the value is a logical value.
ISNA
Returns TRUE if the value is the #N/A error value.
ISNONTEXT
Returns TRUE if the value is not text.
ISNUMBER
Returns TRUE if the value is a number.
ISODD
Returns TRUE if the number is odd.
ISREF
Returns TRUE if the value is a reference.
ISTEXT
Returns TRUE if the value is text.
N
Returns a value converted to a number.
NA
Returns the error value #N/A.
SHEET*
Returns the sheet number of the referenced sheet.
Search JabSto ::




Custom Search