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. 

       

      Given: 

      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?