If Not blank - Formula for two columns

[nikhilmanohar]

Hello,

How to compare two columns and return "0" if both columns are blank and return "1" otherwise. I'm an absolute beginner and any help would be greatly appreciated.

[Zubair_Muhammad · Accepted solution]

HI @nikhilmanohar

You can use this column

Column =
IF ( AND ( ISBLANK ( Table1[Col1] ), ISBLANK ( Table1[Col2] ) ), 0, 1 )

[nikhilmanohar]

@Zubair_Muhammad Thank you very much 🙂