Excel 2010 Creating Simple Formulas

Author: mety Labels::


ntroduction

Lesson 17 
Excel can be used to calculate numerical information. In this lesson you will learn how to create simple formulas in Excel to add, subtract, multiply, and divide values in a workbook. Also, you will learn the various ways you can use cell references to make working with formulas easier and more efficient.



Simple Formulas

Launch video!Watch the video (3:24). Need help?
formula is an equation that performs a calculation. Like a calculator, Excel can execute formulas that add, subtract, multiply, and divide.
One of the most useful features of Excel is its ability to calculate using a cell address to represent the value in a cell. This is called using a cell reference.
In order to maximize the capabilities of Excel, it is important to understand how to create simple formulas and use cell references.
Watch the video to learn about simple formulas in Excel 2010.

Creating Simple Formulas

Excel uses standard operators for equations, such as a plus sign for addition (+), a minus sign for subtraction (-), an asterisk for multiplication (*), a forward slash for division (/), and a caret (^) for exponents.
The key thing to remember when writing formulas for Excel is that all formulas must begin with an equal sign (=). This is because the cell contains, or is equal to, the formula and its value.
Standard operators 

To Create a Simple Formula in Excel:

  1. Select the cell where the answer will appear (B4, for example).
    Selecting cell B4Selecting cell B4
  2. Type the equal sign (=).
  3. Type in the formula you want Excel to calculate. For example, "75/250".
    Entering formula in B4Entering formula in B4
Press Enter. The formula will be calculated and the value will be displayed in the cell.
Result in B4Result in B4

Creating Formulas with Cell References

When a formula contains a cell address, it is called a cell reference. Creating a formula with cell references is useful because you can update data in your worksheet without having to rewrite the values in the formula.

To Create a Formula Using Cell References:

  1. Select the cell where the answer will appear (B3, for example).
    Selecting cell B3Selecting cell B3
  2. Type the equal sign (=).
  3. Type the cell address that contains the first number in the equation (B1, for example).
    Entering a formula in B3Entering a formula in B3
  4. Type the operator you need for your formula. For example, type the addition sign (+).
  5. Type the cell address that contains the second number in the equation (B2, for example).
    Entering a formula in B3Entering a formula in B3
  6. Press Enter. The formula will be calculated and the value will be displayed in the cell.
    Result in B3Result in B3
If you change a value in either B1 or B2, the total will automatically recalculate.
    To Create a Formula using the Point and Click Method:
      Result in B3Result in B3
      1. Select the cell where the answer will appear (B4, for example).
        Selecting cell B4Selecting cell B4
      2. Type the equal sign (=).
      3. Click on the first cell to be included in the formula (A3, for example).
        Clicking cell A3Clicking cell A3
      4. Type the operator you need for your formula. For example, type the multiplication sign (*).
      5. Click on the next cell in the formula (B3, for example).
        Clicking cell B3Clicking cell B3
    Press Enter. The formula will be calculated and the value will be displayed in the cell.
    Result in B4Result in B4

    To Edit a Formula:

    1. Click on the cell you want to edit.
    2. Insert the cursor in the formula bar and edit the formula as desired. You can also double-click the cell to view and edit the formula directly from the cell.
    3. When finished, press Enter or select the Enter command Cursor.
      Edit a formulaEdit a formula
    4. The new value will be displayed in the cell.
      ResultResult
    If you change your mind, use the Cancel command Cursor in the formula bar to avoid accidentally making changes to your formula.

    0 comments |

    Labels

    Blog Archive

    Powered by Blogger.

    I made these pages for me and my friends to help solving the problem we face regarding Computer & internet, if anyone wants me to answer a question or find out about some information please send me email and I will try to reply.*P.S. some of the article I wrote and the other I found on the internet I posted them in sprit of learning and shearing, please forgive me if you found something you don’t want to be in my blog, email me and I will delete them. Thank you for your interest in my pages.امل نجم Amal Nagm

    banner 1 banner 2