Thread: Test if there is data in a cell or not?
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
  
Posts: 35,218
Default Test if there is data in a cell or not?
Maybe...

=if(a1="","it looks empty","something's there")

But if A1 contained a formula like:
=if(b2=7,"0k,"")
and evaluated to "", then it would look empty.



J@Y wrote:

What function can be used to test if there is data in a cell or not?

--

Dave Peterson
Reply With QuoteReply With Quote