⚖️ Logical Functions
Master the art of decision making in Excel. From basic True/False checks to complex branching logic.
🤔
Beginner
01. IF Function
The foundation of logic. Learn how to ask a question and do one thing if True, and another if False.
🔀
Modern
02. IFS Function
Stop nesting! Check multiple conditions in a single, clean formula. The modern replacement for Nested IFs.
⛓️
Essential
03. AND / OR / NOT
Combine multiple questions. Check if ALL conditions are met (AND) or if ANY are met (OR).
🌗
Advanced
04. XOR (Exclusive OR)
The logic of "One or the other, but not both." Useful for strict toggles and parity checks.
🎛️
Intermediate
05. SWITCH
Swap values easily. "If 1=Low, 2=Med, 3=High". Cleaner than IF for exact matches.
🛡️
Essential
06. IFERROR
Catch errors like #DIV/0! or #N/A and replace them with friendly text or a 0.
🎯
Specific
07. IFNA
Specifically catches #N/A errors from Lookups, while letting real calculation errors bubble up.
💡
Concept
08. TRUE / FALSE
Understanding Boolean logic. How Excel sees 1 as TRUE and 0 as FALSE in math operations.
⬅ Back to Excel Menu