The ABS function is used in Excel to change the sign of the number to positive or its absolute value. Select a blank cell for locating the calculated percentage change then enter formula A3-A2A2 into the Formula. Percent Change New Value Old Value Old Value.
For example enter 736 into B1.
Heres the formula in cell C3. Type the following formula into any Excel cell. To find the percentage difference between any two numbers first subtract the smallest number from the bigger digit and then divide the outcome of subtraction with the smallest number among them. If you want to calculate a percentage of a number in Excel simply multiply the percentage value by the number that you want the percentage of.