How to use the AND Function in Excel
Description
The AND Function is categorized as Logical Function in Excel. This function returns TRUE if all the arguments of the AND function TRUE and returns FALSE if any of the arguments are FALSE.
The OR function can takes up to 254 arguments. It can also be used as a part of a formula.
Syntax
The syntax of AND function is =AND(logical1,[logical2] ...)
Argument or Parameter
Logical1 (Required)- A condition, value or reference that evaluates TRUE or FALSE.
Logical1 (Optional) - A condition, value or reference that evaluates TRUE or FALSE.
- If you use 0 then it evaluates as FALSE
- If any number other than 0 then it evaluates as TRUE
Returns
This function returns TRUE if all the arguments of the AND function TRUE and returns FALSE if any of the arguments are FALSE.
Example
Example-1
Example-2
Example-3
Example-4
Example-6
********************************* ~:Support Our Work Financially:~ *********************************
Project File Type: Free
If you think this tutorial helps you to solve your problem and add value to your work, Buy me a Coffee..
************************************************************************************************
|
|
||||
| AND |
FALSE |
IF |
IFERROR |
IFNA |
|
NOT |
OR |
TRUE |
XOR |
|
0 Comments