Enter an old number in cell A1 and a new number in cell B1. The math to determine a percentage is to divide the numerator the number on top of the fraction by the denominator the number on the bottom of the fraction then multiply the answer by 100. Type the following formula into any Excel cell.
Enter an old number in cell A1 and a new number in cell B1.
Type the following formula into any Excel cell. In the Number tab of the resulting menu click Percentage. Formatting applied to Column B restricts the display of percentages to whole numbers. The formula in parentheses calculates the percentage which the remainder of the formula subtracts from the original amount.