Value part of formula exlusion/ Not affects neg's: value 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","")))