4 Replies Latest reply on Jan 23, 2018 2:24 AM by Ashraf Chohan

    Help with an IF statement

    Ashraf Chohan

      Hello

       

      I'm working with 2 columns of data from which I need to create a third column via a calculated field. I basically need an IF statement which gives me this:

       

      If Column B = "Large" then call it "Large"

      If Column B = "Null" but Column A = "Large" then also call it "Large"

      Otherwise call it "Small"

       

      I can't quite get this right, any help appreciated.

       

      Thanks