2. Formulas & Functions.pptx - 2 Formulas Functions Printing HM 271 Todays objectives Create a formula Use a function(Numeric,Text,Date Reference

2. Formulas & Functions.pptx - 2 Formulas Functions...

This preview shows page 1 - 18 out of 41 pages.

2. Formulas & Functions Printing HM 271
Image of page 1
Today’s objectives Create a formula Use a function (Numeric,Text,Date) Reference cells Name ranges Print on excel
Image of page 2
Image of page 3
Formulas & Functions Formulas Arithmetic operators Comparison operators Functions Numeric Text Date
Image of page 4
FORMULAS
Image of page 5
+ - * / % ^
Image of page 6
Order of Operation (Reminder)As in Mathematics, Excel solves expressions in the following order:1.Expressions between parentheses2.Roots & Exponents3.Multiplications or Divisions4.Addition or SubtractionRemember, every formula/function starts with the = sign
Image of page 7
100 + 50 + 50 / 2 =
Image of page 8
100 + 50 + 50 / 2 =
Image of page 9
100 + (50 + 50) / 2 =
Image of page 10
100 + (50 + 50) / 2 =
Image of page 11
( 100 + 50 + 50) / 2 =
Image of page 12
( 100 + 50 + 50) / 2 =
Image of page 13
Equal sign [ =A1=A2 ] Returns TRUE if the value in cell A1 is equal to the value in cell A2, returns FALSE otherwise . Inequalities [ =A1>A2 ] Returns TRUE if the value in cell A1 is superior to the value in cell A2,returns FALSE otherwise. [ =A1<A2 ] A1 less than A2 [ =A1<>A2 ] A1 different from A2 [ =A1>=A2 ] A1 more than or equal to A2 [ =A1<=A2 ] A1 less than or equal to A2 Comparison Operators TRUE otherwise FALSE
Image of page 14
Value of Cell A1 = 10 X 50 + 2 Value of Cell B1 = 250 + 125 X 2 + 1 The formula: =A1=A2 returns the value A: True B: False
Image of page 15
Value of Cell A1 = 10 X 25 X 2 + 2 ----------------------> 502 Value of Cell B1 = 250 + 125 X 2 + 1 -------------------> 501 The formula: =A1=A2 returns the value A: True B: False
Image of page 16
FUNCTIONS
Image of page 17
Image of page 18

You've reached the end of your free preview.

Want to read all 41 pages?

  • Spring '16

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture