Archive for the ‘Formulas’ Category

Tip: Formula to Format Telephone Numbers

Wednesday, November 7th, 2007

I just found this great formatting tip over on the Apple Numbers discussion boards. A poster had the following problem: He had a series of phone numbers formatted as 10 digits (i.e. 5035551212). He wanted to re-format the numbers to read as (503) 555-1212. 5|=vv (who is also a frequent ...

Formulas: Calculating Compound Annual Growth Rate (CAGR) in Numbers

Friday, August 17th, 2007

The compound annual growth rate measures the growth rate of an investment as if it grew at a steady rate over time. For example, a savings account that pays a 3.00% APY will grow at three percent, year after year, until the bank changes the rate. Therefore, the CAGR on ...