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.