Logical Formulas in Excel

Logical formulas in Excel are used for decision making calculations. The logical formulas in Excel can compare more than one conditions and return the result as True or False by evaluating the arguments.

How to use Logical Formulas in Excel

The article in this webpage describes how to use the logical functions in Excel with the syntax, arguments, detailed explanation, and examples step by step.

Click on any of the below logical formulas in Excel to get the detailed information about it.

Function
Description
AND Function
Check if all conditions in a test are true.
BYCOL Function
Apply a LAMBDA function to each column and provides an array of the results.
BYROW Function
Apply a LAMBDA function to each row and provides an array of the results.
FALSE Function
FALSE as output.
IF Function
Logical comparison between a value and your expectation.
IFERROR Function
User defined value if a formula error occurs.
IFNA Function
User defined value if #N/A error occurs.
IFS Function
Evaluate one or more conditions and provide the value corresponds to the first true condition.
LAMBDA Function
Create a custom reusable function and can be called by a user friendly name.
LET Function
Define unique names to the calculation results.
MAKEARRAY Function
Array of a specified row and column size by using LAMBDA function.
MAP Function
An array formed by mapping each value in the array to a new value by using LAMBDA function.
NOT Function
Check whether one value is not equal to another value.
OR Function
Check whether one or more contritions are True, else results as False.
REDUCE Function
Reduce an array to an accumulated value by using LAMBAD function.
SCAN Function
Scan an array by using LAMBAD to each value and results an array having each itermediate value.
SWITCH Function
Compare one value with list of values and gets the result corresponds to the first matching value.
TRUE Function
TRUE as output.
XOR Function
TRUE if one condition is TRUE from multiple conditions, else results as FALSE.

Learn More

Function
Description
XLOOKUP Function
Search for a specified value from a table or range of cells.
DATEDIF Function
Number of days, months or years between two dates.

0 Comments

Logical Formulas in Excel

Excel Formulas (Category)

» Financial Formulas in Excel

» Logical Formulas in Excel

» Text Formulas in Excel

» Date and Time Formulas in Excel

» Lookup and Reference Formulas in Excel

» Math and Trig Formulas in Excel

» Statistical Formulas in Excel

» Engineering Formulas in Excel

» Cube Formulas in Excel

» Information Formulas in Excel

» Compatibility Formulas in Excel

» Web Formulas in Excel

Excel Tutorial Part 1 (Basic)

» Excel Basics

» Excel Home

» Excel Workbook

» Excel Template

» Excel Cell

» Excel Password

Excel Tutorial Part 2 (Format)

» Excel Clipboard

» Excel Format Font

» Excel Format Alignment

» Excel Format Number

» Excel Border

» Excel Conditional Formatting

Excel Tutorial Part 3 (Data)

» Excel Sort Data

» Excel Filter Data

» Excel Text to Columns

» Excel Data Validation

» Excel Flash Fill

» Excel Remove Duplicates

» Excel Relationships

» Excel Consolidate

» Excel What-If Analysis

» Excel Group

» Excel Charts

» Excel Table

» Excel PivotTable

Excel Tutorial Part 4 (Find)

» Excel Find and Replace

» Excel Go To

» Excel Select Objects

» Excel Selection Pane

Excel Tutorial Part 5 (Review)

» Excel Spell Check

» Excel Smart Lookup

» Excel Translate

» Excel Comments & Notes

» Excel Protect

» Excel Hide Ink

Excel Tutorial Part 6 (View)

» Excel Workbook Views

» Excel Formula Bar

» Excel Zoom

» Excel Window

» Excel Macros

Excel Tutorial Part 7 (Fx)

» Excel Formulas (Category)

» Excel Formulas (Alphabetical Order)

» Excel Errors

» Excel Name Manager

» Excel Formula Auditing

» Excel Watch Window

» Excel Calculation Options

Excel Tutorial Part 8 (Other)

» Excel Add-ins

» Excel Shortcuts