• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Are there solutions of algorithms in Excel?

Hui

Excel Ninja
Staff member
You can use Goal Seek but a better solution is to derive the solution from a formula by rearrangement

Logs use the function
a = b^c <=> c=Logb(a)

If you have 3500/2766 = 1.04^n

c=log1.04(3500/2766)

so in Excel in a cell type: =Log(3500/2766, 1.04)
=6.00093
 
Last edited:

Peter Bartholomew

Well-Known Member
Other implementation of Hui's formula include
= LN(3500/2766) / LN(1.04) [mathematically preferred solution]
and
= LOG(3500/2766, 10) / LOG(1.04, 10) [pre-computer era 'sums']

Out of curiosity, why does the example calculation result in a value so close to the integer 6?
Does the calculation represent 6 years growth, say?
 
Top