Skip to main content
grasp.study
About
Explore
Pricing
Log in
Try it for free
Back to course
👋
Welcome to a Grasp lesson
Create a free account
to keep studying and create your own study path.
Get MIS Executive job
·
Module 3
Core Formulas for Conditional Logic
1
Cell References: Absolute, Relative, and Mixed
Use absolute ($A$1), relative (A1), and mixed (A$1, $A1) cell references correctly when copying formulas.
2
Categorize Data with IF and Nested IF Formulas
Write IF and nested IF formulas to categorize data based on logical conditions.
3
Multi-Criteria Aggregation with COUNTIFS and SUMIFS
Use COUNTIFS and SUMIFS to aggregate data based on multiple criteria.
4
IF-AND-OR: Complex Condition Logic
Combine logical functions (AND, OR) with IF statements for complex condition handling.
Previous module
Structuring Data with Excel Tables
Next module
Lookup Formulas for Data Retrieval