Forum Discussion
Solved
If Not blank - Formula for two columns
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.
You can use this column
Column = IF ( AND ( ISBLANK ( Table1[Col1] ), ISBLANK ( Table1[Col2] ) ), 0, 1 )
You can use this column
Column = IF ( AND ( ISBLANK ( Table1[Col1] ), ISBLANK ( Table1[Col2] ) ), 0, 1 )
Zubair_Muhammad Thank you very much :)