Logical
★ 10 · ◉ 20 · All versions
=FALSE()
Returns the logical value FALSE.
=FALSE()
Conditional Logic
Conditional Logic
10 functions for this use case · out of 12 defined
Logical
★ 95 · ◉ 19 · All versions
=IF()
How to use the IF function in Excel to make logical comparisons between data values.
=IF(logical_test, value_if_true, [value_if_false])
Daily Tasks
Conditional Logic
Logical
★ 15 · ◉ 19 · Excel 2013
=XOR()
The XOR function returns a logical Exclusive Or of all arguments.
=XOR(logical1, [logical2],…)
Comparation
Conditional Logic
Lookup & Reference
★ 60 · ◉ 17 · All versions
=CHOOSE()
Uses index_num to return a value from the list of value arguments. Use CHOOSE to select one of up to 254 values based on the index number. For example, if value1 through value7 are the days of the week, CHOOSE returns one of the days when a number between 1 and 7 is used as index_num.
=CHOOSE(index_num, value1, [value2], ...)
Lookup & Retrieval
Conditional Logic
Logical
★ 70 · ◉ 15 · Excel 2019
=IFS()
The IFS function checks whether one or more conditions are met and returns a value that corresponds to the first TRUE condition. IFS will allow you to include up to 127 pairs of conditions (the test if something is True and the result if something is true). IFS can take the place of multiple nested IF statements.
=IFS([Something is True1, Value if True1,Something is True2,Value if True2,Something is True3,Value if True3)
Daily Tasks
Conditional Logic
Logical
★ 50 · ◉ 14 · All versions
=AND()
Use the AND function, one of the logical functions, to determine if all conditions in a test are TRUE.
=AND(logical1, [logical2], ...)
Daily Tasks
Conditional Logic
Logical
★ 55 · ◉ 13 · Excel 2019
=SWITCH()
The SWITCH function evaluates one value (called the expression) against a list of values, and returns the result corresponding to the first matching value. If there is no match, an optional default value may be returned. If there are no matching values, and no default argument is supplied, the SWITCH function returns the #N/A! error.
=SWITCH(expression, value1, result1, [default or value2, result2],…[default or value3, result3])
Conditional Logic
Logical
★ 30 · ◉ 12 · All versions
=NOT()
Use the NOT function, one of the logical functions, when you want to make sure one value is not equal to another. One common use for the NOT function is to expand the usefulness of other functions that perform logical tests. For example, the IF function performs a logical test and then returns one value if the test evaluates to TRUE and another value if the test evaluates to FALSE. By using the NOT function as the logical_test argument of the IF function, you can test many different conditions instead of just one.
=NOT(logical)
Conditional Logic
Conditional Formatting & Validation
Logical
★ 50 · ◉ 9 · All versions
=OR()
Use the OR function, one of the logical functions, to determine if any conditions in a test are TRUE.
=OR(logical1, [logical2], ...)
Daily Tasks
Conditional Logic
Logical
★ 10 · ◉ 9 · All versions
=TRUE()
Returns the logical value TRUE. You can use this function when you want to return the value TRUE based on a condition. For example: =IF(A1=1,TRUE()) You can also enter the value TRUE directly into cells and formulas without using this function. For example: =IF(A1=1,TRUE) If the condition is met, Excel returns TRUE in both examples. If the condition is not met, Excel returns FALSE in both examples.
=TRUE()
Conditional Logic