Topic
A Formula in Excel with the ISBLANK function returns an error or a value is still populating.
Additional Information
The Excel ISBLANK function returns TRUE when a cell is empty, and FALSE when a cell is not empty. For example, if A1 contains "apple", ISBLANK(A1) returns FALSE.
HOWEVER.....
If a formula returns an empty string, you can't use ISBLANK() because the presence of the formula makes the cell not functionally blank, even if it is visually blank.
Example
The below formula is not leaving the cell blank and is inserting the •(bullet point)
=IF(ISBLANK(Nintex_Tag_Value_1),"", "• "&Nintex_Tag_Value_1) - In this case, the desired outcome would be IF Nintex_Tag_Value_1 is blank then leave blank if not insert • &Nintex_Tag_Value_1
Instead, use the following
=IF(Nintex_Tag_Value_1 = "" ,"", "• "&Nintex_Tag_Value_1)
