Although theres no basic percentage formula in Excel you can multiply a number by a percentage using a formula. You can then increase or decrease the the decimical place as needed. In A18 type the header With 8 increase.
Percent Change B - A A When applying this formula to real data it is important that you correctly determine which value is A and which is B.
Calculating the percentage increase shows how much there has been a change in the value but in terms of percentage increase instead of showing the delta as a Value. This is shown in the formula below. To calculate the percentage increase in excel is easy as this requires the use of a simple formula that can be easily designed. 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.