Microsoft Excel Functions & Formulas

Use the AND function to show sales for a

specific period of time

This example checks all rows for a specific time period using the

AND function. The function returns TRUE if the arguments are

TRUE and FALSE if one or more arguments are FALSE.

Note: Up to 30 conditions can be used in one formula.

4

To show sales in a period of time:

1. Select cell B1 and enter the start date.

2. Select cell B2 and enter the end date.

3. The range A5:A16 contains dates from 09/13/04 to

09/21/04.

4. The range B5:B16 contains sales amounts.

5. Select cells C5:C16 and type the following formula:

=AND(A5>=$B$1,A5<=$B$2).

6. Press <Ctrl+Enter>.

Logical Functions 41

2

Figure 2-2