Compound Annual Growth Rate, or CAGR ... is signified by dollar signs ($) preceding the letter and number of the cell. And so our formula begins at year 1, and looks like this (note the dollar ...