- You are here
- Microsoft Newsgroups Archived.At
- microsoft.public.excel.misc
- 2006 May
- 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","")))

- RE: Value part of formula exlusion/ Not affects neg's: value posted by nastech on Wed, 10 May 2006