If statement problem

NadoDude · Aug 10, 2010

I have the following formula this formula on a summary sheet:

=IF(AND(Assignments!$A:$A=$A7,Assignments!$Q:$Q="Retirement"),Assignments!$P:$P,"")

I would like the formula to display the value in $P:$P if $A:$A=$A7 and $Q:$Q="Retirement", "Separation", or "Termination".

kpark91 · Aug 10, 2010

=IF(AND(Assignments!$A:$A=A7,OR(Assignments!$Q:$Q="Retirement",Assignments!$Q:$Q="Separation",Assignments!$Q:$Q="Termination")),Assignments!$P:$P,"")

lenze · Aug 10, 2010

do you want the Sum of the the "P" values where this is True, or just the value from P7?

lenze

NadoDude · Aug 10, 2010

I want the cell in column F of the roster to show the value in column H of the assignments sheet if the names match and column L of the assignments sheet says Retirement, Separation or Termination. (i.e. Row 4 of the roster (CAPEN SAM, should be showing 5/3/2010)

Worksheet: Roster UsedRange: $A$1:$I$5 Range: $A$1:$I$5 <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;"> </td><td width="100px" align="center" valign="top" style="background-color:#eeeeee;">A</td><td width="100px" align="center" valign="top" style="background-color:#eeeeee;">B</td><td width="100px" align="center" valign="top" style="background-color:#eeeeee;">C</td><td width="100px" align="center" valign="top" style="background-color:#eeeeee;">D</td><td width="100px" align="center" valign="top" style="background-color:#eeeeee;">E</td><td width="100px" align="center" valign="top" style="background-color:#eeeeee;">F</td><td width="100px" align="center" valign="top" style="background-color:#eeeeee;">G</td><td width="100px" align="center" valign="top" style="background-color:#eeeeee;">H</td><td width="100px" align="center" valign="top" style="background-color:#eeeeee;">I</td></tr><tr><td width="40px" style="background-color:#eeeeee;">1</td><td width="100px" style="background-color:#ffffff;"><a name="cA1_705"></a>Name</td><td width="100px" style="background-color:#ffffff;"><a name="cB1_705"></a>Last 4 SSN</td><td width="100px" style="background-color:#ffffff;"><a name="cC1_705"></a>PERSID</td><td width="100px" style="background-color:#ffffff;"><a name="cD1_705"></a>Gender</td><td width="100px" style="background-color:#ffffff;"><a name="cE1_705"></a>Hire Date</td><td width="100px" style="background-color:#ffffff;"><a name="cF1_705"></a>SVC End Date</td><td width="100px" style="background-color:#ffffff;"><a name="cG1_705"></a>SVC End Reason</td><td width="100px" style="background-color:#ffffff;"><a name="cH1_705"></a>Years of Service</td><td width="100px" style="background-color:#ffffff;"><a name="cI1_705"></a>Current Zone</td><tr><td width="40px" style="background-color:#eeeeee;">2</td><td width="100px" style="background-color:#ffffff;"><a name="cA2_705"></a>ADAMS BILL</td><td width="100px" style="background-color:#ffffff;"><a name="cB2_705"></a>3956</td><td width="100px" style="background-color:#ffffff;"><a name="cC2_705"></a><a title="=SUBSTITUTE(LEFT($A2,4) & LEFT($B2,4)," ", "")" href="#fC2_705">ADAM3956</a></td><td width="100px" style="background-color:#ffffff;"><a name="cD2_705"></a>M</td><td width="100px" style="background-color:#ffffff;"><a name="cE2_705"></a>4/28/2003</td><td width="100px" style="background-color:#ffffff;"><a name="cF2_705"></a><a title="=IF(AND(Assignments!$A:$A=A2,OR(Assignments!$I:$I="Retirement",Assignments!$I:$I="Separation",Assignments!$I:$I="Termination")),Assignments!$H:$H,"")" href="#fF2_705">12/1/2009</a></td><td width="100px" style="background-color:#ffffff;"><a name="cG2_705"></a><a title="=IF(AND(Assignments!A:A=A2,Assignments!H:H=F2),Assignments!I:I,"")" href="#fG2_705">Separation</a></td><td width="100px" style="background-color:#ffffff;"><a name="cH2_705"></a><a title="=IF(ISBLANK($E2),"",IF(F2="",(TODAY()-$E2)/365,($F2-$E2)/365))" href="#fH2_705">6.6</a></td><td width="100px" style="background-color:#ffffff;"><a name="cI2_705"></a><a title="=IF(ISBLANK($E2),"",IF($H2<=6,"A",IF($H2<=10,"B",IF($H2<=14,"C",IF($H2<=20,"D",IF($H2>20,"E"))))))" href="#fI2_705">B</a></td><tr><td width="40px" style="background-color:#eeeeee;">3</td><td width="100px" style="background-color:#ffffff;"><a name="cA3_705"></a>BROWN JOHN</td><td width="100px" style="background-color:#ffffff;"><a name="cB3_705"></a>6078</td><td width="100px" style="background-color:#ffffff;"><a name="cC3_705"></a><a title="=SUBSTITUTE(LEFT($A3,4) & LEFT($B3,4)," ", "")" href="#fC3_705">BROW6078</a></td><td width="100px" style="background-color:#ffffff;"><a name="cD3_705"></a>M</td><td width="100px" style="background-color:#ffffff;"><a name="cE3_705"></a>4/28/2003</td><td width="100px" style="background-color:#ffffff;"><a name="cF3_705"></a><a title="=IF(AND(Assignments!$A:$A=A3,OR(Assignments!$I:$I="Retirement",Assignments!$I:$I="Separation",Assignments!$I:$I="Termination")),Assignments!$H:$H,"")" href="#fF3_705"></a></td><td width="100px" style="background-color:#ffffff;"><a name="cG3_705"></a><a title="=IF(AND(Assignments!A:A=A3,Assignments!H:H=F3),Assignments!I:I,"")" href="#fG3_705">0</a></td><td width="100px" style="background-color:#ffffff;"><a name="cH3_705"></a><a title="=IF(ISBLANK($E3),"",IF(F3="",(TODAY()-$E3)/365,($F3-$E3)/365))" href="#fH3_705">7.29041095890411</a></td><td width="100px" style="background-color:#ffffff;"><a name="cI3_705"></a><a title="=IF(ISBLANK($E3),"",IF($H3<=6,"A",IF($H3<=10,"B",IF($H3<=14,"C",IF($H3<=20,"D",IF($H3>20,"E"))))))" href="#fI3_705">B</a></td><tr><td width="40px" style="background-color:#eeeeee;">4</td><td width="100px" style="background-color:#ffffff;"><a name="cA4_705"></a>CAPEN SAM</td><td width="100px" style="background-color:#ffffff;"><a name="cB4_705"></a>7213</td><td width="100px" style="background-color:#ffffff;"><a name="cC4_705"></a><a title="=SUBSTITUTE(LEFT($A4,4) & LEFT($B4,4)," ", "")" href="#fC4_705">CAPE7213</a></td><td width="100px" style="background-color:#ffffff;"><a name="cD4_705"></a>M</td><td width="100px" style="background-color:#ffffff;"><a name="cE4_705"></a>11/10/1982</td><td width="100px" style="background-color:#ffffff;"><a name="cF4_705"></a><a title="=IF(AND(Assignments!$A:$A=A4,OR(Assignments!$I:$I="Retirement",Assignments!$I:$I="Separation",Assignments!$I:$I="Termination")),Assignments!$H:$H,"")" href="#fF4_705"></a></td><td width="100px" style="background-color:#ffffff;"><a name="cG4_705"></a><a title="=IF(AND(Assignments!A:A=A4,Assignments!H:H=F4),Assignments!I:I,"")" href="#fG4_705"></a></td><td width="100px" style="background-color:#ffffff;"><a name="cH4_705"></a><a title="=IF(ISBLANK($E4),"",IF(F4="",(TODAY()-$E4)/365,($F4-$E4)/365))" href="#fH4_705">27.7671232876712</a></td><td width="100px" style="background-color:#ffffff;"><a name="cI4_705"></a><a title="=IF(ISBLANK($E4),"",IF($H4<=6,"A",IF($H4<=10,"B",IF($H4<=14,"C",IF($H4<=20,"D",IF($H4>20,"E"))))))" href="#fI4_705">E</a></td><tr><td width="40px" style="background-color:#eeeeee;">5</td><td width="100px" style="background-color:#ffffff;"><a name="cA5_705"></a>SMITH ADAM</td><td width="100px" style="background-color:#ffffff;"><a name="cB5_705"></a>6272</td><td width="100px" style="background-color:#ffffff;"><a name="cC5_705"></a><a title="=SUBSTITUTE(LEFT($A5,4) & LEFT($B5,4)," ", "")" href="#fC5_705">SMIT6272</a></td><td width="100px" style="background-color:#ffffff;"><a name="cD5_705"></a>M</td><td width="100px" style="background-color:#ffffff;"><a name="cE5_705"></a>4/2/1993</td><td width="100px" style="background-color:#ffffff;"><a name="cF5_705"></a><a title="=IF(AND(Assignments!$A:$A=A5,OR(Assignments!$I:$I="Retirement",Assignments!$I:$I="Separation",Assignments!$I:$I="Termination")),Assignments!$H:$H,"")" href="#fF5_705"></a></td><td width="100px" style="background-color:#ffffff;"><a name="cG5_705"></a><a title="=IF(AND(Assignments!A:A=A5,Assignments!H:H=F5),Assignments!I:I,"")" href="#fG5_705"></a></td><td width="100px" style="background-color:#ffffff;"><a name="cH5_705"></a><a title="=IF(ISBLANK($E5),"",IF(F5="",(TODAY()-$E5)/365,($F5-$E5)/365))" href="#fH5_705">17.3671232876712</a></td><td width="100px" style="background-color:#ffffff;"><a name="cI5_705"></a><a title="=IF(ISBLANK($E5),"",IF($H5<=6,"A",IF($H5<=10,"B",IF($H5<=14,"C",IF($H5<=20,"D",IF($H5>20,"E"))))))" href="#fI5_705">D</a></td></table></div><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;">Address</td><td width="100px" align="center" valign="top" style="background-color:#eeeeee;">Value</td><td width="100px" align="center" valign="top" style="background-color:#eeeeee;">Formula</td></tr><tr><td width="40px" style="background-color:#eeeeee;"><a name="fC2_705"></a><a href="#cC2_705">C2</a></td><td width="100px" style="background-color:#ffffff;">ADAM3956</td><td width="100px" style="background-color:#ffffff;">=SUBSTITUTE(LEFT($A2,4) & LEFT($B2,4)," ", "")</td></tr><tr><td width="40px" style="background-color:#eeeeee;"><a name="fF2_705"></a><a href="#cF2_705">F2</a></td><td width="100px" style="background-color:#ffffff;">12/1/2009</td><td width="100px" style="background-color:#ffffff;">=IF(AND(Assignments!$A:$A=A2,OR(Assignments!$I:$I="Retirement",Assignments!$I:$I="Separation",Assignments!$I:$I="Termination")),Assignments!$H:$H,"")</td></tr><tr><td width="40px" style="background-color:#eeeeee;"><a name="fG2_705"></a><a href="#cG2_705">G2</a></td><td width="100px" style="background-color:#ffffff;">Separation</td><td width="100px" style="background-color:#ffffff;">=IF(AND(Assignments!A:A=A2,Assignments!H:H=F2),Assignments!I:I,"")</td></tr><tr><td width="40px" style="background-color:#eeeeee;"><a name="fH2_705"></a><a href="#cH2_705">H2</a></td><td width="100px" style="background-color:#ffffff;">6.6</td><td width="100px" style="background-color:#ffffff;">=IF(ISBLANK($E2),"",IF(F2="",(TODAY()-$E2)/365,($F2-$E2)/365))</td></tr><tr><td width="40px" style="background-color:#eeeeee;"><a name="fI2_705"></a><a href="#cI2_705">I2</a></td><td width="100px" style="background-color:#ffffff;">B</td><td width="100px" style="background-color:#ffffff;">=IF(ISBLANK($E2),"",IF($H2<=6,"A",IF($H2<=10,"B",IF($H2<=14,"C",IF($H2<=20,"D",IF($H2>20,"E"))))))</td></tr><tr><td width="40px" style="background-color:#eeeeee;"><a name="fC3_705"></a><a href="#cC3_705">C3</a></td><td width="100px" style="background-color:#ffffff;">BROW6078</td><td width="100px" style="background-color:#ffffff;">=SUBSTITUTE(LEFT($A3,4) & LEFT($B3,4)," ", "")</td></tr><tr><td width="40px" style="background-color:#eeeeee;"><a name="fF3_705"></a><a href="#cF3_705">F3</a></td><td width="100px" style="background-color:#ffffff;"></td><td width="100px" style="background-color:#ffffff;">=IF(AND(Assignments!$A:$A=A3,OR(Assignments!$I:$I="Retirement",Assignments!$I:$I="Separation",Assignments!$I:$I="Termination")),Assignments!$H:$H,"")</td></tr><tr><td width="40px" style="background-color:#eeeeee;"><a name="fG3_705"></a><a href="#cG3_705">G3</a></td><td width="100px" style="background-color:#ffffff;">0</td><td width="100px" style="background-color:#ffffff;">=IF(AND(Assignments!A:A=A3,Assignments!H:H=F3),Assignments!I:I,"")</td></tr><tr><td width="40px" style="background-color:#eeeeee;"><a name="fH3_705"></a><a href="#cH3_705">H3</a></td><td width="100px" style="background-color:#ffffff;">7.29041095890411</td><td width="100px" style="background-color:#ffffff;">=IF(ISBLANK($E3),"",IF(F3="",(TODAY()-$E3)/365,($F3-$E3)/365))</td></tr><tr><td width="40px" style="background-color:#eeeeee;"><a name="fI3_705"></a><a href="#cI3_705">I3</a></td><td width="100px" style="background-color:#ffffff;">B</td><td width="100px" style="background-color:#ffffff;">=IF(ISBLANK($E3),"",IF($H3<=6,"A",IF($H3<=10,"B",IF($H3<=14,"C",IF($H3<=20,"D",IF($H3>20,"E"))))))</td></tr><tr><td width="40px" style="background-color:#eeeeee;"><a name="fC4_705"></a><a href="#cC4_705">C4</a></td><td width="100px" style="background-color:#ffffff;">CAPE7213</td><td width="100px" style="background-color:#ffffff;">=SUBSTITUTE(LEFT($A4,4) & LEFT($B4,4)," ", "")</td></tr><tr><td width="40px" style="background-color:#eeeeee;"><a name="fF4_705"></a><a href="#cF4_705">F4</a></td><td width="100px" style="background-color:#ffffff;"></td><td width="100px" style="background-color:#ffffff;">=IF(AND(Assignments!$A:$A=A4,OR(Assignments!$I:$I="Retirement",Assignments!$I:$I="Separation",Assignments!$I:$I="Termination")),Assignments!$H:$H,"")</td></tr><tr><td width="40px" style="background-color:#eeeeee;"><a name="fG4_705"></a><a href="#cG4_705">G4</a></td><td width="100px" style="background-color:#ffffff;"></td><td width="100px" style="background-color:#ffffff;">=IF(AND(Assignments!A:A=A4,Assignments!H:H=F4),Assignments!I:I,"")</td></tr><tr><td width="40px" style="background-color:#eeeeee;"><a name="fH4_705"></a><a href="#cH4_705">H4</a></td><td width="100px" style="background-color:#ffffff;">27.7671232876712</td><td width="100px" style="background-color:#ffffff;">=IF(ISBLANK($E4),"",IF(F4="",(TODAY()-$E4)/365,($F4-$E4)/365))</td></tr><tr><td width="40px" style="background-color:#eeeeee;"><a name="fI4_705"></a><a href="#cI4_705">I4</a></td><td width="100px" style="background-color:#ffffff;">E</td><td width="100px" style="background-color:#ffffff;">=IF(ISBLANK($E4),"",IF($H4<=6,"A",IF($H4<=10,"B",IF($H4<=14,"C",IF($H4<=20,"D",IF($H4>20,"E"))))))</td></tr><tr><td width="40px" style="background-color:#eeeeee;"><a name="fC5_705"></a><a href="#cC5_705">C5</a></td><td width="100px" style="background-color:#ffffff;">SMIT6272</td><td width="100px" style="background-color:#ffffff;">=SUBSTITUTE(LEFT($A5,4) & LEFT($B5,4)," ", "")</td></tr><tr><td width="40px" style="background-color:#eeeeee;"><a name="fF5_705"></a><a href="#cF5_705">F5</a></td><td width="100px" style="background-color:#ffffff;"></td><td width="100px" style="background-color:#ffffff;">=IF(AND(Assignments!$A:$A=A5,OR(Assignments!$I:$I="Retirement",Assignments!$I:$I="Separation",Assignments!$I:$I="Termination")),Assignments!$H:$H,"")</td></tr><tr><td width="40px" style="background-color:#eeeeee;"><a name="fG5_705"></a><a href="#cG5_705">G5</a></td><td width="100px" style="background-color:#ffffff;"></td><td width="100px" style="background-color:#ffffff;">=IF(AND(Assignments!A:A=A5,Assignments!H:H=F5),Assignments!I:I,"")</td></tr><tr><td width="40px" style="background-color:#eeeeee;"><a name="fH5_705"></a><a href="#cH5_705">H5</a></td><td width="100px" style="background-color:#ffffff;">17.3671232876712</td><td width="100px" style="background-color:#ffffff;">=IF(ISBLANK($E5),"",IF(F5="",(TODAY()-$E5)/365,($F5-$E5)/365))</td></tr><tr><td width="40px" style="background-color:#eeeeee;"><a name="fI5_705"></a><a href="#cI5_705">I5</a></td><td width="100px" style="background-color:#ffffff;">D</td><td width="100px" style="background-color:#ffffff;">=IF(ISBLANK($E5),"",IF($H5<=6,"A",IF($H5<=10,"B",IF($H5<=14,"C",IF($H5<=20,"D",IF($H5>20,"E"))))))</td></tr></table></div>

Worksheet: Assignments UsedRange: $A$1:$J$6 Range: $A$1:$J$6 <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;"> </td><td width="100px" align="center" valign="top" style="background-color:#eeeeee;">A</td><td width="100px" align="center" valign="top" style="background-color:#eeeeee;">B</td><td width="100px" align="center" valign="top" style="background-color:#eeeeee;">C</td><td width="100px" align="center" valign="top" style="background-color:#eeeeee;">D</td><td width="100px" align="center" valign="top" style="background-color:#eeeeee;">E</td><td width="100px" align="center" valign="top" style="background-color:#eeeeee;">F</td><td width="100px" align="center" valign="top" style="background-color:#eeeeee;">G</td><td width="100px" align="center" valign="top" style="background-color:#eeeeee;">H</td><td width="100px" align="center" valign="top" style="background-color:#eeeeee;">I</td><td width="100px" align="center" valign="top" style="background-color:#eeeeee;">J</td></tr><tr><td width="40px" style="background-color:#eeeeee;">1</td><td width="100px" style="background-color:#ffffff;"><a name="cA1_705"></a>Name</td><td width="100px" style="background-color:#ffffff;"><a name="cB1_705"></a>PERSID</td><td width="100px" style="background-color:#ffffff;"><a name="cC1_705"></a>EDA</td><td width="100px" style="background-color:#ffffff;"><a name="cD1_705"></a>Report Date</td><td width="100px" style="background-color:#ffffff;"><a name="cE1_705"></a>PRD</td><td width="100px" style="background-color:#ffffff;"><a name="cF1_705"></a>EDD</td><td width="100px" style="background-color:#ffffff;"><a name="cG1_705"></a>TERM LV Date</td><td width="100px" style="background-color:#ffffff;"><a name="cH1_705"></a>Detach Date</td><td width="100px" style="background-color:#ffffff;"><a name="cI1_705"></a>Detach Reason</td><td width="100px" style="background-color:#ffffff;"><a name="cJ1_705"></a>Status</td><tr><td width="40px" style="background-color:#eeeeee;">2</td><td width="100px" style="background-color:#ffffff;"><a name="cA2_705"></a>ADAMS BILL</td><td width="100px" style="background-color:#ffffff;"><a name="cB2_705"></a>ADAM3956</td><td width="100px" style="background-color:#ffffff;"><a name="cC2_705"></a>10/1/2007</td><td width="100px" style="background-color:#ffffff;"><a name="cD2_705"></a>10/1/2007</td><td width="100px" style="background-color:#ffffff;"><a name="cE2_705"></a>12/1/2009</td><td width="100px" style="background-color:#ffffff;"><a name="cF2_705"></a></td><td width="100px" style="background-color:#ffffff;"><a name="cG2_705"></a></td><td width="100px" style="background-color:#ffffff;"><a name="cH2_705"></a>12/1/2009</td><td width="100px" style="background-color:#ffffff;"><a name="cI2_705"></a>Separation</td><td width="100px" style="background-color:#ffffff;"><a name="cJ2_705"></a>ACTIVE</td><tr><td width="40px" style="background-color:#eeeeee;">3</td><td width="100px" style="background-color:#ffffff;"><a name="cA3_705"></a>BROWN JOHN</td><td width="100px" style="background-color:#ffffff;"><a name="cB3_705"></a>BROW6078</td><td width="100px" style="background-color:#ffffff;"><a name="cC3_705"></a>9/29/2008</td><td width="100px" style="background-color:#ffffff;"><a name="cD3_705"></a>9/29/2008</td><td width="100px" style="background-color:#ffffff;"><a name="cE3_705"></a>8/1/2009</td><td width="100px" style="background-color:#ffffff;"><a name="cF3_705"></a></td><td width="100px" style="background-color:#ffffff;"><a name="cG3_705"></a></td><td width="100px" style="background-color:#ffffff;"><a name="cH3_705"></a></td><td width="100px" style="background-color:#ffffff;"><a name="cI3_705"></a></td><td width="100px" style="background-color:#ffffff;"><a name="cJ3_705"></a>ACTIVE</td><tr><td width="40px" style="background-color:#eeeeee;">4</td><td width="100px" style="background-color:#ffffff;"><a name="cA4_705"></a>CAPEN SAM</td><td width="100px" style="background-color:#ffffff;"><a name="cB4_705"></a>CAPE7213</td><td width="100px" style="background-color:#ffffff;"><a name="cC4_705"></a>3/6/2007</td><td width="100px" style="background-color:#ffffff;"><a name="cD4_705"></a>3/6/2007</td><td width="100px" style="background-color:#ffffff;"><a name="cE4_705"></a>4/1/2010</td><td width="100px" style="background-color:#ffffff;"><a name="cF4_705"></a>3/1/2010</td><td width="100px" style="background-color:#ffffff;"><a name="cG4_705"></a></td><td width="100px" style="background-color:#ffffff;"><a name="cH4_705"></a>3/1/2010</td><td width="100px" style="background-color:#ffffff;"><a name="cI4_705"></a>Transfer</td><td width="100px" style="background-color:#ffffff;"><a name="cJ4_705"></a>INACTIVE</td><tr><td width="40px" style="background-color:#eeeeee;">5</td><td width="100px" style="background-color:#ffffff;"><a name="cA5_705"></a>CAPEN SAM</td><td width="100px" style="background-color:#ffffff;"><a name="cB5_705"></a>CAPE7213</td><td width="100px" style="background-color:#ffffff;"><a name="cC5_705"></a>4/30/2010</td><td width="100px" style="background-color:#ffffff;"><a name="cD5_705"></a>4/6/2010</td><td width="100px" style="background-color:#ffffff;"><a name="cE5_705"></a>4/1/2013</td><td width="100px" style="background-color:#ffffff;"><a name="cF5_705"></a></td><td width="100px" style="background-color:#ffffff;"><a name="cG5_705"></a></td><td width="100px" style="background-color:#ffffff;"><a name="cH5_705"></a>5/3/2010</td><td width="100px" style="background-color:#ffffff;"><a name="cI5_705"></a>Terminate</td><td width="100px" style="background-color:#ffffff;"><a name="cJ5_705"></a>ACTIVE</td><tr><td width="40px" style="background-color:#eeeeee;">6</td><td width="100px" style="background-color:#ffffff;"><a name="cA6_705"></a>SMITH ADAM</td><td width="100px" style="background-color:#ffffff;"><a name="cB6_705"></a>SMIT6272</td><td width="100px" style="background-color:#ffffff;"><a name="cC6_705"></a>12/31/2008</td><td width="100px" style="background-color:#ffffff;"><a name="cD6_705"></a>12/1/2008</td><td width="100px" style="background-color:#ffffff;"><a name="cE6_705"></a>12/1/2010</td><td width="100px" style="background-color:#ffffff;"><a name="cF6_705"></a>9/1/2010</td><td width="100px" style="background-color:#ffffff;"><a name="cG6_705"></a>8/4/2010</td><td width="100px" style="background-color:#ffffff;"><a name="cH6_705"></a></td><td width="100px" style="background-color:#ffffff;"><a name="cI6_705"></a>Retirement</td><td width="100px" style="background-color:#ffffff;"><a name="cJ6_705"></a>ACTIVE</td></table></div>

If statement problem

NadoDude

Board Regular

Excel Facts

kpark91

Well-known Member

lenze

Legend

NadoDude

Board Regular

Similar threads

Forum statistics

Share this page

If statement problem

NadoDude

Board Regular

Excel Facts

kpark91

Well-known Member

lenze

Legend

NadoDude

Board Regular

Similar threads

Forum statistics

Share this page

We've detected that you are using an adblocker.

Which adblocker are you using?

Disable AdBlock

Disable AdBlock Plus

Disable uBlock Origin

Disable uBlock