This is shown in the formula below: =B3*1.05. Navigate to your worksheet. Further Examples of Calculating a Percentage of a Number Example 1 - Percentages of Various Numbers. This will calculate the % change in revenue between 2008 & 2009. 1. Copy and paste the formula to the remaining cells to see the year on percent change. Add a column for percentage Change year over year. Using cell references, if October’s bill amount of $125 is in cell B4 and November’s bill amount of $100 is in cell B5, your Excel formula for a percentage decrease would be =SUM(B5-B4)/B4. We will copy down the formula using the fill handle tool (the small box at the lower right corner of the cell) into the number of rows given. Therefore, the value 20% in the above calculation is evaluated as 0.2. Figure 2 – Drawing percentage in excel. If you want to add percentage sign to a number without multiplying the number by 100, such as to change 6 into 6% in Excel with Percentage Style, you should have the general number divided by 100 first, and then apply the Percentage Style to the numbers for displaying them as percentage 6% in Excel. 3. You can also just type the number in its decimal form directly into the cell—that is, type 0.1 and then apply percentage format. These formulas simply multiply the value by five percent more than the whole of itself (100 percent). Launch Excel. 1. Excel percentage formulas can get you through problems large and small every day. Markup Percentage Formula Markup in very simple terms is basically the difference between the selling price per unit of the product and the cost per unit associated in making that product. Procedure in Excel. The following spreadsheet shows various percentage calculations for different numbers. If you then format that decimal as a percentage, the number will be displayed as 10%, as you ‘d expect. Note that the % operator tells Excel to divide the preceding number by 100. So revenue has been decreased by -15.75% from 2008 to 2009. Apply the basic excel formula as (New Value – Old Value) / Old Value.. 4. Excel formula for percentage change for a year over year. To find the percentage change year over year: = ((This year’s value-last year’s value)/last year’s value*100 . So basically it is the additional money, over and above the cost of the product, which the seller would get. Add a zero at the topmost cell of the column since it coincides with the Beginning year. 2. We can quickly calculate the percentage change in our excel sheet across two columns using the steps below: We click on Cell F4 and enter the formula below =(D4-E4)/D4. As a result, a 20 percent increase would be multiplied by 120 percent, and a 15 percent increase would be 115 percent (or 1.15). Or we could write the formula as: =B3*105%. For example, if you type the formula =10/100 in cell A2, Excel will display the result as 0.1.