If Statements

[Sara R.]

Is there any way I can join all of these IF statements together for one formula? I tried here, but this won't work.

=IF(AND($R2>=4/29/7,$R2<7/29/7),1,0),(IF(AND($R2>=7/29/7,$R2<10/28/7),2,0)),(IF(AND($R2>=10/28/7,$R2<1/27/8),3,0)),(IF(AND($R2>=1/27/8,$R2<4/27/8),4,0)))

Thanks in advance!!!

Sara

 

[RalphA]

Edited a few minutes later:
If you are trying to use dates, I have not been able to use the actual dates in my formulas. But, if one puts the dates in cells, and refers to them, then, all is well. As in: Say you put the date 04/12/07 in cell B3, then one can write, =IF(R2>=B3,1,0), and it will work!

To "join" these IF() functions, you cannot use a comma (,). You can concatenate using the ampersand (&) symbol, and you can add numbers using the (+) symbol. Below, I have concatenated your IF() functions:
=IF(AND($R2>=4/29/7,$R2<7/29/7),1,0)&(IF(AND($R2>=7/29/7,$R2<10/28/7),2,0))&(IF(AND($R2>=10/28/7,$R2<1/27/8),3,0))&(IF(AND($R2>=1/27/8,$R2<4/27/8),4,0)))

By the way, just what are the numbers, such as 4/29/7? They certainly are not dates!

 

[facethegod]

If what you are referring to are dates then try this

=IF(B10<DATE(2007,4,29),0,LOOKUP(B10,DATE(2007,1,28)+91*ROW(1:5),{1,2,3,4,5}))

confirm w/ ctrl + shift + Enter not just enter