#### Carrie2525

##### New Member

- Joined
- Jun 10, 2015

- Messages
- 18

Here are all of the equations I need to piece together:

=IF(AND(O7-(O19-29)<91,O17="I"),O19+90)

=IF(AND(O7-(O19-29)>90,O7-(O19-29)<180,O17="I"),O19+179)

=IF(AND(O7-(O19-29)>179,O17="I"),"Indefinite")

=IF(AND(O7-(O19-44)<91,O17="E"),O19+90)

=IF(AND(O7-(O19-44)>90,O7-(O19-44)<180,O17="E"),O19+179)

=IF(AND(O7-(O19-44)>179,O17="E"),"Indefinite")

=IF(O15="N","N/A")

Here is the long formula that works, minus that last (only) IF statement:

=IF(AND(O7-(O19-44)>179,O17="E"),"Indefinite",IF(AND(O7-(O19-44)>90,O7-(O19-44)<180,O17="E"),O19+179,IF(AND(O7-(O19-44)<91,O17="E"),O19+90,IF(AND(O7-(O19-29)>179,O17="I"),"Indefinite",IF(AND(O7-(O19-29)>90,O7-(O19-29)<180,O17="I"),O19+179,IF(AND(O7-(O19-29)<91,O17="I"),O19+90))))))

To clarify, these 7 equations have covered every scenario--there are no other options. Also, each equation is exclusive--only one can be TRUE at a time.

I sincerely appreciate any help you can offer.

Thanks,

Carrie