FUNCTION AND
This function returns TRUE if all its arguments are TRUE; returns FALSE if one or more argument is FALSE.
How does it work?
AND(logical1,logical2, ...)
You can use up to 30 conditions to test that can be either TRUE or FALSE.
- The arguments must evaluate to logical values such as TRUE or FALSE, or the arguments must be arrays (array: Used to build single formulas that produce multiple results or that operate on a group of arguments that are arranged in rows and columns. An array range shares a common formula; an array constant is a group of constants used as an argument.) or references that contain logical values.
- If an array or reference argument contains text or empty cells, those values are ignored.
- If the specified range contains no logical values, AND returns the #VALUE! error value.
How does it work?
AND(logical1,logical2, ...)
You can use up to 30 conditions to test that can be either TRUE or FALSE.
- The arguments must evaluate to logical values such as TRUE or FALSE, or the arguments must be arrays (array: Used to build single formulas that produce multiple results or that operate on a group of arguments that are arranged in rows and columns. An array range shares a common formula; an array constant is a group of constants used as an argument.) or references that contain logical values.
- If an array or reference argument contains text or empty cells, those values are ignored.
- If the specified range contains no logical values, AND returns the #VALUE! error value.
Comments
Post a Comment
Your Valuable Comments are Appreciated