isnotblank function?
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?
|