Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

quarters to months

0 views
Skip to first unread message

John Swope

unread,
Apr 10, 2003, 10:48:47 AM4/10/03
to
Is there a nifty way to roll up months in to quarters? I
know that XL recognizes them as a series, but I can't find
any worksheet functions. Also, I believe the max on nested
IFs is 7 - not helful for the 12 mnth year.

Ron Rosenfeld

unread,
Apr 10, 2003, 12:05:26 PM4/10/03
to


The heading says "quarters to months"
Your message says "months in to quarters"

Which do you want??

To turn a month into a quarter, you could use:

=INT((MONTH(date)-1)/3)+1

if the first quarter is Jan, Feb or Mar

--ron

Myrna Larson

unread,
Apr 10, 2003, 4:27:50 PM4/10/03
to
And if he wants Quarters to Months, I don't think that's possible, do you?

Ron Rosenfeld

unread,
Apr 10, 2003, 7:29:57 PM4/10/03
to
I think it depends on the type of output he wants.

For example, one could array-enter the following formula in a three-cell horizontal array, and it would give
the months in each quarter -- one per cell:

=CHOOSE(Qtr,{"Jan","Feb","Mar"},{"Apr","May","Jun"},{"Jul","Aug","Sep"},{"Oct","Nov","Dec"})


One would have to ensure that Qtr is 1-4. Obviously, one could have different kinds of output using the same
principal, including real dates.

--ron

Myrna Larson

unread,
Apr 11, 2003, 2:12:24 PM4/11/03
to
But if he has only the quarter in which an event occurred, and he wants the SPECIFIC month,
that's been lost. That was my point.

Ron Rosenfeld

unread,
Apr 11, 2003, 7:35:44 PM4/11/03
to
On Fri, 11 Apr 2003 13:12:24 -0500, Myrna Larson <myrna...@charter.net> wrote:

>But if he has only the quarter in which an event occurred, and he wants the SPECIFIC month,
>that's been lost. That was my point.

OIC. I agree.


--ron

0 new messages