TRUE Function in Excel: The Logical Value TRUE
TRUE() returns the logical value TRUE. You can also just type TRUE; the function form exists for compatibility.
Read article →Logical
Excel Logical functions explained with syntax, examples and common mistakes.
📊
← Excel
Logical
Excel Logical functions explained with syntax, examples and common mistakes.
📄 19 articles⬇️ 17 with practice files🕒 Updated 13 Oct 2026
🎓 Start here: Excel for India Course → 🎓 Start here: Excel Course: Beginner → Expert → 🎓 Start here: Bank Statement Automation →FALSE Function in Excel: The Logical Value FALSE
FALSE Function in Excel: The Logical Value FALSE
FALSE() returns the logical value FALSE, most often seen as the exact-match argument in VLOOKUP.
Read article →MAKEARRAY Function in Excel: Generate a Grid From Row and Column Numbers
MAKEARRAY Function in Excel: Generate a Grid From Row and Column Numbers
MAKEARRAY builds an array of a given size, computing each cell from its row and column number.
Read article →BYCOL Function in Excel: Apply a Calculation to Each Column
BYCOL Function in Excel: Apply a Calculation to Each Column
LogicalLevel: ExpertAvailable in: Excel 365 / 2021+BYCOL is BYROW turned sideways: one result per column.Syntax=BYCOL(array, LAMBDA(col.
Read article →SCAN Function in Excel: Running Totals in One Formula
SCAN Function in Excel: Running Totals in One Formula
SCAN walks through an array carrying an accumulator and returns every intermediate result — running totals, running balances, running max.
Read article →BYROW Function in Excel: Apply a Calculation to Each Row
BYROW Function in Excel: Apply a Calculation to Each Row
BYROW runs a LAMBDA on each row of an array and returns one result per row — row totals, row maximums, row checks.
Read article →MAP Function in Excel: Transform Every Value in an Array
MAP Function in Excel: Transform Every Value in an Array
MAP applies a LAMBDA to every item of one or more arrays and returns an array of results.
Read article →LAMBDA Function in Excel: Create Your Own Excel Functions
LAMBDA Function in Excel: Create Your Own Excel Functions
LAMBDA turns a formula into a reusable custom function. Save it in Name Manager and use it like any built-in function — no VBA.
Read article →LET Function in Excel: Name Parts of a Formula
LET Function in Excel: Name Parts of a Formula
LET assigns names to calculations inside a formula, so long formulas become readable and repeated parts are calculated once.
Read article →IFNA Function in Excel: Handle “Not Found” Only
IFNA Function in Excel: Handle “Not Found” Only
IFNA replaces only #N/A — the “not found” result of lookups — and lets real errors show.
Read article →REDUCE Function in Excel: Boil an Array Down to One Result
REDUCE Function in Excel: Boil an Array Down to One Result
REDUCE is SCAN that returns only the final result — useful for repeated clean-up steps.
Read article →SWITCH Function in Excel: Match One Value Against a List
SWITCH Function in Excel: Match One Value Against a List
SWITCH compares one value with a list and returns the matching result — cleaner than nested IFs for exact matches.
Read article →