This lesson is part of the paid course

Sign in to check whether your enrollment covers this lesson.

Sign inFree lessons
Module 02 · Excel & Google Sheets for Analysts22 min

References, IF and Logical Functions

Relative and absolute references, IF, IFS, AND, OR and nested logic kept readable.

By the end of this lesson you can

  • Write nested logical formulas
  • Debug a broken reference

Know someone who should take this course?

They will land on the course page with the free lessons open to them.

Lesson feedback

No ratings for this lesson yet.

Sign in to rate this lesson.

Sorting, Filtering and SlicersLookups — XLOOKUP, VLOOKUP and INDEX/MATCH