In Excel youll just replace the number values with the cell s in order to enter the formula for percentage change. Step 2 Press Tab then in B18 enter this Excel percentage formula. To calculate the percentage increase in Excel which must have at least two values.
Observe the formula B3 which is 450000 from that we subtracted B2 which is 400000 and the difference multiplied with 100 and divide the results with B2 which is base salary 400000.
For example if you want to calculate 20 of 500 multiply 20 by 500. In Excel youll just replace the number values with the cell s in order to enter the formula for percentage change. Calculating a percent change whether by hand or using the Excel formula for percentage change is a matter of finding the difference 2800 2175 dividing by the original value 2175 and converting to a percent x 100. As with any formula in Excel you need to start by typing an equal sign in the cell where you want your result followed by the rest of the formula.