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
 

All Powered by logos, trademarks and copyrights belong to their respective owners all over the world.