Use this button to insert a CAGR formula in the selected cell. When you click the CAGR button, UpSlide will display the form shown as below. With it, you can choose the data range and select the correct type of data.
The CAGR is computed using the formula below.
The source data range must:
- have only one dimension (row or column)
- contain at least two cells with numerical data
- contain only blank or numerical cells
When the form is first loaded, UpSlide tries to determine automatically which cells should be used to compute the CAGR by looking at the cells on the left of the selection. In the example above, UpSlide would automatically detect the data range.