Thread: #value! when cell is blank
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ryan H. Ryan H. is offline
external usenet poster
  
Posts: 15
Default #value! when cell is blank
Hi,

Cell A1 contains the number 5
Cell A2 contains ""
Cell A3 contains =A1+A2

A3 returns #VALUE!

How can I make it return 5?

Thanks


Reply With QuoteReply With Quote