| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
4 SETS OF CRITERIA USED TO DISPLAY ANSWER
Hi
I have a list of dates in column C e.g. 01/10/2008 Column D equals the dates in column C and are formatted using the custom 'mmm' e.g. Oct What I need is a formaula in column E that shows If D1=Apr, May or Jun then the formula result displays "Q1" OR If D1=Jul, Aug or Sep then the formula result displays "Q2" OR If D1=Oct, Nov or Dec then the formula result displays "Q3" OR If D1=Jan, Feb or Mar then the formula result displays "Q4" The formaula will be copied down the column Thank you in advance. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
4 SETS OF CRITERIA USED TO DISPLAY ANSWER
hi Mally,
use this formula: =IF(MONTH(A1)<4,"Q4",IF(MONTH(A1)<7,"Q1",IF(MONTH( A1)<10,"Q2","Q3"))) -- Kind Regards, Satti Charvak Only an Excel Enthusiast "Mally" wrote: Hi I have a list of dates in column C e.g. 01/10/2008 Column D equals the dates in column C and are formatted using the custom 'mmm' e.g. Oct What I need is a formaula in column E that shows If D1=Apr, May or Jun then the formula result displays "Q1" OR If D1=Jul, Aug or Sep then the formula result displays "Q2" OR If D1=Oct, Nov or Dec then the formula result displays "Q3" OR If D1=Jan, Feb or Mar then the formula result displays "Q4" The formaula will be copied down the column Thank you in advance. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
4 SETS OF CRITERIA USED TO DISPLAY ANSWER
to be more correct for your case, it should be:
=IF(MONTH(C1)<4,"Q4",IF(MONTH(C1)<7,"Q1",IF(MONTH( C1)<10,"Q2","Q3"))) It doesnot matter with the month formula, whether you pick the date from column "C" or "D". -- Kind Regards, Satti Charvak Only an Excel Enthusiast "Satti Charvak" wrote: hi Mally, use this formula: =IF(MONTH(A1)<4,"Q4",IF(MONTH(A1)<7,"Q1",IF(MONTH( A1)<10,"Q2","Q3"))) -- Kind Regards, Satti Charvak Only an Excel Enthusiast "Mally" wrote: Hi I have a list of dates in column C e.g. 01/10/2008 Column D equals the dates in column C and are formatted using the custom 'mmm' e.g. Oct What I need is a formaula in column E that shows If D1=Apr, May or Jun then the formula result displays "Q1" OR If D1=Jul, Aug or Sep then the formula result displays "Q2" OR If D1=Oct, Nov or Dec then the formula result displays "Q3" OR If D1=Jan, Feb or Mar then the formula result displays "Q4" The formaula will be copied down the column Thank you in advance. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
4 SETS OF CRITERIA USED TO DISPLAY ANSWER
Hi Mally,
Try this in E1 and dragged down =LOOKUP(MONTH(D1),{0,4,7,10,13},{"Q4","Q1","Q2","Q 3"}) HTH Martin "Mally" wrote in message ... Hi I have a list of dates in column C e.g. 01/10/2008 Column D equals the dates in column C and are formatted using the custom 'mmm' e.g. Oct What I need is a formaula in column E that shows If D1=Apr, May or Jun then the formula result displays "Q1" OR If D1=Jul, Aug or Sep then the formula result displays "Q2" OR If D1=Oct, Nov or Dec then the formula result displays "Q3" OR If D1=Jan, Feb or Mar then the formula result displays "Q4" The formaula will be copied down the column Thank you in advance. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
4 SETS OF CRITERIA USED TO DISPLAY ANSWER
Thank you Satti for your kind help. It works perfectly.
Mally "Mally" wrote: Hi I have a list of dates in column C e.g. 01/10/2008 Column D equals the dates in column C and are formatted using the custom 'mmm' e.g. Oct What I need is a formaula in column E that shows If D1=Apr, May or Jun then the formula result displays "Q1" OR If D1=Jul, Aug or Sep then the formula result displays "Q2" OR If D1=Oct, Nov or Dec then the formula result displays "Q3" OR If D1=Jan, Feb or Mar then the formula result displays "Q4" The formaula will be copied down the column Thank you in advance. |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
4 SETS OF CRITERIA USED TO DISPLAY ANSWER
Thank you too Martin. The Vlookup worked too.
Mally "MartinW" wrote: Hi Mally, Try this in E1 and dragged down =LOOKUP(MONTH(D1),{0,4,7,10,13},{"Q4","Q1","Q2","Q 3"}) HTH Martin "Mally" wrote in message ... Hi I have a list of dates in column C e.g. 01/10/2008 Column D equals the dates in column C and are formatted using the custom 'mmm' e.g. Oct What I need is a formaula in column E that shows If D1=Apr, May or Jun then the formula result displays "Q1" OR If D1=Jul, Aug or Sep then the formula result displays "Q2" OR If D1=Oct, Nov or Dec then the formula result displays "Q3" OR If D1=Jan, Feb or Mar then the formula result displays "Q4" The formaula will be copied down the column Thank you in advance. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I get the command sets to automatically display? | Excel Discussion (Misc queries) | |||
| Vlookup for 2 sets of Criteria (or do I need to use something else | Excel Discussion (Misc queries) | |||
| vlookup with 2 sets of criteria | Excel Discussion (Misc queries) | |||
| SUMIF with two sets of criteria | Excel Discussion (Misc queries) | |||
| Need to display 4 sets of data on one x-axis with 4 repeating y a. | Charts and Charting in Excel | |||
Linear Mode
