VBA Syntax

New Contributor

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"","& _
I would appreciate advice for correct syntax.

1 Reply
Please show us the entire statement and not just a part of it.