M
Matt
Is there a function that will tell me is a cell is not blank, or in
other words, does contain a value?
other words, does contain a value?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
Dave Peterson
=NOT(ISBLANK(A1))
Is there a function that will tell me is a cell is not blank, or in
other words, does contain a value?
J
Jim May
Maybe:
=NOT(ISBLANK(B3))
=NOT(ISBLANK(B3))
K
Kevin B
Try something like this:
=IF(NOT(ISBLANK(A1)),"Value","No Value")
There are many IS functions you can use to determine any number of values
ISODD
ISEVEN
ISNUMBER
Check Excel help for details regarding additional IS functions.
=IF(NOT(ISBLANK(A1)),"Value","No Value")
There are many IS functions you can use to determine any number of values
ISODD
ISEVEN
ISNUMBER
Check Excel help for details regarding additional IS functions.
T
TRYING
For someone like me who needs to interpret the TRUE or FALSE that the
suggested formulas would return, I would use something like this:
=IF(ISBLANK(A1),"Cell A1 is blank","Cell A1 is NOT blank"). Edit the last
two arguments to suit your purpose/preference.
suggested formulas would return, I would use something like this:
=IF(ISBLANK(A1),"Cell A1 is blank","Cell A1 is NOT blank"). Edit the last
two arguments to suit your purpose/preference.