Inputting logs into Excel

[The Red Cardinal]

Hi,

I need to enter the following formula into an excel spreadsheet:

n = (-log(1-iA/P)) / log(1+i)

It seems I can use any base for the log as long as both are the same. The
variables all refer to cells and are referenced in the sheet.

Can anybody help me please?

Thanks in advance.

 

[Orlando Magalhães Filho]

Hi,

If iA is on A1 cell, P is on A2 cell, i is on A3 cell and n is on A4 cell
then insert on A4 cell this formula:
= (-LOG(1-A1/A2,10))/LOG(1+A3,10)
or
= (-LOG(1-A1/A2))/LOG(1+A3)

HTH

 

[The Red Cardinal]

Hi,

If iA is on A1 cell, P is on A2 cell, i is on A3 cell and n is on A4
cell then insert on A4 cell this formula:
= (-LOG(1-A1/A2,10))/LOG(1+A3,10)
or
= (-LOG(1-A1/A2))/LOG(1+A3)

HTH

---
Orlando Magalhães Filho

(So that you get best and rapid solution and all may benefit from the
discussion, please reply within the newsgroup, not in email)

Cheers - worked a treat.