how do i calculate a percentage saving in excel?
Here's the formula in cell C2: =B2/A2. The result is shown as 0.16 because cell C2 is not formatted as a percentage. To format 0.16 as a percentage, (which will also remove the zero) on the Home tab, click the Percentage button. If you are using Excel for the web, click Home > Number Format > Percentage.