M Matt Jan 4, 2008 #1 Is there a function that will tell me is a cell is not blank, or in other words, does contain a value?
Is there a function that will tell me is a cell is not blank, or in other words, does contain a value?
D Dave Peterson Jan 4, 2008 #2 =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? Click to expand...
=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? Click to expand...
K Kevin B Jan 4, 2008 #4 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.
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.
T TRYING Jan 4, 2008 #5 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.
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.
