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

    Help with an IF statement

    Ashraf Chohan



      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.