Formula help
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
Isha_Gupta
8 - Asteroid
‎10-09-2023
02:28 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
Labels:
- Labels:
- Help
2 REPLIES 2
binuacs
21 - Polaris
‎10-09-2023
02:54 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@Isha_Gupta One way of doing this
NickRogers
8 - Asteroid
‎10-09-2023
03:06 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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'