5 Replies Latest reply on Jun 14, 2018 10:26 AM by Krishna Dudhela

    Displaying dynamic title using IF statement

    Krishna Dudhela

      Hi I am trying to display a dynamic title based on the filter we select.

       

      Given: 2 Filters

      1.Region Filter (containing values-NCA,SCA)

      2.Brokered/Direct Filter (containing values-Brokered,Direct)

       

      Requirement:

       

      If we select Region- NCA and Brokered/Direct-Brokered then display "NCA Brokered"

       

      Likewise if we select Region-both(NCA,SCA) and Brokered/Direct-Direct then it must display "CA Direct", etc.

       

      I used below if statements.

       

      My calculations are partially correct but it doesn't hold good for 2nd condition. Like below

       

       

       

      Can anybody help me correct my calculation?

       

       

      Attached workbook.

       

       

      Thanks,

      Krish.