Jessie,
Have a look at the Price function in XL's help.
HTH.
Regards,
Kevin
paste of a portion XL Help on Price.
PRICE
Returns the price per $100 face value of a security that pays periodic
interest.
If this function is not available, run the Setup program to install the
Analysis ToolPak. After you install the Analysis ToolPak, you must enable it
by using the Add-Ins command on the Tools menu.
Syntax
PRICE(settlement,maturity,rate,yld,redemption,frequency,basis)
Settlement is the security's settlement date. The security settlement date
is the date after the issue date when the security is traded to the buyer.
Dates may be entered as text strings within quotation marks (for example,
"1/30/1998" or "1998/01/30"), as serial numbers (for example, 35825, which
represents January 30, 1998, if you're using the 1900 date system), or as
results of other formulas or functions (for example,
DATEVALUE("1/30/1998")).
Maturity is the security's maturity date. The maturity date is the date
when the security expires.
Rate is the security's annual coupon rate.
Yld is the security's annual yield.
Redemption is the security's redemption value per $100 face value.
Frequency is the number of coupon payments per year. For annual payments,
frequency = 1; for semiannual, frequency = 2; for quarterly, frequency = 4.
Basis is the type of day count basis to use.
