cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
huslayer Frequent Visitor
Frequent Visitor

show blank() as Blank() values in IF

Basically I want to show 3 values, pass,Fail, and blanks...

 

=IF( SomeDateColumn > TODAY() ,"Pass" , IF( Blank(), "" ,"Fail") ) 

 

I've some blank rows but still comes with FAIL instead of empty string or Blank values.

 

what I'm doing wrong?  

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: show blank() as Blank() values in IF

hi,@huslayer 

     ISBLANK(Column) return true or false and Column = Blank() is value of Column is Blank() .

for example:

ISBLANK(Column)=true() and Column = Blank() is the same result, and ISBLANK(Column)=false() and Column <> Blank() is the same result.

 

Best Regards,

Lin

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 REPLIES 3
Community Support Team
Community Support Team

Re: show blank() as Blank() values in IF

hi,@huslayer

     You can try to use this formula like below:

 

Column2 = IF( Table1[Date] > TODAY() ,"Pass" , IF(Table1[Date]= Blank(), "" ,"Fail") ) 

Result:

1.PNG

 

Best Regards,

Lin

 

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
huslayer Frequent Visitor
Frequent Visitor

Re: show blank() as Blank() values in IF

Hi Lin,

thanks for jumping in.

whats' the difference between ISBLANK(Column)  and Column = Blank()   or it's the same?

 

thanks

 

 

Community Support Team
Community Support Team

Re: show blank() as Blank() values in IF

hi,@huslayer 

     ISBLANK(Column) return true or false and Column = Blank() is value of Column is Blank() .

for example:

ISBLANK(Column)=true() and Column = Blank() is the same result, and ISBLANK(Column)=false() and Column <> Blank() is the same result.

 

Best Regards,

Lin

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.