Oct 20 2021 01:59 AM
I have some 20 nested IF(COUNTIF statements , too many for a single line of VBA code. I have tried to use space _ carriage return and "& space _ carriage return immediately before a new IF statement - see examples below - but all my attempts have been rejected:
IF(COUNTIF(RC[2],""*TWO*"",""Double"", _
IF(COUNTIF(RC[2],""*THREE*"",""Triple"","& _
"If.......
I would appreciate advice for correct syntax.