Code won't run in XL2003

[BradleyS]

Hi
If possible could somebody tell me why this section of formula code won't work in XL2003?
It runs fine in XL2010, but I need it to work in XL2003 as well.


'ActiveCell.FormulaR1C1 = _
'"=IF(DATE(1938,9,1)>=RC2,""FLU2"",IF(DATE(1948,9,1)>=RC2,""FLU1"",IF(DATE(1948,9,1)<=RC2,IF(RC[8]=""Carer"",""ZFCARE"",IF(RC[8]=""Chronic Heart Disease"",""ZFCHD"",IF(RC[8]=""Chronic Liver Disease"",""ZFCLD"",IF(RC[8]=""Chronic Neurological Disease"",""ZFCNS"",IF(RC[8]=""Chronic Renal Disease"",""ZFCRD"",IF(RC[8]=""Chronic Respiratory Disease"",""ZFCRES"",IF(RC[8]=""Diabetes"",""ZFDM"",IF(RC[8]=""Long-stay residential"",""ZFHOME"",IF(RC[8]=""Immunosuppression"",""ZFIMM"",IF(RC[8]=""Pregnant"",""ZFPREG"",IF(RC[8]=""Stroke / TIA"",""ZFSTIA"",IF(AND(RC[-2]<=DATE(2010,9,1),RC[-2]>=DATE(2009,9,1)),""ZLF3"",IF(AND(RC[-2]<=DATE(2011,9,1),RC[-2]>DATE(2010,9,1)),""ZFL2"",IF(RC[8]="""",""Unidentified"",)))))))))))))),""N/A"")))"

 

[Michael M]

Ok, the reason it doesn't work in 2003 is that 2003 has a 7 Nested IF limit !!
Without seeing some data, I'm guessing you'll need to create something like a VLOOKUP list to find the data you need !

AND
Please use code tags when posting, it makes the examples far easier to read and debug.
See the last line of my tag for this

 

[BradleyS]

Thank you that answers the question.