Get names from 3 columns using IF loop

[Desaisid]

Please give me formula for my Answer Column in Formula tool

Class 1	Class 2	Class 3	Answer Column
A		E	E
	B		B
F		C	C
D			D
G	H		H

I have added this formula for Answer Column which is not working, Could you please let me know the correct formula so I get the Answer column data from fir 3 columns.

IF IsEmpty([Class 3]) Then [Class 2]
Elseif IsEmpty([Class 2]) Then [Class 1]
Else [Class 1]
Endif

[binuacs · Accepted solution]

@Desaisid Try the below formula

IF !IsEmpty(trim([Class 3])) Then [Class 3]
Elseif !IsEmpty(Trim([Class 2])) Then [Class 2]
Else [Class 1]
Endif

[Desaisid]

Thanks