3 variables

[waterballoon]

I am trying to write an IF statement but I have 3 outputs instead of just 2.

IF C2<date(2011,7,1) then="" n2="6<br"><DATE(2011,7,1) then N2 = 6

IF C2<DATE(2011,10,1) then N2 = 3<date(2011,10,1) then="" n2="3<br">

IF C2>DATE(2011,10,1) then N2 = 0

In words...If the date is before july 1, 2011 I need 6, if the date is between july 1 and september 30 I need 3, and after october 1 i need 0.</date(2011,10,1)></date(2011,7,1)>

 

[waterballoon]

For some reason, it isn't posting my thread completely...

 

[VoG]

Try

=IF(C2 < DATE(2011,7,1),6,IF(C2 < DATE(2011,10,1),3,0))

 

[VoG]

For some reason, it isn't posting my thread completely...

You need to put spaces before and after < as I did.

The board software interprets < as an HTML tag.

 

[waterballoon]

Perfect! Thanks for the help! I really appreciate it!

 

[waterballoon]

You need to put spaces before and after < as I did.

The board software interprets < as an HTML tag.

Got it! Thanks again!

 

[VBACO]

Nested IFs... By the time I figured out why it was editing my posts you already had your answer.