2 Replies Latest reply: Dec 18, 2012 11:01 AM by Kristel Borremans RSS

    IF statement between value with specific need for 0 only

      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