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.

<colgroup><col width="637"></colgroup>
[TD="class: xl63, width: 637"]=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

[/TD]