Nested IF Returning "FALSE"

[bolified]

I am trying to create a spreadsheet so that users can change start month from drop down list, for example if they choose June all months prior to June will read as 0 and all the months after (including June) will have the recurring value. I have tried to accomplish this with a nested IF formula, it works fine except when June is selected I have 'FALSE' returned for all.

This is my original formula...
=IF($B39="December",0,IF($B39="November",0,IF($B39="October",0,IF($B39="September",0,IF($B39="August",0,IF($B39="July",0,IF($B39="June",$C39,IF($B39="May",$C39,IF($B39="April",$C39,IF($B39="March",$C39,IF($B39="February",$C39,IF($B39="January",$C39,IF($B39="","")))))))))))))

I cannot figure out why it is returning false, I even tried a cascading nested IF but that didn't work either. I cannot have any macros in this particular workbook so that isn't an option for me.

Any help is appreciated.

 

[wideboydixon]

There are probably easier ways. How is your data organised? For example:

Book1
	B	C	D	E	F	G	H	I	J	K	L	M	N	O
38			January	February	March	April	May	June	July	August	September	October	November	December
39	June	22	0	0	0	0	0	22	22	22	22	22	22	22
Sheet1

Cell Formulas
Range	Formula
D39	=IF(DATEVALUE("1 "&D$38&" 2018")>=DATEVALUE("1 "&$B39&" 2018"),$C39,0)

WBD

 

[oldbrewer]

jan	feb	mar	apr	may	jun
99	110	80	125	100	109
										apr	4
										feb	2
										jan	1
										jun	6
			say you want march onwards					mar	3
							H11 below		may	5
			look up mar in table on right and get	3
######
		mar	apr	may	jun
		80	125	100	109
	in A14 (below ######)
	=IF(COLUMN()<$H$11,"",A1)
	this was dragged down and across

<colgroup><col width="64" span="14" style="width:48pt"> </colgroup><tbody>
</tbody>

 

[jmacleary]

Hi there

I have tried this formula out in a sheet, and the results (for me) are: January to June inclusive shows the value in C39 (I placed 'abc' in there). July to December returns 0. Maybe its the content of C39 that's the problem?

Regards
John

 

[bolified]

Thanks so much! That has solved my problem, I was really over complicating things.