Thread: #value! when cell is blank
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
JE McGimpsey JE McGimpsey is offline
external usenet poster
  
Posts: 4,624
Default #value! when cell is blank
Misread your requirement - use the second of my suggestions...

In article ,
JE McGimpsey wrote:

One way:

A3: =IF(COUNT(A1:A2)=2,A1+A2,"")
Reply With QuoteReply With Quote