Wednesday, December 11, 2013

How to Set Up Formulas in Excel 2007


1. Click the cell where you want to display the results.
2. Press '=' on your keyboard to start a formula.
3. Add a parenthesis and the name of the first cell you want to include in your formula. For example, your formula to this point should look something like this: =(A1
4. Add the operator -- ' ,' '-,' '*' or '/' -- you want this formula to perform. For example, =(A1
5. Type the location of the next cell for your formula and repeat Steps 3 and 4 -- minus the parenthesis -- until you have listed all the cells you want to include in your formula. For example, =(A1 A2 B1 B2 C1 C2
6. Add a closing parenthesis and press 'Enter.' Your results should appear.

Blogger news