Inputting logs into Excel

  • Thread starter Thread starter The Red Cardinal
  • Start date Start date
T

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.
 
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 said:
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.
 
Back
Top