IF statement between value with specific need for 0 only

[#1]

Hello;

Looking for help with this basic IF statement.

I would like the system to report the following:

If the value is equal to zero mark it as 0.

If the value is bigger than 1.5 mark it as 1.

If the value is samller than 0.3 mark it as 1.

If the value is in between 0.3 and 1.5 mark it as 0.

I have tried if(value=0 and value>0.3 and value<1.5,0,1)

Not returning what I am looking for.

Thanks in advance for your answer.

Kristel

[Gysbert_Wassenaar · Accepted solution]

try if( (value>0 and value<0.3) or value >1.5,1,0)

[#3]

MANY THANKS!!!!!!!