Microsoft Excel features mathematical functions that allow you to calculate different complex mathematical values quickly. For example, the SUM function allows you to find the sum of a group of numbers without requiring you to calculate them manually. Excel does all the required calculations for you and then displays the result. In the same way, you can calculate the percentage of a set of numbers in Excel. The Sum and percentage functions are available in all the versions of Excel (like 2010, 2007 and so on).
Instructions
1. Click the "Start" button on the taskbar, point to "All Programs" and then click "Microsoft Excel."
2. Click in an empty cell on the spreadsheet document in which you want the percentage value to be displayed (for example, B12).
3. Type "=(total_value/number_of_values)*100" in cell B12 to get the percentage. Here, replace total_value with the total sum of the numbers whose percentage you want to calculate and number_of_values with the number of individual values. For example, to calculate the percentage of 12, 22, and 32, type "=(66/3)*100". Here, 12+22+32=66 and there are 3 individual values (12,22,32).
4. Type "=((second_number-first_number)/ABS(first_number))*100" in an empty cell on the spreadsheet were you want to calculate the difference between two numbers as a percentage. Here, replace first_number with the first of the two numbers whose difference you want as percentage and second_number with the second number. For example, to calculate the difference between 32 and 42 as percentage, type "=((42-32)/ABS(32))*100" in the cell.
Tags: calculate difference, calculate difference between, calculate percentage, cell spreadsheet, difference between, empty cell, empty cell spreadsheet