Avoiding ifs within ifs

[TheNewGuy22]

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

<tbody>
</tbody>

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

 

[BiocideJ]

No problem. I'm glad you got it working.