Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

What is the Formula Fx if the excel formula is multiple condition and blank

jetmey
5 - Atom

IF Column A = Blank Then "N", ELSEIF Column A = USGA Then "N-USGA" ELSE "Y"

2 REPLIES 2
binuacs
20 - Arcturus

@jetmey use the isEmpty() function check the blank

IF isEmpty([Column A]) Then "N" ELSEIF [Column A] = "USGA" Then "N-USGA" ELSE "Y" ENDIF

 

Deano478
12 - Quasar

@jetmey to add to @binuacs solution if your blanks are Nulls the just replace isEmpty with isNull in binuacs formula

Labels