Excel – Formulas (Complex)

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.

Practice Worksheet

Excel 2007 Practice Worksheet-Complex Formulas-Inventory

Handout

Excel 2007 GCF – Creating Complex Formulas

Or, click here: http://www.gcflearnfree.org/excel2007/8.1

Complex Formulas

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

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s