IF statement to categorize..

[Anonymous]

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

[billbois · Accepted solution]

I'm unable to test this at the moment, but I think it would be something like this:

IF (Amount <= 200, '<=500',

    IF(Amount >500 AND Amount <1001, '501-1000',

    IF(Amount >1000 AND Amount <2000, '1001-2000',

    null()))) as AmountSize;

Hope this comes close.

[MayilVahanan]

HI

IF (Amount <= 500, '<=500',

    IF(Amount >500 AND Amount <1001, '501-1000',

    IF(Amount <2000, '1001-2000',null()))) as AmountSize;

Hope it helps

[Anonymous]

script line error

[Anonymous]

sorry it worked,i had the same script in a different tab ,that's why i had the error

Thank you both