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
|