memory? Excel Equation Function / Cond. Formatting Dropout

[Guest]

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.

 

[Guest]

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 ""

 

[Guest]

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 re: 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)+100,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(AND(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(AND($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