How to Concatenate Strings with nested IF statements
I have four line items(Text1, Number1, Text2, Number2) I am trying to concatenate if those values are not blank or not equals to zero. See below formula. But I am getting formula invalid error. Please suggest how can i do concatenation of multiple string with nested IF statements.
Note: Please suggest me any Idea with only nested IF's not by creating system module or any other modules because i have a size limitation.
IF ISNOTBLANK(Text1) THEN Text1 ELSE
IF Number1>0 THEN & " " & TEXT(Number1) ELSE
IF ISNOTBLANK(Text2) THEN & " " & Text2 ELSE
IF Number2>0 THEN & " " & TEXT(Number2) ELSE BLANK