Compare data 2 columns

[JDong]

Hi Team,

I have 2 data columns and sample as below

A	B
216.00	335.80
208.30	156.90
0.00	127.60
0.00	0.00
0.00	219.00
56.26	79.00
0.00	228.00
0.00	0.00
0.00	165.10
0.00	72.00
0.00	118.00
0.00	77.00
0.00	0.00
0.00	172.50
0.00	156.00

I want to write a logic like below

IF !isnull([A]) THEN 'CatA'
ELSEIF !isnull([B]) THEN 'CatB'
ELSEIF !isnull([CatA]) and !isnull([CatB]) THEN 'Both'
ELSE '-'
ENDIF

But I do not see the right results considering the above formula. I want to if value only in "A" call in a new field CatA and if value only in "B" then CatB and if value in both columns then as "Both"

Thanks!

[geraldo]

@JDong 

IF !isnull([CatA]) and !isnull([CatB]) THEN 'Both'

elseif !isnull([A]) THEN 'CatA'
ELSEIF !isnull([B]) THEN 'CatB'
ELSE '-'
ENDIF