Formula configuration - If contains.... and is not null

[JulianneKorn]

Hello!

New to Alteryx! I created the below formula, but want to add that if the field is null, then "Unknown" but am having issues:

iif(contains([parEthnicity],"Hispanic or Latino/Latina"),"Hispanic or Latino/Latina","Non-Hispanic/Non-Latino/Latina")

Thanks in advance for your help!

[JulianneKorn · Accepted solution]

if IsNull([parEthnicity]) then 'Data Not Collected' 
elseif Contains([parEthnicity], 'Hispanic or Latino/Latina') then 'Hispanic or Latnio/Latina' 
else 'Non-Hispanic/Non-Latino/Latina'
endif