GCFLearnFree.org

I wish I would have found you ages ago.”

Online Learner

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

Excel 2007

Single page view print copy

Creating Complex Formulas

Complex formulas

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

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

4/2*4 Divide 4 by 2 before performing the multiplication operation because the division sign comes before the multiplication sign. The answer is 8.

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

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

previous next
previous 1 2 3 4 5 6 next
Terms Of Use

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