AND Specify logical OR and logical AND for the judgment condition.(Microsoft Excel)


Japanese version.

This function is used to specify logical OR and logical AND for IF function, IFS function, conditional format, etc.

How it works

AND(Logical1 to 255)
OR(Logical1 to 255)
Logical1 to 255value1 is required.Specify the match condition as a number or a string.
Partial specification with wildcards is not possible.

Example Results

Combine with IF Function and IFS function

Single condition

In AND function, "Qty is 40 or more and Category is 1",

OR function to set the condition "Qty is less than 25 or greater than 61".

The formulas are as follows

AND(Qty cell>=40, Category cell="1")
OR(Qty cell<=25, Qty cell>=61)

This time, we use it for the IF function condition, and if the condition is matched, the text "Yes" is displayed.

Compound conditions

By nesting AND and OR functions, it is possible to set complex conditions by combining each condition.

(Qty is 40 or more and Category is 1) or (Name is F).

=IF(OR(AND(Qty cell>=40,Category cell=1),Name cell="F"), "Match","")

However, as the number of conditions increases, the formulas become difficult to read.

In this case, we recommend using only one AND or OR function per cell and dividing the formulas.

Conditional Formatting.

Select the range of cells you wish to set and choose "New Rule" under "Conditional Formatting".

Select "Use a formula to determine which cells to format" and set logical formulas that incorporate functions.

The final result of the formula should be True or False.


To "Spill" the AND and OR functions, use the BYROW or BYCOL functions.




Logical(Microsoft Excel Functions)