If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
isnotblank function?
Is there a function that will tell me is a cell is not blank, or in
other words, does contain a value? |
#2
|
|||
|
|||
isnotblank function?
=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 |
#3
|
|||
|
|||
isnotblank function?
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? |
#4
|
|||
|
|||
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? |
#5
|
|||
|
|||
isnotblank function?
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 |
Thread Tools | |
Display Modes | |
|
|