View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
nastech
 
Posts: n/a
Default Value part of formula exlusion/ Not affects neg's: value

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<LEF T(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),$A H$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","")))