Syntax. RECEIVED(Settlement,Maturity,Investment,Discount,Basis)

Definition. This function determines the repayment amount of a deposit resulting from a simple anticipative deduction of accrued interest.


  • Settlement (required) The day on which the deposit (investment on the buyer side, borrowing on the seller side) is made

  • Maturity (required) The date when the repayment of the deposit takes place

  • Investment (required) The amount of the deposit (the loan)

  • Discount (required) Specifies the percentage of the discount rate

  • Basis (optional) Defines the method you want to use for determining the days in the year according to Table 15-2, shown earlier

All function arguments that concern a date use the date without the time; that is, fractions ...

Get Microsoft® Excel® 2010 Formulas & Functions Inside Out now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.