IF statements (Nested) ??

[Kevalson]

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, then check L.
If L = either TECH or Empty cell, then K = "Out"
If L = any of these (TMOAM,TMOOT,TMPPA), then K = "In"

If V31 equals 70 or below, then K = "In".

I feel like my formula gets close, but no joy.
Also, macro's are disabled, as well as anything VBA.

Thoughts?

 

[jtakw]

Hi,

If L can Only be one of these, and nothing else, (TECH, empty, TMOAM, TMOOT, TMPPA).

Either one of these should work:

Book1
	K	L	V
31	Out		71
32	Out
Sheet568

Cell Formulas
Range	Formula
K31	=IF(V31<71,"In",IF(OR(L31={"","Tech"}),"Out","In"))
K32	=IF(V31>70,IF(OR(L31={"","Tech"}),"Out","In"),"In")

 

[Kevalson]

That did it. Thanks for giving me more understanding...

 

[jtakw]

You're welcome.