PRICEDISC
Financial

Returns the price per $100 face value of a discounted security

Syntax:

=PRICEDISC(settlement, maturity, discount, redemption, [basis])

Example:

=PRICEDISC("2/15/2023", "5/15/2023", 0.0525, 100)