Need Help Updating Table of Fiscal Quarters Using IF Statement

[wjack]

I'm attempting to create a table that will automatically update the previous fiscal quarters based on a single input value. My goal is that I can put the current fiscal quarter and year into one input cell (A2) and that the table will count down from there. Thanks for the help!

Here is how I'd like the table to look:

Here is how the table currently looks:

Here are the formulas going into the table. As you can see the first cell references the QTR FY input and the others are supposed to count down from there:

 

[AhoyNC]

Welcome to the forum.
The LEFT(A5,1) part of your formula is returning a text string and not a value. By changing to LEFT(A5,1)+0 will return a value.

=IF(LEFT(A5,1)+0>1,LEFT(A5,1)-1,4)&"Q"&IF(LEFT(A5,1)+0>1,RIGHT(A5,2),RIGHT(A5,2)-1) Excel Workbook A B 1 Current Quarter 2Q14 2 3 4 Currrent & Past Quarters 5 2Q14 6 1Q14 7 4Q13 8 3Q13 9 2Q13 10 1Q13 11 4Q12 12 3Q12 13 2Q12 14 1Q12 15 4Q11 16 3Q11 17 Sheet

<colgroup><col width="637"></colgroup>