Help with simple formula

[NadoDude]

For the formula in cell T2, I want to add something to it that says if P2 is blank, then use T1+1

<font size="2">Worksheet: Assignments UsedRange: $A$1:$W$2641 Range: $L$1:$T$2</font><br /><br /><div style="border: 1px solid #666666; overflow: auto; width:580px; height: 220px;"><table border="1" cellspacing="2" cellpadding="3"><tr><td width="40px" align="center" valign="top" style="background-color:#eeeeee;"><font size="2"> </font></td><td width="100px" align="center" valign="top" style="background-color:#eeeeee;"><font size="2">L</font></td><td width="100px" align="center" valign="top" style="background-color:#eeeeee;"><font size="2">M</font></td><td width="100px" align="center" valign="top" style="background-color:#eeeeee;"><font size="2">N</font></td><td width="100px" align="center" valign="top" style="background-color:#eeeeee;"><font size="2">O</font></td><td width="100px" align="center" valign="top" style="background-color:#eeeeee;"><font size="2">P</font></td><td width="100px" align="center" valign="top" style="background-color:#eeeeee;"><font size="2">Q</font></td><td width="100px" align="center" valign="top" style="background-color:#eeeeee;"><font size="2">R</font></td><td width="100px" align="center" valign="top" style="background-color:#eeeeee;"><font size="2">S</font></td><td width="100px" align="center" valign="top" style="background-color:#eeeeee;"><font size="2">T</font></td></tr><tr><td width="40px" style="background-color:#eeeeee;"><font size="2">1</font></td><td width="100px" style="background-color:#ffffff;"><a name="cL1_705"></a><font size="2">Report Date</font></td><td width="100px" style="background-color:#ffffff;"><a name="cM1_705"></a><font size="2">PRD</font></td><td width="100px" style="background-color:#ffffff;"><a name="cN1_705"></a><font size="2">EDD</font></td><td width="100px" style="background-color:#ffffff;"><a name="cO1_705"></a><font size="2">TERM LV Date</font></td><td width="100px" style="background-color:#ffffff;"><a name="cP1_705"></a><font size="2">Detach Date</font></td><td width="100px" style="background-color:#ffffff;"><a name="cQ1_705"></a><font size="2">Detach Reason</font></td><td width="100px" style="background-color:#ffffff;"><a name="cR1_705"></a><font size="2">Transfer to</font></td><td width="100px" style="background-color:#ffffff;"><a name="cS1_705"></a><font size="2">Notes</font></td><td width="100px" style="background-color:#ffffff;"><a name="cT1_705"></a><font size="2">7/26/2010</font></td><tr><td width="40px" style="background-color:#eeeeee;"><font size="2">2</font></td><td width="100px" style="background-color:#ffffff;"><a name="cL2_705"></a><font size="2">11/26/2008</font></td><td width="100px" style="background-color:#ffffff;"><a name="cM2_705"></a><font size="2">6/1/2012</font></td><td width="100px" style="background-color:#ffffff;"><a name="cN2_705"></a><font size="2"></font></td><td width="100px" style="background-color:#ffffff;"><a name="cO2_705"></a><font size="2"></font></td><td width="100px" style="background-color:#ffffff;"><a name="cP2_705"></a><font size="2"></font></td><td width="100px" style="background-color:#ffffff;"><a name="cQ2_705"></a><font size="2"></font></td><td width="100px" style="background-color:#ffffff;"><a name="cR2_705"></a><font size="2"></font></td><td width="100px" style="background-color:#ffffff;"><a name="cS2_705"></a><font size="2"></font></td><td width="100px" style="background-color:#ffffff;"><a name="cT2_705"></a><font size="2"><a title="=IF(AND($L2<=T$1,$P2>T$1),1,"")" href="#fT2_705"></a></font></td></table></div><p /><div style="border: 1px solid #666666; overflow: auto; width:580px; height: 220px;"><table border="1" cellspacing="2" cellpadding="3"><tr><td width="40px" align="center" valign="top" style="background-color:#eeeeee;"><font size="2">Address</font></td><td width="100px" align="center" valign="top" style="background-color:#eeeeee;"><font size="2">Value</font></td><td width="100px" align="center" valign="top" style="background-color:#eeeeee;"><font size="2">Formula</font></td></tr><tr><td width="40px" style="background-color:#eeeeee;"><a name="fT2_705"></a><font size="2"><a href="#cT2_705">T2</a></font></td><td width="100px" style="background-color:#ffffff;"><font size="2"></font></td><td width="100px" style="background-color:#ffffff;"><font size="2">=IF(AND($L2<=T$1,$P2>T$1),1,"")</font></td></tr></table></div>

 

[NadoDude]

Mike - again thanks for your help. I have another post entitled "Help with array formula", which I would love for you to take a crack at.

 

[mgirvin]

Cool:

=IF($P2="",IF(AND($L2<=T$1,T$1+1>T$1),1,""),IF(AND($L2<=T$1,$P2>T$1),1,""))

!!