View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Danny[_3_] Danny[_3_] is offline
external usenet poster
 
Posts: 14
Default Excel Error Message

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