Wednesday, August 21, 2013

How to Format Equations in Multiple Cells in MS Excel


Simple Equations
1. Launch Microsoft Excel 2010.
2. Click 'File' and 'Save As.' Navigate to a saved document location if necessary and type a name for the new spreadsheet into the 'File Name' box. Click 'Save' to save the new spreadsheet.
3. Click in the cell that is going to contain the results of the equation.
4. Press the 'Equal' sign ('=') on the keyboard to begin creating the formula for the equation.
5. Click on the first cell that contains data for the equation. Press the 'Plus' key (' ') on the keyboard to begin an addition formula with the current cell as the first item to be added. Alternately use a different operator, such as the 'Minus' sign ('-'), 'Asterisk' key ('*') or the 'Slash' key ('/') to subtract, multiply or divide, respectively.
6. Click on the next cell in the equation and press 'Enter' if the equation ends with this cell or press another mathematical operator and click on an additional cell to continue the formula. Repeat as necessary until the formula is complete.
Complex Formulas
7. Launch Excel 2010 and open every workbook that contains information that will be used in the complex formula.
8. Click the cell where the answer to the complex formula will be displayed.
9. Click 'Insert Function' from the 'Formulas' tab on the toolbar.
10. Type the name of the function or operation into the 'Search for a Function' dialog box and click 'Go' or select a category of function from the pull-down menu to see a list of functions. Click on the function name and click 'OK' to launch the function wizard.
11. Click in the first box in the 'Function Arguments' box and then click once on the cell that contains the information requested by the dialog box. Repeat for each requested input and click 'OK' to create the formula. Click 'Help on This Function' for a more detailed explanation of the function and what is needed to complete it properly.

Blogger news