# Lesson 6 - Lesson 6: Creating Complex Formulas Page 1 By...

This preview shows pages 1–4. Sign up to view the full content.

Lesson 6: Creating Complex Formulas Page 1 By the end of this lesson, learners should be able to: Create complex formulas Fill a formula to another cell Copy and paste a formula to another cell Revise a formula Create an absolute reference Page 2 Complex Formulas Defined Simple formulas have one mathematical operation. Complex formulas involve more than one mathematical operation. The order of mathematical operations is very important. If you enter a formula that contains several operations--like adding, subtracting and dividing--Excel 2003 knows to work those operations in a specific order. The order of operations is: 1. Operations enclosed in parenthesis 2. Exponential calculations (to the power of) 3. Multiplication and division, whichever comes first 4. Addition and subtraction, whichever comes first Using this order, let us see how the formula 120/(8-5)*4-2 is calculated in the following picture:

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
Before moving on, let's explore some more formulas to make sure you understand the order of operations by which Excel calculates the answer.

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
This is the end of the preview. Sign up to access the rest of the document.

## This note was uploaded on 07/12/2008 for the course CGS 2531 taught by Professor Desimone during the Spring '05 term at University of Florida.

### Page1 / 9

Lesson 6 - Lesson 6: Creating Complex Formulas Page 1 By...

This preview shows document pages 1 - 4. Sign up to view the full document.

View Full Document
Ask a homework question - tutors are online