Multiple Field Condition

LeeZH1998

How do I set a condition for multiple fields for example the

If [Type of Fruit] is Apple/Orange and [Taste] is Sweet and [Colour] is Red/Green and [Storage Time] is more than 3 days, return Yes in [Good Fruit]

Input
Type of Fruit	Taste	Colour	Storage Time
Apple	Sweet	Red	4 days
Oranges	Sweet	Orange	3 days
Apple	Sour	Green	5 days
Pear	Sour	Green	5 days
Output
Type of Fruit	Taste	Colour	Storage Time	Good Fruit
Apple	Sweet	Red	4 days	Yes
Oranges	Sweet	Orange	3 days	Yes
Apple	Sour	Green	5 days	No
Pear	Sour	Green	5 days	No

20201001 Alteryx Sample.xlsx

atcodedog05

Hi @LeeZH1998 ,

Here is the formula for Good Fruit

IF ([Type of Fruit] = "Apple" or [Type of Fruit] = "Orange") 
and ([Taste] = "Sweet") 
and ([Colour] = 'Red' or [Colour] = 'Green') 
and (ToNumber(Left([Storage Time], 1))>=3)
THEN 'Yes' ELSE 'No' ENDIF

Pst... you said for good fruit color is red or green your output has considered even orange as good. Add in the color group if needed

Workflow

Output

Hope this helps : )

If this helps please mark the post as solution. And give a like if you dont mind.

condition.yxmd