I belive so.
I would not dare to suggest that Jacob wouldn't have spotted that - there is
so much i can learn from Jacobs posts here.


"Rick Rothstein" wrote in message
...
Yes, =IF(E12=120,F1,""). I think Jacob just went along with the OP's
original structure as he addressed the area causing the problem (too much
text) and didn't actually pay attention to the formula itself... this is
quite a common thing which I'm sure all responders have done at one time
or another.

--
Rick (MVP - Excel)


"AB" wrote in message
...
Danny,

There surely must be a reason but still looks interesting the 2nd IF in
the formula:
IF(E12<120,"")

I thought that the 1st IF would take care of it as surely if E12 is not
=120, then it's <120 and just "" should be returned.
Wouldn't this work:
=IF(E12=120,F1,"")



"Jacob Skaria" wrote in message
...
Hi Danny

In 2003 you are limited to 1024 characters in a formula,
In 2007 the limit is 8192

So you can have your text in another cell and refer that in your formula

'With the text in cell F1
=IF(E12=120,F1,IF(E12<120,""))


If this post helps click Yes
---------------
Jacob Skaria


"Danny" wrote:

I have been receiving this error message with the following formula.
How do I
fix it? If I substitute the letter "A" for all of the text in
parentheses,
the formula works.

=IF(E12=120,"Insulin Resistance / Diabetes, Lipidproteinemia,
Hepatitis,
Liver Congestion, Acute Pulmonary Infarction, Extensive Pneumonia,
Advanced
Cancer, Anemia, Lymphocytosis, Skeletal Muscle Dysfunction, Systemic
Conditions, Collagen Vascular Diseases, Omega-3 Fatty Acid Deficiency,
Hypertriglyceridemia, Alcoholism, Renal Dysfunction, Acute
Pancreatitis,
Gout, Oral Contraceptives, Excess Fructose Consumption",IF(E12<120,""))

Thanks