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.

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.

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.