IF/OR For multiple Columns

[rogerthat]

Hello,

I've been having difficulty trying to figure a way to get the outputs from 3 columns if they contain a certain string, I'm bringing these items from other tables since there's no way to create relationships and merging has been giving odd results.

So, if any of the types contain "Yes" they should be Accepted, if else Decline

ID	TYPE1	TYPE2	TYPE3		EXPECTED OUTPUT COLUMN
1	YES	YES	NO		Accept
2	YES	YES	YES		Accept
3	NO	NO	YES		Accept
4	NO		NO		Decline

TIA

[CNENFRNL · Accepted solution]

Excel worksheet formula is way too powerful for such a simple question,

[rogerthat]

I would assume it would be that route, but for some reason it wasn't calculating correctly just with IF but this worked. 

[Whitewater100]

Hi:

This is a little wild but you can try as a measure:

Status =

var _concat = CONCATENATEX('Data', [TYPE1] &"-"&[TYPE2] &"-"&[TYPE3]&". ")

var _Find = FIND("YES", _concat, 1, BLANK())

return

IF(HASONEFILTER(Data[ID]),

IF(_Find >=1, "Accept", "Decline"))

[Syk]

Create a conditional column and fill out the boxes to match what you need (see screenshot below)