AND Function

AND function in Excel
The ‘AND’ function in Excel is simple to use. Let’s say we wish to determine which of our employees are eligible for allowances. Now we wish to give only managers with a salary of less than $15000 allowances for a car, for example. This means the employee must be designated as manager and he should be getting a salary of less than $15000. Both these criteria must be fulfilled before she is eligible for a car allowance. Let’s see how we can implement the process in Excel quickly and easily using a video.

Further reading
AND function