Try breaking your string into smaller strings.

=IF(E12=120,"long string1 "&"longstring2 "&"longstring3",if(e12<120,""))

I could break your long string into 2 pieces.

It broke he
Diseases, "&"Omega-3 Fatty

(but I couldn't make the post look nice because of the way it would wrap.)

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

--

Dave Peterson