4 Replies Latest reply: Sep 26, 2012 12:09 PM by Adotey Kwame RSS

    IF statement to categorize..

    Adotey Kwame

      Hi,

       

      i'm trying to categorize the using an If statement.

       

      IF (Amount <= 200,'<=500',IF(Amount >500<1001,'501-1000',IF(Amount >1000>2000'1001-2000',null()) )) as AmountSize;

       

      Please help .Thanks