Excel Formulas

 

All formulas must begin with the equal sign (=)

 

Adding Formulas

• Click on the cell where you want the formula
• Type =(
• Click in the first cell you want to be in the equation
• Enter the operator

+	Addition
-	Subtraction
*	Multiplication
/	Division

• Click on the next cell you want in the formula
• Type ) to finish the formula

 

Examples:

                        = (RC[-2]      *  R[1]C[-2])

                        = (R[-11]C    + R[-10]C)

                        = (R[2]C[-2]  + R[-1]C[-2] - RC[-2])

 

Creating Formulas with Functions

• Click on the cell where you want the formula
• Type =
• Enter the function

SUM	Sum the cells
AVERAGE	Average cells
COUNT	Counts the numbers in cells
MAX	Finds the highest number
MIN	Finds the lowest number

• Type (
• Click in the first cell you want to be in the equation

• Type , if you want to enter a single cell ; type : if you want to enter a range of cells
• Click the next cell you want in the equation
• Type , if you want to enter another cell and then click on the next cell
• Type ) after the last cell

 

 

Examples:

                        =SUM (R[-6]C : R[-2]C)

                        =AVERAGE (R[-9]C , R[-7]C , R[-6]C)

 

Dragging Formulas

• Enter the first formula in the cell
• Click on the lower right corner of the cell with the formula until the + sign appears
• Click and drag to select all the cells where you want the formula to appear

 

Naming Ranges

• Click on the cell(s) you want to name
• Click in the Range box                               
• Type the name for the cell(s)
• Hit Enter
• You can perform calculations based on range names rather than by cells (i.e. price-cost)

Setting Values or Formulas

• Insert Þ Name Þ Define
• Insert the Name in the Names in Workbook box
• Type the value or formula in the Refers to box    
• Click OK

 

 

  

 

 

05/09/2000

RLS