Introduction to Excel Yitzchak Rosenthal


Order of Operations Complex formulas


Download 0.67 Mb.
bet7/8
Sana15.06.2023
Hajmi0.67 Mb.
#1477741
1   2   3   4   5   6   7   8
Bog'liq
Excel-Formulas.8735609.powerpoint

Order of Operations

Complex formulas

Order of operations

  • When using several operations in one formula, Excel follows the order of operations for math.
    • first: all parentheses - innermost first
    • second: exponents (^)
    • third: all multiplication (*) and division (/). Do these starting with the leftmost * or / and work to the right.
    • fourth: all addition (+) and subtraction (-). Do these starting with the leftmost + or - and work to the right.

Please Excuse My Dear Aunt Sally

  • The sentence "Please excuse my dear aunt Sally" is a popular mneumonic to remember the order of operations: Menumonic Meaning
    • Please parentheses
    • Excuse exponents
    • My Dear mulitplication and division (going left to right)
    • Aunt Sally addition and subtraction (going left to right)

Order of operations

  • The value of 3 + 2 * 5 is 13 NOT 25!

Order of operations


3 + (100 - 20) / 10 - 6 * 2 / 4 + 9
3 + 80 / 10 - 6 * 2 / 4 + 9
3 + 8 - 6 * 2 / 4 + 9
3 + 8 - 12 / 4 + 9
3 + 8 - 3 + 9
11 - 3 + 9
8 + 9
answer: 17

Cntrl-`

  • To see the formulas in the worksheet
    • Press the Cntrl key at the same time as you press the ` key (i.e. Cntrl-`)
    • Press Cntrl-` again to see the values

Functions

What is a function?

  • A function is a "named operation"
  • Functions have
    • a name
    • parentheses
    • parameters/arguments inside the parentheses
      • The words parameter and argument mean the same thing
      • you can have many parameters for one function separated with commas (,)
      • The number of parameters is one more than the number of commas.

Download 0.67 Mb.

Do'stlaringiz bilan baham:
1   2   3   4   5   6   7   8




Ma'lumotlar bazasi mualliflik huquqi bilan himoyalangan ©fayllar.org 2024
ma'muriyatiga murojaat qiling