The YIELD Function
It calculates the yield on a security that pays periodic interest.
2204, 2019
Category Archives: Functions
2204, 2019
The PRICEDISC Function
It calculates the price per $100 face value of a discounted security.
2204, 2019
The PRICEMAT Function
It calculates the price per $100 face value of a security that pays interest at maturity.
2204, 2019
The PRICE Function
It calculates the price per $100 face value of a security that pays periodic interest.
2204, 2019
The RECEIVED Function
It calculates the amount received at maturity for a fully invested security.
2204, 2019
The ACCRINTM Function
It calculates the accrued interest for a security that pays interest at maturity.
2204, 2019
The ACCRINT Function
It calculates the accrued interest for a security that pays periodic interest.
2204, 2019
The VALUE Function
It converts a text that represents a number to that number.
2204, 2019
The UPPER Function
It converts all the text to uppercase.
2204, 2019
The TRIM Function
Removes all the spaces from the text except the single spaces between words.
