Forum Discussion
Null String Problems
I have one worksheet in a workbook that contains several cells with drop-down lists, separated by rows and columns. On a separate worksheet I have created a column equal to the values contained in the...
Formulas in Excel don't return blank as a value, they return zero instead. You may return empty string instead as you do and ignore in other formulas cells which contains empty string "". Another option is to return 0 and apply custom format to resulting cells show them as empty cells.