View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Charlie Charlie is offline
external usenet poster
 
Posts: 703
Default Simple cell reference not blank

Judging by the volume of responses I guess the answer is "No." :(

=IF(Responses="","",Responses&"It is")

"Charlie" wrote:

Whenever I do a simple cell reference, e.g.

=A1

if A1 is blank the resultant cell shows a zero. I'm getting tired of

=IF(A1="","",A1)

Without changing the cell format is there a setting or different formula
syntax to make the resultant cell equal the source cell literally?

TIA
Charlie