This uses the default percentage formatting style for your computer system which might be exactly what you require. To format the result as a percentage click the Percent Style button in the Number section on the Home tab. If you want to increase a number by a certain percentage follow these steps.
On the Home tab in the Number group apply a Percentage format.
Select a blank cell for locating the calculated percentage change then enter formula A3-A2A2 into the Formula Bar and then press the Enter key. Increase New Number - Original Number. Percent change is a very common calculation in finance. The formula new_value-old_valueold_value can help you quickly calculate the percentage change between two numbers.