News Update :
Home » » Create a formula in Excel

Create a formula in Excel

By: omer nawaz on Friday, 1 November 2013 | 22:14

Formulas are equations that perform calculations on values ​​in your Excel Work Book.

A formula starts with an equal sign (=). 
1 / create a simple formula
  • click in a cell
  • then type    = 5 * 6 9
  • the following formula multiplies 6 by 9 and adds 5 to the result.
2 / create a formula that refers to other cells

Example formulaEffect
= C2Uses the value in cell C2
= Sheet2! B2Uses the value of cell B2 on Sheet2
  1. Click the cell in which you want to enter the formula.
  2. in the formula bar,

     
  3. type  = (equal sign).
  4. then select a cell (or a range of cells, a location on another worksheet ..)
  5. press enter
  6. add a "logical operator" 
    eg +, -, / ...
  7. and repeat as often as necessary with other cells

Post a Comment

 
Contact Us | Privacy policy | Term of use | Advertise with Us | Site map
Copyright © 2011. Blogging Brain . All Rights Reserved.
Design Template by Blogging Brain | | Powered by Blogger