Help with how to fill nulls

Question

So I'm trying to run a logic code, that fills nulls. The SEAL is same the same for all counties.  My logic code below works for US and HK, however I'm still seeing nulls for IND and LUX. Can you please help?

IF IsNull([US SEAL])

THEN [HK SEAL]

ELSEIF IsNull([US SEAL]) AND IsNull([HK SEAL])

THEN [IND SEAL]

ELSEIF IsNull([US SEAL]) AND IsNull([HK SEAL]) AND IsNull([IND SEAL])

THEN [LUX SEAL]

ELSEIF IsNull([US SEAL]) AND IsNull([HK SEAL]) AND IsNull([IND SEAL]) AND IsNull([LUX SEAL])

THEN 0

ELSE [US SEAL]

ENDIF

ydklyfe · Answer

Here, is an example. The goal is to have all the countries seal number in the SEAL column.

dummy data.xlsx

Screen Shot 2022-06-08 at 10.27.32 AM.png

ydklyfe · Answer

I will upload a dummy data soon.

tkong · Answer

Do try @IraWatt suggestion, but if you are building nestedif, would it be better to list out the most specific first?  Like

IsNull([US SEAL]) AND IsNull([HK SEAL]) AND IsNull([IND SEAL]) AND IsNull([LUX SEAL]) first, then

IsNull([US SEAL]) AND IsNull([HK SEAL]) AND IsNull([IND SEAL])

and so on?