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

[atcodedog05 · Accepted solution]

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.

[jdunkerley79]

An expression like:

If [Type of Fruit] in ('Apple', 'Orange') and [Taste] = 'Sweet' 
 and [Colour] in ('Red', 'Green') and ToNumber(REGEX_Replace([Storage Time],"(\d+).*","$1")) > 3 
THEN 'Yes' ELSE 'No' ENDIF

should give you close to what you want

Have attached a sample

[atcodedog05]

Happy to help : ) @LeeZH1998 

Cheers and happy analysing : )

[atcodedog05]

Great use of "In" function @jdunkerley79