5 Replies Latest reply: Sep 15, 2014 6:36 AM by Deepak Tibhe RSS

    Weight ranges

      Hi,

       

      I am trying to group some shipment data by weight range in a Straight table, however I can only get it to work partially.

      At the moment I am using an IF function like this:

       

      =If(SHP_WEIGHT <=0.50, '0.5KG',

      If(SHP_WEIGHT >>0.50<=1.00, '1KG',

      If(SHP_WEIGHT >>1.01<=2.00, '2KG',

      If(SHP_WEIGHT >>2.01<=3.00, '3KG',

      If(SHP_WEIGHT >>3.01<=4.00, '4KG',

       

      'unknown')))))

       

       

      This is not giving me the result I need.

      The 2KG range now shows from 2.00 up to 6.00 and the 3KG range shows for 6.00 up to 16.00.

      How can I fix this?