This formula divides the value in cell A1 by the value in cell B1. Created with AutoSum the total neither in Cell B5 nor in Cell C5 is correct. Click the Percent Style button Home tab Number group to display the resulting decimal fractions as percentages.
How to calculate or get percentage of total in Excel.
Formatting applied to Column B restricts the display of percentages to whole numbers. Get amount with percentage In the example E6 cell contains this formula. For example enter 1500 into A1. Remember to increase.