View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Kevin B Kevin B is offline
external usenet poster
 
Posts: 1,316
Default 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?