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

Giganews Newsgroups
Subject: Value part of formula exlusion/ Not affects neg's: value
Posted by:  nastech
Date: Wed, 10 May 2006

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","")))

Replies