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.

In this tutorial page, you will learn how to use all logical formulas in Excel with detailed explanations, examples and videos.

Logical Formulas in Excel | Rath Point

All Logical Formulas in Excel

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

AND Formula in Excel

BYCOL Formula in Excel

BYROW Formula in Excel

FALSE Formula in Excel

IF Formula in Excel

IFERROR Formula in Excel

IFNA Formula in Excel

IFS Formula in Excel

LAMBDA Formula in Excel

LET Formula in Excel

MAKEARRAY Formula in Excel

MAP Formula in Excel

NOT Formula in Excel

OR Formula in Excel

REDUCE Formula in Excel

SCAN Formula in Excel

SWITCH Formula in Excel

TRUE Formula in Excel

XOR Formula in Excel

Summary of all Logical Formulas in Excel

AND

Check if all conditions in a test are true.

BYCOL

Apply a LAMBDA function to each column and provides an array of the results.

BYROW

Apply a LAMBDA function to each row and provides an array of the results.

FALSE

FALSE as output.

Logical comparison between a value and your expectation.

IFERROR

User defined value if a formula error occurs.

IFNA

User defined value if #N/A error occurs.

IFS

Evaluate one or more conditions and provide the value corresponds to the first true condition.

LAMBDA

Create a custom reusable function and can be called by a user friendly name.

LET

Define unique names to the calculation results.

MAKEARRAY

Array of a specified row and column size by using LAMBDA function.

MAP

An array formed by mapping each value in the array to a new value by using LAMBDA function.

NOT

Check whether one value is not equal to another value.

Check whether one or more contritions are True, else results as False.

REDUCE

Reduce an array to an accumulated value by using LAMBAD function.

SCAN

Scan an array by using LAMBAD to each value and results an array having each itermediate value.

SWITCH

Compare one value with list of values and gets the result corresponds to the first matching value.

TRUE

TRUE as output.

XOR

TRUE if one condition is TRUE from multiple conditions, else results as FALSE.

» Financial Formulas

» Logical Formulas

» Text Formulas

» Date & Time Formulas

» Lookup & Ref Formulas

» Math & Trig Formulas

» Statistical Formulas

» Engineering Formulas

» Cube Formulas

» Information Formulas

» Compatibility Formulas

» Web Formulas