software

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=quot;quot;,quot;quot;,IF(LEN(J9)gt;3,AV9,UPPER(AV9)))

Other intermittant symptoms: - Conditional Formating was not changing color
in either column, intermittantly.
- Delete data from 1st column amp; 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 meif the length of J9 =quot;quot; then nothing else if length of J9 gt; 3 then quot;helloquot;
otherwise if the length is more than 0 but less that 3 then quot;HELLOquot;

Of course I put this formula into D2 for the results

Maybe you should make len(J9)=0 instead of quot;quot;
quot;nastechquot; wrote:

gt; 060124 5pm PROBLEM: Excel Equation Function / Conditional Formatting Dropout
gt; Having some problems with entering data. Symptom is when enter data in one
gt; column, its mirror image was not showing up in different column (using:
gt; =IF(J9=quot;quot;,quot;quot;,IF(LEN(J9)gt;3,AV9,UPPER(AV9)))
gt;
gt; Other intermittant symptoms: - Conditional Formating was not changing color
gt; in either column, intermittantly.
gt; - Delete data from 1st column amp; intermittant: either mirror text does not
gt; go away, or conditional formats remained color, in changed, unchanged,
gt; intermittant fashion.
gt;
gt; SOME SETTINGS INCLUDE:
gt; MEMORY: 128 MB
gt; PAGE FILE: was set at 400MB max 800 MB, changed to automatic
gt; OPTIONS, calculations, MAX ITERATIONS: 20 MAX CHANGES: 10
gt;
gt; Is there advice I can get for computer settings, in general, and to help
gt; with this situation?
gt;
gt; Any recommendations on Memory Utilities will be greatly appreciated. Thanks.
gt;

Hi, thanks for the input, sorry didn't give specs on that, but am using text;
thought I had picked wrong cell for if quot;quot; about: J9 was accident. I put
AV9=quot;quot; 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 quot;ddquot; 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 quot;upquot; answer in an example, does not
go to quot;upquot; right away, BUT GOES TO last answer: quot;ckquot; 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)=quot;:quot;,ISNUMBER(ABS(MID(T9,2,6)))) ,IF(AND(MIN(AK9:AO9)lt;1,TODAY()gt;DATE(MID(T9,2,2) 10 0,MID(T9,4,2),MID(T9,6,2)-($H$7 1))),quot;ddquot;,IF(AND($H$4lt;gt;quot;zquot;,OR(AND($H$4lt;gt;quot;xquot;, LEN(S9)gt;=5),MID(S9,5,1)={quot;fquot;,quot;rquot;,quot;qquot;})),quot;w:quot;,IF(AN D(AP9lt;gt;quot;quot;,AQ9lt;$AQ$7,AND($H$5lt;gt;quot;xquot;,AP9lt;$AP$7)),quot;pvquot; ,IF(BE9=quot;Tquot;,quot;dnquot;,IF(AND(BF9=quot;Tquot;,LEFT(J9,3)=quot;spuquot;), quot;spquot;,IF(BF9=quot;Tquot;,quot;upquot;,IF(P9lt;gt;quot;quot;,quot;ckquot;,quot;quot;))))))),IF(A ND($H$4lt;gt;quot;zquot;,OR(AND($H$4lt;gt;quot;xquot;,LEN(S9)gt;=5),MID(S9,5 ,1)={quot;fquot;,quot;rquot;,quot;qquot;})),quot;w:quot;,IF(AND(AP9lt;gt;quot;quot;,AQ9lt;$AQ$7, AND($H$5lt;gt;quot;xquot;,AP9lt;$AP$7)),quot;pvquot;,IF(BE9=quot;Tquot;,quot;dnquot;,IF( AND(BF9=quot;Tquot;,OR(LEFT(J9,3)=quot;spuquot;,P9=quot;spuquot;)),quot;spquot;,IF (BF9=quot;Tquot;,quot;upquot;,IF(P9lt;gt;quot;quot;,quot;ckquot;,quot;quot;)))))))XXXXXXXXXXXXXXXXXXXXXXXXX

quot;exceluserforemanquot; wrote:

gt;
gt; It works for me
gt;
gt;
gt; if the length of J9 =quot;quot; then nothing else if length of J9 gt; 3 then quot;helloquot;
gt; otherwise if the length is more than 0 but less that 3 then quot;HELLOquot;
gt;
gt; Of course I put this formula into D2 for the results
gt;
gt; Maybe you should make len(J9)=0 instead of quot;quot;
gt;
gt;
gt;
gt; quot;nastechquot; wrote:
gt;
gt; gt; 060124 5pm PROBLEM: Excel Equation Function / Conditional Formatting Dropout
gt; gt; Having some problems with entering data. Symptom is when enter data in one
gt; gt; column, its mirror image was not showing up in different column (using:
gt; gt; =IF(J9=quot;quot;,quot;quot;,IF(LEN(J9)gt;3,AV9,UPPER(AV9)))
gt; gt;
gt; gt; Other intermittant symptoms: - Conditional Formating was not changing color
gt; gt; in either column, intermittantly.
gt; gt; - Delete data from 1st column amp; intermittant: either mirror text does not
gt; gt; go away, or conditional formats remained color, in changed, unchanged,
gt; gt; intermittant fashion.
gt; gt;
gt; gt; SOME SETTINGS INCLUDE:
gt; gt; MEMORY: 128 MB
gt; gt; PAGE FILE: was set at 400MB max 800 MB, changed to automatic
gt; gt; OPTIONS, calculations, MAX ITERATIONS: 20 MAX CHANGES: 10
gt; gt;
gt; gt; Is there advice I can get for computer settings, in general, and to help
gt; gt; with this situation?
gt; gt;
gt; gt; Any recommendations on Memory Utilities will be greatly appreciated. Thanks.
gt; gt;