PRICEMAT
Financial

Returns the price per $100 face value of a security that pays interest at maturity

Syntax:

=PRICEMAT(settlement, maturity, issue, rate, yld, [basis])

Example:

=PRICEMAT("2/15/2023", "5/15/2023", "11/15/2022", 0.061, 0.061)