3 Replies Latest reply on May 19, 2016 7:41 AM by msa s

    Nested IF or IIF Statements

    Christopher McKinnish

      I'm sure I woke up on the wrong side of the bed. 



      1. Parameter = A, B or C
      2. Sheets, X, Y


      In Layman's terms I need...

      If Parameter = A, then X

      If parameter = B, then Y

      If Parameter = C, then Null [or return nothing]


      I've tried IF, IIF, Case and cannot seem to get this to work.


      Could one of you genius' point offer guidance?