Exists

  • Thread starter Thread starter Drew
  • Start date Start date
D

Drew

Is there a quick way of finding out if a cell is empty or
not? This is to avoid #VALUE! and #DIV/0! values in other
cells that use the empty cell in there function.
What I am looking for is
if empty do null else calculate the formula.

Cheers
Drew
 
You can simply run an "ISBLANK" check. For example:

=IF(ISBLANK(M6) = TRUE, "Null", "Not Null")
or in your case
=IF(ISBLANK(M6) = TRUE, "", M6)

Hope this works.

JCH
 
Works a treat, thanks!

Drew
-----Original Message-----
You can simply run an "ISBLANK" check. For example:

=IF(ISBLANK(M6) = TRUE, "Null", "Not Null")
or in your case
=IF(ISBLANK(M6) = TRUE, "", M6)

Hope this works.

JCH

.
Click to expand...
 
Back
Top