Value part of formula exlusion/ Not affects neg's: value

[Guest]

060509 Value part of formula exlusion/ Not affects neg's: value

don't know if can explain, else would be able to figure out myself?

making logical? filters if different column has (x1 23 or y 123 positions)
filter INTO this equation, am using: (absolute/fixed cell: "filter" enter
any of x y 1 2 3, x1 x2..)
PROBLEM: value(right( fixed if right = a number,
now if S9 empty, get Value error: S9="" didn't fix.
(1 step away, other filters work in conjunction, as listed at bottom).
thanks..

=IF(OR...AND((S9="",$AH$5<>"",$AH$5<>S9,$AH$5<>LEFT(S9,1),$AH$5<>VALUE(RIGHT(S9,1))),"", ...

exact equation is:
=IF(OR(AJ9="",AND(EXACT($AH$4,"H"),J9<>"h",M9<>"h"),
AND(EXACT($AH$4,"h"),L9<>"h",O9<>"h"),
AND($AH$4="x",K9<>"x",N9<>"x"),
AND(S9="",$AH$5<>"",$AH$5<>S9,$AH$5<>LEFT(S9,1),$AH$5<>VALUE(RIGHT(S9,1))),AND($AH$7<>"x",CZ9="T")),"",
IF(AND($AH$2="u",CY9="u"),"u",IF(AND($AH$2="d",CY9="d"),"d","")))

 

[Guest]

Never mind, got it: just needed an exclusion in front of problem, used:
IF(AND(S9<>"",$AH$5<>""),

 

[Guest]

okay, or: (i'll get it yet)
IF(AND(S9="",$AH$5<>""),TRUE,