Cell Reference Review and Functions

Table of Contents

Cell Reference Review and Functions

Relative Address

Relative Address

Absolute Address

The Special Chars $ and ,

Mixed Address

Functions

Functions

Understanding Functions

The Function SUM

Using the Wizard Function

Using the Wizard Function

PPT Slide

PPT Slide

PPT Slide

Decision Making in Excel

Using the If Function

Relational Operators

Condition

Actions

The If Function Format

If Example

If Example

If Example

Text Actions in If Functions

Text Actions

Text Comparison in an If Function

More Complex Decisions

AND Function

OR Function

Evaluating Complex Decisions

Evaluation Order

Order

Complex examples

Other Counting Techniques

Other Countif Examples

Handout

Questions

Email: dmz@cs.bsu.edu

Home Page: http://www.cs.bsu.edu/homepages/dmz/cs104/lecture/