OR statement in an array (How to convert using NOT)

[Phutile]

How can I change what I would want to use as an OR statement in an array to a NOT statement. I believe that a NOT statement can be used in the OR statements place in an array (correct me if I'm wrong). I saw it in a book at Barnes & Noble (WISH I BOUGHT THE BOOK NOW!), but i just can't remember how to write it. Can someone help with a simple example?
Thanks

 

[Dave Patton]

On 2002-08-28 06:55, Phutile wrote:
How can I change what I would want to use as an OR statement in an array to a NOT statement. I believe that a NOT statement can be used in the OR statements place in an array (correct me if I'm wrong). I saw it in a book at Barnes & Noble (WISH I BOUGHT THE BOOK NOW!), but i just can't remember how to write it. Can someone help with a simple example?
Thanks

Please write a concise example of what you would like to do.

 

[Phutile]

Here is my formula:
{=IF(U2='160379'!$P$5:$R$18,IF(OR(Dept160!S2>'160379'!$B$5:$D$18+'160379'!$H$5:$J$18,Dept160!S2<'160379'!$B$5:$D$18-'160379'!$H$5:$J$18),""),"")}
It is fugly. I'm sure there is a better way to "flag" a cell that contains my conditions. I'm not even sure I can go about using an array like I am ($B$5:$D$18+$H$5:$J$18)???? I just want to see if I can change that OR statement to a NOT(NOT() something to test it.
Thanks.

 

[Phutile]

any suggestions? i'm stumped

 

[Aladin Akyurek]

On 2002-08-28 07:35, Phutile wrote:
any suggestions? i'm stumped

I'm not sure what that array formula is supposed to do. Care to elaborate?

By the way, NOT (in propositional logic) applies to single 'sentences'...

 

[Phutile]

Here is the formula I'm at now:
{=IF(U2='160379'!$P$5:$R$18,IF(NOT(Dept160!S2<'160379'!$B$5:$D$18+'160379'!$H$5:$J$18),IF(NOT(Dept160!S2>'160379'!$B$5:$D$18-'160379'!$H$5:$J$18),TRUE,""),""),"")}
It doesn't work...but I want it to! =P
What I'm trying to do...I want it to match up with an identifier (U2='160370'!P5:R18), then I want it to check for ouliers by checking if S2 is greater than or less than '160379'!B5+-H5, and give TRUE if it is outside that range and "" if not. However, I most likely am screwing up because I have three columns that I am looking at...and I want excel to know that if you find the match in one of the columns, then go left or right that many columns and use those numbers. So to say....my identifiers are in columns P,Q,and R. I have three other columns with the Averages (B,C,and D), and then three other columns with the StDev (H,I,and J). I want to have my formula check the identifier and match, then if that value is in ...say P, then it will check if S2 is > or < B5+-H5 ...say Q, then it will check if S2 is > or < C5+-I5 ...say R, then it will check if S2 is > or < D5+-J5. Maybe I'm being too greedy in one formula. Can you help Aladin? If you need to see more, I'll email an example.

Thanks