Eat More Bacon
Member
Can I write an if function that returns false if the cell is blank or if there is an empty string? ("")
Or using :or use NOT:
=NOT(ISBLANK(cell))
or
NOT(cell="")
Note that ISBLANK doesn't see a formula returning "" as blank (also if a cell formula returnng "" is copied to a cell as values, it too won't be seen as blank by ISBLANK), so the cell="" is probably safer for you.
Or you could use COUNTBLANK instead which recognizes the null string ""Note that ISBLANK doesn't see a formula returning "" as blank (also if a cell formula returnng "" is copied to a cell as values, it too won't be seen as blank by ISBLANK), so the cell="" is probably safer for you.
Yes! I thought of this 10mins after posting!Cell <>""
Haha!Yes! I thought of this 10mins after posting!