Tag Archives: ABS

Calculating CAGR with Goal Seek in #Excel

Posted on October 10, 2018 by MF

when the starting point is a negative number… Calculating CAGR is not difficult, all we need is the starting value, ending value and the number of periods.  Then we use the formula: CAGR = (Ending Value / Beginning Value ) … Continue reading →

Rate this:

Posted in Excel Tips | Tagged , | 1 Comment

Calculating % Change is so easy… to make a mistake!

Posted on November 30, 2013 by MF

How to calculate percentage change with negative number? I believe calculating percentage change should have a very top ranking on the most frequently used calculations in spreadsheet.  Agree? For me, I often simply do the calculation with a simple formula: … Continue reading →

Rate this:

Posted in Excel Tips, Formula | Tagged | Leave a comment