I have the following formula located in K31.
=IF(L31<>"TECH","In", IF(V31>=71,"Out","In"))
The manual variables are located in L and V.
Here's the variable possibilities for L:
TECH or Nothing. (Empty cell)
TMOAM
TMOOT
TMPPA
Here's the variable possibilities for V:
=>71
If V31 => 71...