Most valuable professional
  • Hot Topics

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 Dec Jan Feb Mar Apr May Jun Jul Aug Sep Oct 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 9, 2014.

For more resources for Microsoft Excel:

This article includes the following tags:

  • Excel
  • Microsoft Excel