For this example the formula you would use is A1 1-B1. 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. How to Calculate a Percentage of a Number.
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.
Format the calculation as a percentage by using the icon on the Home tab. C6 C11. Whether with Excel or with pencil and paper the way to calculate a percentage of total is with a simple division. In the example below column B shows travel expenses for the year and a yearly total using the SUM function.