The logical values are your conditions which are separated with a comma or semicolon depending Excel version you are using. When using Excel AND, you can enter anywhere from two to255 conditions in the program. However, you should avoid using an excessive number of conditions. The more conditions a function contains, the more complex and nested it becomes. This makes it more difficult to create, check, and manage a function.
When defining and entering the logical values (i.e. the conditions), use the equals sign (=), greater-than sign (>) and less-than sign (<). In our example, logical value 1 is the condition stating that an employee must have obtained at least three new customers. The value in column B must therefore be greater than or equal to three. You define this condition by entering “B2>=3”. Logical value 2 is the condition stating that the employee must have also obtained two contract extensions. This is defined by entering “C2>=2”. In our example, the entire Excel function is as follows: