> i have invested $77,000 at an interest rate of 1.05% compounded daily. i want
> to create a formula showing the yield at the end of 5 years (by day).
Thank you John. I input the formula in cell A1, and all I got for an answer
is the formula. Please, what am I edoing wrong?
> > i have invested $77,000 at an interest rate of 1.05% compounded daily. i want
> > to create a formula showing the yield at the end of 5 years (by day).
[quoted text clipped - 19 lines]
>
> John
MDubbelboer - 19 Jul 2006 23:10 GMT
make sure the cell that you've put the formula in is formatted a
general
then recalculate your cell (press f2 to edit, then press enter
John - 22 Jul 2006 05:17 GMT
What formula did you put in the cell?
Try this.
In a2 put =power(1.000136986,a1)*77000
Put the mumber of days in a1 and the principal will appear in a2... did
for me anyway.
John
> Thank you John. I input the formula in cell A1, and all I got for an answer
> is the formula. Please, what am I edoing wrong?
[quoted text clipped - 22 lines]
>>
>>John