ODDLPRICE

ODDLPRICE(settlement, maturity, issue, first_coupon, rate, yld, redemption, frequency [,basis])

Returns the price per $100 face value of a security with an odd last period.

settlement	The settlement date of the security.
maturity	The maturity date of the security.
issue	The issue date of the security.
first_coupon	The first coupon date of the security.
rate	The interest rate of the security.
yld	The annual yield of the security.
redemption	The redemption value of the security per $100 face value.
frequency	The number of coupon payments per year: 1 = annual 2 = semi annual 4 = quarterly
basis	(Optional) The type of day counting to use: 0 = 30/360 (default) 1 = Actual/Actual 2 = Actual/360 3 = Actual/365 4 = 30E/360

REMARKS

* If "basis" is left blank, then 0 is used.
* If "basis" is not an integer, then it is truncated.
* If "basis" < 0, then #NUM! is returned.
* If "basis" > 4, then #NUM! is returned.
* You can use the ODDFPRICE function to return the price per $100 face value of a security with an odd first period.
* You can use the ODDFYIELD function to return the yield of a security with an odd first period.
* You can use the ODDLYIELD function to return the yield of a security with an odd last period.
* For the Microsoft documentation refer to support.microsoft.com

	A
1	??