Thread: How do I omit a blank cell from a calculation??
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
T. Valko T. Valko is offline
external usenet poster
  
Posts: 15,768
Default How do I omit a blank cell from a calculation??
It depends on what you want to accomplish with the formula.

One way to test for numeric 0:

AND(COUNT(A1),A1=0)


--
Biff
Microsoft Excel MVP


"marklg" wrote in message
...
How do I discriminate between a blank cell and a zero value cell in a
formula?


Reply With QuoteReply With Quote