Formula help

[Isha_Gupta]

hey,

I have a dataset with 5 columns, I need help to create formula for the 6th column.

The logic would be:

If value in column 2 and column 4 is same then 6th column will have "matched"

If they are different then: 

1) If either column is blank and other one has value then 6th column will be manual.

2) If both columns has value but they are different then it will be mismatch in the 6th column.

[binu_acs]

@Isha_Gupta One way of doing this

[NickRogers]

Hi, You could try this formula

if IsNull([column2])and IsNull([column4]) then 'manual'
elseif [column2]=[column4] then 'matched'
elseif IsNull([column2]) or IsNull([column4]) then 'manual'
else 'mismatch'
endif

I've assumned that if both are blank then you would go with 'manual'