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")

 

[vmjan02]

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")

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

 

[Fluff]

Are you trying to do this row by row?

 

[JackDanIce]

If row by row, have you tried this from the example I posted?

=IF(MONTH($A2)=MEDIAN(MONTH($A2),7,8,9),"In Centre", "Per Min")

*I had "In Centre" and "Per Min" wrong way around

 

[vmjan02]

Are you trying to do this row by row?

no, by using MAX function in column A

 

[vmjan02]

sorry, its row by row. I am using Max function for column A:A and if Max is from Nov till Jun then Per Min else In Center

If row by row, have you tried this from the example I posted?

=IF(MONTH($A2)=MEDIAN(MONTH($A2),7,8,9),"In Centre", "Per Min")

*I had "In Centre" and "Per Min" wrong way around

 

[vmjan02]

I am using Max function for column A:A and if Max is from Nov till Jun then Per Min else In Center
same in my first post

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

 

[Toadstool]

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

Yes, that's what the formula does.

 

[Fluff]

In that case you don't want to use Max, try

+Fluff 1.xlsm
	A	B
1
2	May-21	Per Min
3	May-21	Per Min
4	May-21	Per Min
5	Jun-21	Per Min
6	Jun-21	Per Min
7	Jun-21	Per Min
8	Jun-21	Per Min
9	Jun-21	Per Min
10	May-21	Per Min
11	May-21	Per Min
12	Jun-21	Per Min
13	Jun-21	Per Min
14	Jun-21	Per Min
15	Jun-21	Per Min
16	Jun-21	Per Min
17	Jul-21	In Center
Lists

Cell Formulas
Range	Formula
B2:B17	B2	=IF(OR(MONTH(A2)={11,12,1,2,3,4,5,6}),"Per Min","In Center")

 

[vmjan02]

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

cool, it worked

 

[vmjan02]

thanks you every one of you, got the solution from

@Toadstool​

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

Thank you once again.