What is RECEIVED function in Excel? RECEIVED function is one of Financial functions in Microsoft Excel that returns the amount received at maturity for a fully invested security. Syntax of RECEIVED function RECEIVED(settlement, maturity, investment, discount, [basis]) The RECEIVED function syntax has the following arguments: Settlement: The security’s settlement date. The security settlement date is the date after the issue date…