Pages

Thursday, December 9, 2010

Use the AND function to show sales for a specific period of time - Logical Functions - Microsoft Excel Tutorials

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

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




Watch the Video Tutorial - https://www.youtube.com/watch?v=3jsUMabKeGY

  Hope You Like This Tutorial - Give Comments

No comments:

Post a Comment

Submit Site to Google Free Articles Search Engine Submission - AddMe Directories Suggest Link Business Directory AutoBackLinks Directory Bingo Bahia Submission Software Reviews