Problem with condition based on whether or not column is empty

I have a real column (one with data in the spreadsheet), called [DW Set aside], that may or may not have text in it. I want to have a virtual column display “None” if the cell is empty but to display the text if it has any. This formula seems to work:

if( len([DW Set aside])=0, “None”, [DW Set aside] )

However, the following did not work:

if([DW Set aside]="",“None”,[DW Set aside])

In regard to this second expression, it always shows “None”, even when the column has text. I wonder why.

Solved Solved
0 2 449
1 ACCEPTED SOLUTION

Steve
Platinum 5
Platinum 5

Because the = and <> operators are magical: if the left-hand operand is blank, the result will be TRUE regardless of the right-hand operand. Hence ISBLANK() and ISNOTBLANK().

View solution in original post

2 REPLIES 2
Top Labels in this Space