Missed the Q4 Fall Release Product Update? Watch the on-demand webinar for more info on the latest in Designer 24.2, Auto Insights Magic Reports, and more!
community Alteryx IO Mission Control
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Free Trial

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
‎05-27-2024 01:53 AM

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

Preview file
6 KB
Labels:
Reply
0 Likes

Accepted SolutionSolved! Go to Solution.

2 REPLIES 2
binuacs
21 - Polaris
‎05-27-2024 02:39 AM

@jetmey use the isEmpty() function check the blank

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

 

Reply
Deano478
12 - Quasar
‎05-27-2024 02:43 AM

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

Reply
register for inspire
designer new user guide
Labels
Top Solution Authors
View All