2 Replies Latest reply on Sep 1, 2017 11:58 AM by Cris Ko

    case or iif or If  for multiple numbers

    Cris Ko

      Hi Gurus,



      I have scenario  of random numbers like


      1,2,3,5,6,7,10,14,16,17,19,21,22,24,26,27,88,123,124,126 etc.


      in calculate field I  want display


      1,2,3,5                             are   A

      6,7,10,14,16                      are B

      17,19,21,22,24                are   C

      26,27,88,123,124,126    are    D


      In case statement or IIF  or If we may handle multiple numbers ?

      Please help me syntax.


      Appreciate your response