Question: how to calculate total amount with percentage in excel?
Answer: To find out, divide $20,000 by $125,000. Here's the formula in cell C2: =B2/A2. ...  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.