8. Use the IF function to determine the quarter of a year
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
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.
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