Function Type: Financial
Description:
Returns the price per $100 face value of a security that pays interest at maturity.
Function Structure:
=PRICEMAT(settlement, maturity, issue, yld, [basis]).
Argument Breakdown:
settlement – The security’s settlement date. The security settlement date is the date after the issue date when the security is traded to the buyer.
maturity – The security’s maturity date. The maturity date is the date when the security expires.
issue – The security’s issue date, expressed as a serial date number.
yld – The security’s annual yield.
basis – The type of day count basis to use.
Example:
Still need help with Excel and Google Sheets? Get Instant Expert Help in Fiverr or PeoplePerHour platforms. Click one icon below.
We can also accept LEO, HIVE, HBD tokens as payment if we transact directly here in HIVE network.
or you can help me through https://www.buymeacoffee.com/cashheaven 😉
One thought on “PRICEMAT”