IF formula

[Belle23p]

Hello again,


Can you help me the appropriate IF formula

Q1= October 2015-December 2015
Q2=January 2016-March 2016
Q3=April 2016- June 2016
Q4=July 2016- September 2016

Thanks!

 

[Deepak]

Is this..

="Q"&LOOKUP(MONTH(A1),{1,4,7,10},{2,3,4,1})

OR

=LOOKUP(MONTH(A1),{1,4,7,10},{"Q2","Q3","Q4","Q1"})

 

[Khalid NGO]

Hi,

Or this:
=CHOOSE(MONTH(A1),2,2,2,3,3,3,4,4,4,1,1,1)

Format the cell as:
"Q"#

Regards,

 

[bosco_yip]

Maybe,

="Q"&INT(MOD((MONTH(A1)-1)/3+1,4))+1

or

="Q"&MID(222333444111,MONTH(A1),1)

Regards
Bosco

 

[Belle23p]

Is this..

="Q"&LOOKUP(MONTH(A1),{1,4,7,10},{2,3,4,1})

OR

=LOOKUP(MONTH(A1),{1,4,7,10},{"Q2","Q3","Q4","Q1"})

Hi Deepak,

Thank you for the formulas.

I tried to input it on the file but i'm receiving an error. Please refer to the attached file.

I really appreciate your help. Thanks!

 

[Deepak]

You might did something wrong.

Check it..