Pages

Monday, December 27, 2010

Use the IF function to determine the quarter of a year - Logical Functions - Microsoft Excel Tutorials

8.  Use the IF function to determine the quarter of a year

After entering an initial value, Excel can automatically fill worksheet cells with the names of weekdays or months. Open a new worksheet and type the word “January” in cell A2. Then drag the lower-right point of this cell down to A13 to let Excel create a list containing the months of the year. In this example, we want to indicate which months fall into which quarter.

To determine the quarter of a year in which a particular month falls:


1. Select cells B2:B13 and type the following formula: =IF(OR(A2="January",A2="February",A2="March"),"1st quarter",IF(OR(A2="April",A2="May",A2="June"),"2nd quarter",IF(OR(A2="July",A2="August",A2="September"),"3rd quarter","4th quarter"))).
2. Press <-Ctrl+Enter->.





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

Hope You Like TTutorials - 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