[Affiliate]
Blog Stats
- 3,313,648 hits
-
Join 3,247 other subscribers
- Follow wmfexcel on WordPress.com
Search wmfexcel
Want Google to translate this page?
-
Recent Posts
Top Posts & Pages
- Show number in thousand (k) or in million (M) by using custom format
- Date Formats - A trick to format date with "st", "nd", "rd", "th"
- Dropdown calendar in Excel
- #Excel Add current selection to filter. What it does?
- #Excel IMAGE function is great, but...
- When unhide row doesn't work...
- Highlight weekends and holidays using Conditional Formatting in #Excel
- Elevate Your Career Through Excel MVP Leila Gharani
- Split text with delimiter(s) into columns or rows and even table with TEXTSPLIT in #Excel365
- Combine contents in a range of cells into a singe cell, with TEXTJOIN function in #Excel365
My YouTube Channel
My Facebook page
- My Tweets
Tag Archives: ABS
Calculating CAGR with Goal Seek in #Excel
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
Calculating % Change is so easy… to make a mistake!
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
wmfexcel 