Thread: Blamk cells and 0 values
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike H Mike H is offline
external usenet poster
  
Posts: 11,501
Default Blamk cells and 0 values
Hi

=ISBLANK(A1)

Returns TRUE for a blank cell and FALSE for an empty string or zero

Mike

"gtm16" wrote:

Hi,

Can anyone tell me how to differentiate between blank cells and cells
with a 0 value?

regards
Gavin


Reply With QuoteReply With Quote