2 Replies Latest reply: Dec 23, 2015 2:59 AM by Jim Chan RSS

    If statement + multiple value in 1 dimension

    Jim Chan

      Hi guys,

       

      i have a line of code as such:

       

      if(RC_COUNTRYNAME='Japan',if (RC_TITLE='Executive Summary',if(RC_KPI='Overall',IF(len(RC_RGNL_CMNTS)=0 AND len(RC_CNTRY_CMNTS)=0,'NO COMMENTS AVAIL',IF(len(RC_RGNL_CMNTS)=0 ,RC_CNTRY_CMNTS,RC_RGNL_CMNTS)))))

       

      so. problem i m having now is, for RC_COUNTRYNAME , i want to add more than 1 country, like 'Japan', 'Korea','India'. How can i rectify that?

       

      Rgds,

       

      Jim