ExcelBanter - Rate of return required formula

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Rate of return required formula (https://www.excelbanter.com/excel-worksheet-functions/6617-rate-return-required-formula.html)

Alorasdad

Rate of return required formula

I need to know the formula for determinining the required interest rate to
achieve a pre-determined dollar value. For instance, I have a value in cell
D14 and I want to see the interest rate required to achieve the dollar value
represented in cell D6

Fred Smith

Use the Rate function

=rate(#periods,0,D4,-D6)

--
Regards,
Fred
Please reply to newsgroup, not e-mail

"Alorasdad" wrote in message
...
I need to know the formula for determinining the required interest rate to
achieve a pre-determined dollar value. For instance, I have a value in
cell
D14 and I want to see the interest rate required to achieve the dollar
value
represented in cell D6

All times are GMT +1. The time now is 06:44 PM.