Hi, thanks for the input, sorry didn't give specs on that, but am using text;
thought I had picked wrong cell for if "" about: J9 was accident. I put
AV9="" back in, it resolved that. Did not know if was having memory problems
because of that, just posted question iterations/changes (options,
calculations) was trying to see what was going wrong in couple places.

where at now, if you want to see, is a similar problem? maybe with the
following:
(hope not too long) quick break down: 1st 3rd: putting text date in a
column, if date within x days, get "dd" result. was given answer to have to
repeat other / subsequent equations TWICE: to skip past a false scenario of
1st pass.

PROBLEM right now is where should be a "up" answer in an example, does not
go to "up" right away, BUT GOES TO last answer: "ck" don't know why.
guessing something similar for an equation problem. else things like
iterations, macro's running stealing something away from..? recent changes
made.. thanks

=IF(AND(LEFT(T9,1)=":",ISNUMBER(ABS(MID(T9,2,6)))) ,IF(AND(MIN(AK9:AO9)<1,TODAY()DATE(MID(T9,2,2)+10 0,MID(T9,4,2),MID(T9,6,2)-($H$7+1))),"dd",IF(AND($H$4<"z",OR(AND($H$4<"x", LEN(S9)=5),MID(S9,5,1)={"f","r","q"})),"w:",IF(AN D(AP9<"",AQ9<$AQ$7,AND($H$5<"x",AP9<$AP$7)),"pv" ,IF(BE9="T","dn",IF(AND(BF9="T",LEFT(J9,3)="spu"), "sp",IF(BF9="T","up",IF(P9<"","ck",""))))))),IF(A ND($H$4<"z",OR(AND($H$4<"x",LEN(S9)=5),MID(S9,5 ,1)={"f","r","q"})),"w:",IF(AND(AP9<"",AQ9<$AQ$7, AND($H$5<"x",AP9<$AP$7)),"pv",IF(BE9="T","dn",IF( AND(BF9="T",OR(LEFT(J9,3)="spu",P9="spu")),"sp",IF (BF9="T","up",IF(P9<"","ck","")))))))


XXXXXXXXXXXXXXXXXXXXXXXXX

"exceluserforeman" wrote:


It works for me


if the length of J9 ="" then nothing else if length of J9 3 then "hello"
otherwise if the length is more than 0 but less that 3 then "HELLO"

Of course I put this formula into D2 for the results

Maybe you should make len(J9)=0 instead of ""



"nastech" wrote:

060124 5pm PROBLEM: Excel Equation Function / Conditional Formatting Dropout
Having some problems with entering data. Symptom is when enter data in one
column, its mirror image was not showing up in different column (using:
=IF(J9="","",IF(LEN(J9)3,AV9,UPPER(AV9)))

Other intermittant symptoms: - Conditional Formating was not changing color
in either column, intermittantly.
- Delete data from 1st column & intermittant: either mirror text does not
go away, or conditional formats remained color, in changed, unchanged,
intermittant fashion.

SOME SETTINGS INCLUDE:
MEMORY: 128 MB
PAGE FILE: was set at 400MB max 800 MB, changed to automatic
OPTIONS, calculations, MAX ITERATIONS: 20 MAX CHANGES: 10

Is there advice I can get for computer settings, in general, and to help
with this situation?

Any recommendations on Memory Utilities will be greatly appreciated. Thanks.