Excel: Avoiding ifs within ifs


Hello Everybody again, I'm having difficulty figuring out how to set up an if statement without putting 12 ifs within each other. I'm trying to get a formula that recognizes what month it is and then displays either FYyy or yyyy based on the month it shows and the date. This is what I have. I want a way to get the bolded result based on the columns already there.

Nov FY09 11/5/2008 12/5/2008 2008
Dec FY09 12/6/2008 1/6/2009 2008
Jan FY09 1/7/2009 2/4/2009 2009
Feb FY09 2/5/2009 3/5/2009 2009
Mar FY09 3/6/2009 4/3/2009 2009
Apr FY09 4/4/2009 5/5/2009 FY09
May FY09 5/6/2009 6/3/2009 FY09
Jun FY09 6/4/2009 7/6/2009 FY09
Jul FY10 7/7/2009 8/5/2009 FY10
Aug FY10 8/6/2009 9/3/2009 FY10
Sep FY10 9/4/2009 10/5/2009 FY10
Oct FY10 10/6/2009 11/3/2009 2009
Is there a way to list off say: {Jan,Feb,Mar,Apr,May,Jun,Jul,Aug,Sep,Oct,Nov,Dec} and then have an equivalent array with the possible outcomes? Thank you very much, Robin


This question generated 21 answers. To proceed to the answers, click here.

This thread is current as of May 09, 2014.


For more resources for Microsoft Excel