I have a field with the expression below: (I've made the fields generic so they are easier to understand)
IIF(Field1='Example Text',[IDCode] & [IDCounty],[IDCode] & [IDNumber])
This table hopefully summarises what is currently happening:
<tbody>
Field1
IDCode
IDCounty
IDNumber
Calculated...