• 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


  • 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?


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


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

Peter Bartholomew

Well-Known Member
Other implementation of Hui's formula include
= LN(3500/2766) / LN(1.04) [mathematically preferred solution]
= 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?