Back to METIS

1pixel2.gif (807 bytes)

Start Menu

mAd cOw Adventure

app_index.jpg (9684 bytes)

 

 

 excel_appl.jpg (6445 bytes)
Using Functions
Functions are ready-to-use formulas that perform calculations on your spreadsheet data.

A function always begins with the equals sign (=). The data to be calculated is enclosed in parenthesis ( ).

functions.gif (5247 bytes)

 
When there is a comma (,) between cell references in a function, each cell is used individually to perform the calculation.

Example:
=SUM(A1,A2,A3) is the same as the formula =A1+A2+A3

When there is a colon (:) between cell references in a function, each cell and all those between are used to perform the calculation.

Example:
=SUM(A1:A3) is the same as the formula =A1+A2+A3


For some common function click here.

back.gif (366 bytes)next.gif (356 bytes)