If you'd like to find the sum of your data data in rows A1 to A10 in your spreadsheet, you may do so by using the following formula:
If you are looking to add data in cells that are not juxtaposed, you may do so by simply typing =SUM and clicking directly on the cells you'd like to include. Make sure that the cells listed are surrounded by parenthesis (i.e. =SUM(A1, A3; C4)).
If you'd like to find the average of your data in rows A1 to A10 in your spreadsheet, you may do so by using the following formula:
Maximum and Minimum Formula
These two formulas may be used to find the maximum and minimum numbers of data points located in rows A1 to A10 in your spreadsheet:
The IF Function
The IF function may be used to apply a condition to your data. For example, if a manager would like to be notified when stock on a product reaches zero, he may use this function to program a custom notification to appear in an adjacent cell. This sort of formula would look like this:
IF(A1 <= 0; "ordering", "stock")
In this case, if the contents of cell A1 is less than or equal to zero, the words "to order" will appear in an adjacent cell. If the contents of cell A1 is greater than zero, the column will read "in stock."
A more general IF function would look like this:
= IF (condition; value "if true"; value "otherwise")
Freeze Cells in Excel
Once the cell is written, press F4 to see the details of the cell and dollars.
This document entitled « Basic Excel Formulas » from CCM (ccm.net) is made available under the Creative Commons license. You can copy, modify copies of this page, under the conditions stipulated by the license, as this note appears clearly.