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

2. Formulas & Functions
Printing
HM 271

Today’s objectives
 Create a formula
 Use a function (Numeric,Text,Date)
 Reference cells
 Name ranges
 Print on excel

Formulas & Functions
Formulas
•
Arithmetic operators
•
Comparison operators
Functions
•
Numeric
•
Text
•
Date

FORMULAS

+
-
*
/
%
^

Order of Operation
(Reminder)
As in Mathematics, Excel solves expressions in the following order:
1.
Expressions between parentheses
2.
Roots & Exponents
3.
Multiplications or Divisions
4.
Addition or Subtraction
Remember, every formula/function starts with the = sign

100 + 50 + 50 / 2 =

100 + 50 + 50 / 2 =

100 + (50 + 50) / 2 =

100 + (50 + 50) / 2 =

(
100 + 50 + 50) / 2 =

(
100 + 50 + 50) / 2 =

 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

 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

 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

FUNCTIONS