Functions are tools you can use to analyze data and get information. In other words, functions help answer your questions so that you can evaluate and examine your business and make projections.
Excel uses straightforward formulas to perform simple calculations, such as adding or subtracting, on a number or series of numbers. For example, the formula =SUM(B4:B8) inserts the sum of the numbers contained in the range B4 to B8 into the cell containing the formula. These simple formulas are the foundation of many functions. Other functions combine several formulas or procedures to achieve a desired result.
Functions should be entered in the following basic order:
Start a function ...