Is there a function that will tell me is a cell is not blank, or in
other words, does contain a value?

=NOT(ISBLANK(A1))

Matt wrote:

Is there a function that will tell me is a cell is not blank, or in
other words, does contain a value?

--

Dave Peterson

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.



"Dave Peterson" wrote:

=NOT(ISBLANK(A1))

Matt wrote:

Is there a function that will tell me is a cell is not blank, or in
other words, does contain a value?

--

Dave Peterson

Maybe:

=NOT(ISBLANK(B3))


"Matt" wrote:

Is there a function that will tell me is a cell is not blank, or in
other words, does contain a value?

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.


--
Kevin Backmann


"Matt" wrote:

Is there a function that will tell me is a cell is not blank, or in
other words, does contain a value?