Calculated column based on two different columns

Question

Hello, I am trying to set up a calculated column to say:

If Column A is not blank, "statement1",
if Column B is not blank, "statement 2",
if Column A & Column B are not blank, "Statement 1 & 2",
otherwise state "Blank".

For some reason I can't get this working? E.g. if I try something like this, it just stops at column A when both are true.

=IF([columnA]<>"","statement1",IF([columnB]<>"","statement2"))

Answer 1

Hi @Lauren ,

Please try to use this.

=IF(AND(ColumnA="",ColumnB=""),"BLANK",IF(AND(NOT(ColumnA=""),ColumnB=""),"statement1",IF(AND(NOT(ColumnA=""),NOT(ColumnB="")),"statement1&2","statement2")))  

Output:

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

Hi JinweiLi-MSFT, spot on, thank you so much!