if formula

[vmjan02]

I don't understand as why the out put is as In Center instead it has to be Per Min.
as the month is Jun, any suggestion

=IF(TEXT(MAX('ACD Dumps'!A:A),"MMM")={"Nov","Dec","Jan","Feb","Mar","Apr","May","Jun"},"Per Min","In Center")

 

[JackDanIce]

What is the actual format of the column A:A? It maybe the TEXT function around is causing an unknown, despite it appearing to look like "Jun", hence it's not matching the TRUE condition of your IF statement.

Can you post an example of your spreadsheet as well?

 

[vmjan02]

What is the actual format of the column A:A? It maybe the TEXT function around is causing an unknown, despite it appearing to look like "Jun", hence it's not matching the TRUE condition of your IF statement.

Can you post an example of your spreadsheet as well?

it is mmm-yyyy format

May-2021​

Jun-2021​

Jun-2021​

Jun-2021​

Jun-2021​

Jun-2021​

May-2021​

May-2021​

Jun-2021​

Jun-2021​

Jun-2021​

Jun-2021​

Jun-2021​

 

[Peter_SSs]

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

 

[Fluff]

Depending on your version of Excel, how about

=IF(OR(MAX(MONTH(A:A))={11,12,1,2,3,4,5,6}),"Per Min","In Center")

 

[JackDanIce]

Does this help? Formula in yellow

Other.xlsm
	I	J	K
1	Data	Test	Final
2	May-2021	In Centre	In Centre
3	Jun-2021	Per Min
4	Jul-2021	In Centre
5	Aug-2021	In Centre
6	Sep-2021	In Centre
7	Oct-2021	In Centre
8	May-2021
9	May-2021
10	Jun-2021
11	Jun-2021
12	Jun-2021
13	Jun-2021
14	Jun-2021
Main

Cell Formulas
Range	Formula
K2	K2	=IF(MAX(MONTH(I2:I14))=MEDIAN(MAX(MONTH(I2:I14)),7,8,9),"Per Min", "In Centre")
J2:J7	J2	=IF(MONTH(I2)=MEDIAN(MONTH(I2:I14),7,8,9),"Per Min", "In Centre")

Or for later Excel versions:

=LET(max_month,MAX(MONTH(I2:I14)),IF(max_month=MEDIAN(max_month,7,8,9),"Per Min", "In Centre"))

 

[vmjan02]

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

done.

 

[Peter_SSs]

done.

Cheers. Thanks.

 

[Toadstool]

Hi VMJam02,

Here's my contribution,

VMJam02.xlsx
	A	B	C
1	May-21		Result
2	Jun-21		Per Min
3	Jun-21
4	Jun-21
5	Jun-21
6	Jun-21
7	May-21
8	May-21
9	Jun-21
10	Jun-21
11	Jun-21
12	Jun-21
13	Jun-21
14
ACD Dumps

Cell Formulas
Range	Formula
C2	C2	=IF(OR(MONTH(MAX('ACD Dumps'!A:A))<7,MONTH(MAX('ACD Dumps'!A:A))>10),"Per Min","In Center")

 

[vmjan02]

=IF(OR(MAX(MONTH(A:A))={11,12,1,2,3,4,5,6}),"Per Min","In Center")

still giving me "In Center", were as it has to me Per Min

=IF(OR(MAX('ACD Dumps'!A:A)={11,12,1,2,3,4,5,6}),"Per Min","In Center")


This is how it should be so if the month is from Nov till Jun it will be Per Min and once the Month is not equal to Nov till Jun then In Center. I hope now we can fig the way out.

May-2021​	Per Min
May-2021​	Per Min
May-2021​	Per Min
Jun-2021​	Per Min
Jun-2021​	Per Min
Jun-2021​	Per Min
Jun-2021​	Per Min
Jun-2021​	Per Min
May-2021​	Per Min
May-2021​	Per Min
Jun-2021​	Per Min
Jun-2021​	Per Min
Jun-2021​	Per Min
Jun-2021​	Per Min
Jun-2021​	Per Min
Jul-2021​	In Center