The trick is to figure out which of your values belong to A and to B. An increase of 5 percent would indicate that if you split the original value into 100 parts that value has increases by an additional 5 parts. This is 40 more increase.
How to Show a Percentage Increase Between Two Numbers Subtraction Method 1.
The basic mathematical approach for calculating a percentage increase is to subtract the second number from the first number. For calculating the percentage increase we need to formulate a function that first calculates the increase in the new Value and then calculates the ratio that has been occupied by the new value. 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. The trick is to figure out which of your values belong to A and to B.