use one value if both are filled

[Pierremeesters]

hi,

i'm combining 2 database with somewhat the same values. i'm using this if statement:

=if(isnull(INTRASTAT),[Intrastat code], if(isnull([Intrastat code]),[INTRASTAT])). 

But there are some value's that are in both "INTRASTAT"  and " intrastat code ". 

when that is the case none is used. How do i make it that if both value's are filled it uses just INTRASTAT ?  

[MarcoWedel · Accepted solution]

=If(IsNull(INTRASTAT),[Intrastat code],INTRASTAT)

[Pierremeesters]

@MarcoWedel  Thanks this worked!