Microsoft Excel is a spreadsheet application created for both the Microsoft Windows and Apple Mac OS X operating systems. In addition to providing a framework for collecting and organising data, the program features tools to help users with simple and complex calculations, charts and graphs, and the development of automated programming tasks using macros. Though the method may not be obvious at first glance, calculating the percentage of two cells in Excel is a simple task.
- Skill level:
Other People Are Reading
Open Microsoft Excel.
Create your first data point. For the purpose of this example, assume you want to find out what percentage of your total business income was earned in the months of March and April. Enter "March" (without quotation marks) in cell A1, then press the "Tab" key and enter "8,500" (again without quotation marks) in cell B1.
Create your second data point. Press the "Enter" key to move your cursor to cell A2. Enter "April," press the "Tab" key, then press "8,750" in cell B2.
Add your data points. Move your cursor to cell B3, directly below your two number values. Enter the following formula into this cell to sum the two values:
Calculate the percentage of the total. Double-click cell B3 to edit its contents, then add a "/" character and the total value by which the preceding cells should be divided. For this example, assume your annual business revenue is £74,750. Your formula should now look like this:
The formula tells Excel to take the sum of the values in cells B1 and B2 and divide them by the total yearly revenue value of £74,750. Press "Enter" after inputting the revised formula to return your final percentage (0.15, or 15 per cent, in this example).
- 20 of the funniest online reviews ever
- 14 Biggest lies people tell in online dating sites
- Hilarious things Google thinks you're trying to search for