If, then, else question.

[MAB]

This is my dilema... I need to display a status of 1 month previous and 2
months previous.

My problem arises in January and February. What I need in the statement for
current month - 1 is: If month(today()) = 1, then 12, else month(today())-1.
What I need for the statement current month -2 is: If(month(today()) = 1,
then 11, If month(today())= 2, then 12, else month(today())-2. I'm just not
certain how to write this in Excel.

Thank you.

[bpeltzer]

=if(month(today())<3,month(today())+10,month(today())-2) is one way.
If you want to use nested ifs:
=if(month(today())=1,11,if(month(today())=2,12,month(today())-2)))
In general:
=if(condition_1,cond_1_value,if(condition_2,cond_2_value,neither_value))

"MAB" wrote:

> This is my dilema... I need to display a status of 1 month previous and 2
> months previous.
>
> My problem arises in January and February. What I need in the statement for
> current month - 1 is: If month(today()) = 1, then 12, else month(today())-1.
> What I need for the statement current month -2 is: If(month(today()) = 1,
> then 11, If month(today())= 2, then 12, else month(today())-2. I'm just not
> certain how to write this in Excel.
>
> Thank you.
>

[Bob Phillips]

=CHOOSE(MONTH(TODAY()),12,1,2,3,4,5,6,7,8,9,10,11)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"MAB" <[email protected]> wrote in message
news:[email protected]...
> This is my dilema... I need to display a status of 1 month previous and 2
> months previous.
>
> My problem arises in January and February. What I need in the statement
for
> current month - 1 is: If month(today()) = 1, then 12, else
month(today())-1.
> What I need for the statement current month -2 is: If(month(today()) =
1,
> then 11, If month(today())= 2, then 12, else month(today())-2. I'm just
not
> certain how to write this in Excel.
>
> Thank you.
>

[MAB]

Perfect!

Thank you.

"bpeltzer" wrote:

> =if(month(today())<3,month(today())+10,month(today())-2) is one way.
> If you want to use nested ifs:
> =if(month(today())=1,11,if(month(today())=2,12,month(today())-2)))
> In general:
> =if(condition_1,cond_1_value,if(condition_2,cond_2_value,neither_value))
>
> "MAB" wrote:
>
> > This is my dilema... I need to display a status of 1 month previous and 2
> > months previous.
> >
> > My problem arises in January and February. What I need in the statement for
> > current month - 1 is: If month(today()) = 1, then 12, else month(today())-1.
> > What I need for the statement current month -2 is: If(month(today()) = 1,
> > then 11, If month(today())= 2, then 12, else month(today())-2. I'm just not
> > certain how to write this in Excel.
> >
> > Thank you.
> >

[mphell0]

Load Analysis Toolpak and use this

for 1 month prior:
=MONTH(EDATE(TODAY(),-1))

for 2 months prior:
=MONTH(EDATE(TODAY(),-2))

[Ardus Petus]

This will automatically adjust to December 2005 if Today is January 2006

=DATE(YEAR(TODAY()),MONTH(TODAY())-1,DAY(TODAY()))

HTH
--
AP

"MAB" <[email protected]> a écrit dans le message de
news:[email protected]...
> This is my dilema... I need to display a status of 1 month previous and 2
> months previous.
>
> My problem arises in January and February. What I need in the statement
for
> current month - 1 is: If month(today()) = 1, then 12, else
month(today())-1.
> What I need for the statement current month -2 is: If(month(today()) =
1,
> then 11, If month(today())= 2, then 12, else month(today())-2. I'm just
not
> certain how to write this in Excel.
>
> Thank you.
>