IF Formula

[ThedoreHolley]

I'm trying to do a If formula for ARMY Promotions.

NAME	RANK	BASD	TIS	DOR	TIG	ZONE	7-Oct-17
FOX	SPC	2-Feb-14	44	1-Jul-16	15	FALSE

<tbody>
</tbody><colgroup><col span="3"><col><col span="2"><col><col></colgroup>

This is what I'm starting with I need the zone Colum to give me Primary or secondary.

=IF((AND(D2>=17,D2<34, F2>=5,<6)), "SECONDARY")=IF((AND(D2>=35, F2>=7)), "PRIMARY")


Basically need secondary between 17-34 TIS and between 5-6 TIG then that's secondary
Primary 35 and above TIS and 7 above TIS.

Any help

 

[Tetra201]

Try

=IF(AND(D2>=17,F2>=5),IF(AND(D2>=35,F2>=7),"PRIMARY","SECONDARY"),"UNDEFINED")

 

[ThedoreHolley]

I Think it works. Thanks