If, then, else question.

M

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.
 
B

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))
 
B

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)
 
M

MAB

Perfect!

Thank you.

bpeltzer said:
=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))
Click to expand...
 
M

mphell0

Load Analysis Toolpak and use this

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

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

Ardus Petus

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

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

HTH
 
Top