In Excel, there are a few different ways to calculate the percentage difference between two numbers.
One way is to use the following formula: =(New Value - Old Value) / Old Value
The formula above will give you the decimal equivalent of the percentage difference. To convert it to a percentage, you can multiply the result by 100 and add the "%" symbol.
For example, if you have two numbers in cells A1 and B1, you can use the formula =(B1-A1)/A1*100 to calculate the percentage difference.
Another way to calculate the percentage difference in Excel is to use the "FORMULATEXT" function. This function allows you to display the formula used to calculate a value in a cell. For example, if you have used the above formula in cell C1, you can use the formula =FORMULATEXT(C1) in another cell to display the formula used to calculate the percentage difference.
Lastly, you can also use the "PERCENTDIF" function, which is a built-in function in Excel. The formula for this function is =PERCENTDIF(old_value,new_value)
It's important to note that when calculating percentage difference, you should always double check if it is relative to the old value or the new value, since it can give you different results.