Boubekki Salah Fonction AND/OR 1 year preparatory
AND/OR
Functions Explained
AND/OR functions allow the user to check if multiple criteria are met. They are extremely
useful when combined with the IF function.!
The AND function is used for checking if all criteria are met
The OR function is used for checking if!at least one criterion is met.!
We can check dozens of criteria in each of these functions!!
Syntax
AND function:
=AND(logical1, [logical2], …)
OR function:
=OR(logical1, [logical2], …)
logical1 – First condition
logical2 – Second condition
logical3 – Third condition
and so on…!
As noted previously, these functions are extremely useful when combined with an IF function,
so let’s see how it’s combined together:
AND combined with IF function:
=IF(AND(logical1, logical2),value if true, value if false)
In this example, if logical1 and logical2 criteria are met, the IF function will return value if
true. If any of these criteria are not met, the IF function will return value if false.
OR combined with IF function:
=IF(OR(logical1, logical2),value if true, value if false)
