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)




      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.