Microsoft Office Tutorials and References

In Depth Information

**Syntax:**

leather jacket sold on Fridays this month. In this case, the logical test re-

quires you to determine whether both conditions are true. You can do this with

the AND function.

Syntax:

AND(logical1,logical2,...)

The arguments logical1,logical2,... are from one to 255 expressions that

evaluate to either TRUE or FALSE. The function returns TRUE only if all

arguments are TRUE.

In
Figure 12.2
, the function in cell F2 checks whether cell E2 is a jacket and

whether the date in cell D2 falls on a Friday:

=AND(E2="Jacket",WEEKDAY(D2,2)=5)

Figure 12.2.

Figure 12.2.
The

The AND

AND function is

function is TRUE

TRUE only when every condition is met.

only when every condition is met.

Using the

Using the
AND

AND
Function to Compare Two Lists

Function to Compare Two Lists

The AND function can handle up to 255 expressions. Each expression can con-

tain a range that might contain many instances of TRUE or FALSE.

A common issue is figuring out whether two worksheets are identical. In
Figure

passed among several co-workers, it ended back at your desk. Follow these

steps to compare the two worksheets:

11. Leave three blank columns
—
columns F, G, and H
—
to the right of your

original data.

22. Copy the data range of the returned worksheet. Paste this copy,

starting in column I of the original worksheet.