If the percentage is negative it means the sales of the product have decreased. If you want to calculate a percentage of a number in Excel simply multiply the percentage value by the number that you want the percentage of. Select cell C3 click on the lower right corner of cell C3 and drag it down to cell C13.
Cell E3 will have the CAGR value.
You then multiply the original price of 100 by 110 percent. For example if you want to calculate 25 of 50 multiply 25 by 50. On the Home tab in the Number group apply a Percentage format. Increase a number by a specified percentage this can be done by simply multiply the number by 1 the percentage increase.