Forum Discussion

nikhilmanohar's avatar
nikhilmanohar
Icon for Helper I rankHelper I
8 years ago
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.    
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    8 years ago

    HI nikhilmanohar

     

    You can use this column

     

    Column =
IF ( AND ( ISBLANK ( Table1[Col1] ), ISBLANK ( Table1[Col2] ) ), 0, 1 )
Zubair_Muhammad's avatar
Zubair_Muhammad
Icon for Community Champion rankCommunity Champion
8 years ago

HI nikhilmanohar

 

You can use this column

 

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