6 Replies Latest reply: Dec 28, 2016 3:20 AM by sravanthi aluvala RSS

    Using IF condition in Text box

      Hello friends,


      I need your help in what seem to be easy and straightforward yet i am not able to do it. I am trying to create a text box which how name of the market when i select an agent.


      for this i am doing

      ='Market: ' & Market

      and the outcome is something like Market: Alabama. Now  the problem is if the agent has multiple markets the filed goes Blank


      I tired using


      =if(Market>1, 'Multiple Markets', Market)


      But nothing works. Please help me out with this.


      I really appreciate all your help and support.


      Thank you,