GCFLearnFree.org

This course is designed better than some classes I’ve taken in school.”

Online Learner

GCFGlobal.org
Creating Opportunities For A Better Life.®
  • All Topics
  • Excel 2003
  • Creating Complex Formulas

Excel 2003

Single page view print copy

Creating Complex Formulas

Complex formulas defined

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

5*3/2 Multiply 5*3 before performing the division operation because the multiplication sign comes before the division sign. The answer is 7.5.

5/3*2 Divide 5/3 before performing the multiplication operation because the division sign comes before the multiplication sign. The answer is 3.333333.

5/(3*2) Perform the operation in parentheses (3*2) first, and divide 5 by this result. The answer is 0.833333.

5+3-2 Add 5+3 before performing the subtraction operation because the addition sign comes before the subtraction sign. The answer is 6.

5-2+3 Subtract 5-2 before performing the addition operation because the subtraction sign comes before the addition sign. The answer is 6.

5-2*3 Multiply 2*3 before performing the subtraction operation because the multiplication sign is of a higher order than the subtraction sign. The answer is -1.

(5-2)*3 Perform the operation in parenthesis (5-2) first and then multiply by 3. The answer is 9.
previous next
previous 1 2 3 4 5 6 7 8 9 next
Terms Of Use

©1998-2014 Goodwill Community Foundation, Inc. All rights reserved.