Excel is a spreadsheet application and is intended to be used to calculate and analyze numerical information such as household budgets, company finances, inventory, and more. To do this, you need to understand formulas.
In this lesson, we’ll discuss complex formulas that use multiple mathematical operators, and that use absolute and relative references.
Or, click here: http://www.gcflearnfree.org/excel2007/8.1
Complex Formulas Defined
Simple formulas have one mathematical operation. Complex formulas involve more than one mathematical operation.
Simple Formula: =2+2 Complex Formula: =2+2*8