RECEIVED
Financial

Returns the amount received at maturity for a fully invested security

Syntax:

=RECEIVED(settlement, maturity, investment, discount, [basis])

Example:

=RECEIVED("2/15/2023", "5/15/2023", 1000000, 0.09)