Thread: Blamk cells and 0 values
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Stefi Stefi is offline
external usenet poster
  
Posts: 2,646
Default Blamk cells and 0 values
=ISNUMBER(A1)
returns False for blank
True for 0

Regards,
Stefi

€˛gtm16€¯ ezt Ć*rta:

Hi,

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

regards
Gavin


Reply With QuoteReply With Quote