IF or Lookup
 

I am trying to tell the cell to display the proper Quarter for the Month typed.
Jan-Mar = Q1
Apr-Jun = Q2
Jul-Sep = Q3
Oct-Dec = Q4
The probelm is IF functions only allow 7 itmes to be added & I would need at
least 8 to properly work. and I tried Lookup & haven't been able to properly
work either.
Any suggestions?

IF or Lookup
 

Ozzy --

Try this:

A B
1 Jan 2006 ="Q"&ROUNDUP(Month(A1)/3,0)

Seems to work for me.

HTH
If you want to type

"Ozzyworld" wrote:

I am trying to tell the cell to display the proper Quarter for the Month typed.
Jan-Mar = Q1
Apr-Jun = Q2
Jul-Sep = Q3
Oct-Dec = Q4
The probelm is IF functions only allow 7 itmes to be added & I would need at
least 8 to properly work. and I tried Lookup & haven't been able to properly
work either.
Any suggestions?

IF or Lookup
 

Try something like this:

With a text month name in A1

B1: ="Q"&CEILING(MONTH(--(A1&"-2006"))/3,1)

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"Ozzyworld" wrote:

I am trying to tell the cell to display the proper Quarter for the Month typed.
Jan-Mar = Q1
Apr-Jun = Q2
Jul-Sep = Q3
Oct-Dec = Q4
The probelm is IF functions only allow 7 itmes to be added & I would need at
least 8 to properly work. and I tried Lookup & haven't been able to properly
work either.
Any suggestions?