Challenge #366: Three Columns Are a Crowd

[MilindG]

Spoiler

[Manav_Sehra]

My solution is attached. 

Spoiler

[anthonyw]

Challenge Accepted

[dicky5150]

Spoiler

Liked this challenge, actually learnt a few things with it !!

[Dev73]

Easy way

Spoiler

 

[TheUdbhav]

Hi Everyone,

I used nested IF ELSE to get the output.

IF IsNull([Address]) THEN "" ELSE [Address]+"," ENDIF
+
IF (IsNull([Apt/Unit])) THEN ""
else
IF IsNull([Zip]) THEN [Apt/Unit] ELSE [Zip] ENDIF
endif
+
IF IsNull([Address]) AND IsNull([Apt/Unit]) THEN [Zip] ELSE "" ENDIF


Please find my attached solution!

[EdoardoAversaTIL]

Spoiler

[Desmond]

My solution

[jimybyrne17]

Spoiler

[JS1989]

Solution