Syntax. RECEIVED(Settlement,Maturity,Investment,Discount,Basis)
All function arguments that concern a date use the date without the time; that is, fractions are rounded. The Basis argument also requires an integer, and decimal places are truncated.
If invalid dates are used or no numbers are entered where required, the function returns the #VALUE!
error. If invalid numbers are entered for nondate arguments, the function returns the #NUMBER!
error.
Examples. The following examples explain how to use the RECEIVED() function.
From the background information, you can read the equation as follows:
=RECEIVED("10/5/2010","10/7/2010",4958.33,5%,4)
to get to the result of $5,000. Usually this formula would use numbers located in cells and would use cell references.
Treasury Bonds. Treasury bonds represent a further example where anticipative interest yield is used. Take a look at the examples for the functions PRICEDISC() and YIELDDISC().