ThedoreHolley
Board Regular
- Joined
- Sep 26, 2016
- Messages
- 51
- Office Version
- 365
- Platform
- Windows
So I'm trying to do this formula for ARMY promotion times. I need a couple of thinks to happen for this. So I need some date for Secondary, Primary, and MIL.
Secondary zone 17 months TIS, 5 months TIG
Primary zone 35 months TIS, 11 months TIG
Mandatory list integration: 47 months TIS , 23 months TIG
So here is my table
<colgroup><col width="154" style="width: 116pt; mso-width-source: userset; mso-width-alt: 5632;">
<col width="64" style="width: 48pt;">
<col width="69" style="width: 52pt; mso-width-source: userset; mso-width-alt: 2523;">
<col width="50" style="width: 38pt; mso-width-source: userset; mso-width-alt: 1828;">
<col width="68" style="width: 51pt; mso-width-source: userset; mso-width-alt: 2486;">
<col width="64" style="width: 48pt;">
<col width="82" style="width: 62pt; mso-width-source: userset; mso-width-alt: 2998;">
<tbody>
</tbody>Zone formula I have is =IF(AND(D2>=17,F2>=5),IF(AND(D2>=35,F2>=7),"PRIMARY","SECONDARY"),"UNDEFINED")
trying to have it work for all 3 =IF(AND(D2>=17,F2>=5),IF(AND(D2>=35,F2>=7),),IF(AND(D2>=47,F2>=23)"PRIMARY","SECONDARY", "MIL"),"UNDEFINED")
Secondary zone 17 months TIS, 5 months TIG
Primary zone 35 months TIS, 11 months TIG
Mandatory list integration: 47 months TIS , 23 months TIG
So here is my table
NAME | RANK | BASD | TIS | DOR | TIG | ZONE |
FOX | SPC | 2-Feb-14 | 46 | 1-Jul-16 | 17 | PRIMARY |
ANDERSON | SPC | 6-Oct-14 | 38 | 1-Jul-16 | 17 | PRIMARY |
trying to have it work for all 3 =IF(AND(D2>=17,F2>=5),IF(AND(D2>=35,F2>=7),),IF(AND(D2>=47,F2>=23)"PRIMARY","SECONDARY", "MIL"),"UNDEFINED")