Checking conditions of two fields

[alkafalhas]

Hi 

I'm trying to do a very simple comparison but couldn't think of an efficient tool to do it.

As an example, if [Items] = WEATHER01, [value] <= 25, then [Conditions agree] = yes.

Below is sample output expected.

Items	Value	Conditions agree?
WEATHER01	20	Yes

Thank you in advance

[Luke_C · Accepted solution]

Hi @alkafalhas 

A formula tool with an if statement will get this done. See below and attached

[Emil_Kos · Accepted solution]

Hi @alkafalhas,

I have a feeling that you have more condition for different items:

The output:

[alkafalhas]

Hi @Luke_C 

What if i have a multiple items? should I add same formula by using the (+) button in the formula tools? or you have better ideas?

[Luke_C]

Hi @alkafalhas 

I would suggest implementing something like @Emil_Kos suggested, a mapping table for items and their thresholds. 

[Emil_Kos]

Hi @alkafalhas,

The mapping table is always easier to maintain in a long run. So if possible I would almost always suggest using mapping tables instead of the formula tool. 

[alkafalhas]

Hi @Emil_Kos 

Thank you for helping so far.

If I have a multiple items with different conditions, how can i address it?

Example below:

Items	Value	Conditions	Output
WEATHER01	20	Yes, if value<=20	yes
WEATHER02	20	Yes, if value<=10	No
WEATHER03	40	Yes, if value<=40	Yes

[Emil_Kos]

Hi @alkafalhas,

Here you go:

Output: