| 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. |