We can apply round off if there are multiple numbers after a decimal point. Now the equation is 10 77 100 37 100 429 percent. A product cost 25 last year and a similar product costs 30 this year.
Formula to Calculate Percentage Difference.
Measured value 1 0 0. The result is shown as 016 because cell C2 is not formatted as a percentage. Divide the decrease by the original number and multiply the answer by 100. After obtaining the results multiply the decimal number with 100 this result will represent the percentage difference.