Convert Month Number (1,2,3, etc) to Quarter Number (1,2,3,4)

[barnett2000]

I have data that shows the month as a number (1-12). I need to convert this to a quarter (1-4). For example, months 1, 2, and 3 are Q1; month 4, 5, and 6 are Q2, and so on.

I could add a table and do a lookup, but I don't want to do that. I could use an IF statement, which I'll do if I don't get a better answer.

I seem to have a vague memory of some function that would put information based on a number. Like if it's 1, give this result, if it's 2, give a different result, etc.

Any thoughts/ideas?

(Note, I can't convert the date, because the date does not necessarily correspond to the fiscal month. For example, January 30-31 is part of Month 2, not Month 1.)

Thanks,
David

[Tony Valko]

Try this...

A1 = a number from 1 to 12

=CEILING(A1/3,1)

[Phuocam]

Month Number in A1, try this:

="Q"&CEILING(A1/3,1)