Wednesday, August 15, 2012

How to Figure Percentage Using Excel


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.

Blogger news