If null statement

[Cherkos12]

This is the type of output i was hoping to get but my formula doesn't seem to produce this. How'd i got about capturing this?

Company	Field 1	Field 2	Output
A	AG	AG	AG
B	AE		AE
C		BC	BC
D	ZY		ZY

[mathieuf]

Hi @Cherkos12,

Try this

[Cherkos12]

Thanks. i tried it and didn't work for me.

[mathieuf]

I have the following output

How can I help?

[binuacs]

@Cherkos12 

IIF(IsEmpty(Trim([Field 2])),[Field 1],IIF(IsEmpty(Trim([Field 1])),[Field 2],[Field 1]))

Spoiler