sorry 'bout that....
here we go....
A bond has the following terms:

February 15, 1991, settlement date
November 15, 1999, maturity date
5.75 percent semiannual coupon
6.50 percent yield
$100 redemption value
Frequency is semiannual
30/360 basis

Cell A1 = PRICE("2/15/91","11/15/99",0.0575,0.065,100,2,0)
Cell A2 = YIELD("2/15/91","11/15/99",0.0575,95.04287,100,2,0)

Normally 0.065 is the result of cell A2 and 95.04287 is the result of
cell A1.
Now in this spreadsheet i have they let you enter a value and then the
value of cell A2 will change ( so i suppose it most look something like
this in cell A2: =YIELD("2/15/91","11/15/99",0.0575,A1,100,2,0)). But
if you type a value in cell A2 it will also change the value for cell
A1 (so that should look like
A1:=PRICE("2/15/91","11/15/99",0.0575,A2,100,2,0)) .

So somehow excel puts the formula back into the cell A1 or A2 after you
enter a value in it......without creating a circular
reference........and while leaving the result of the calculations in
the other cells.....

I hope this clarifies it a bit........


--
Jan Jansens
------------------------------------------------------------------------
Jan Jansens's Profile: http://www.excelforum.com/member.php...o&userid=26982
View this thread: http://www.excelforum.com/showthread...hreadid=401914