View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tim Williams Tim Williams is offline
external usenet poster
 
Posts: 1,588
Default FORMULA DOES NOT WORK

Maybe it's not blank?

Tim


"F. Lawrence Kulchar" wrote in
message ...
I have the following formula typed into my cell:

=If(a1="","",a2)

I mean: If the contents of a1 is blank, insert a blank; otherwise, insert
the contents of cell a2.

IT DOES NOT WORK!!!!

Maybe, the format of a1 is in error; but, anyway, a blank a1 does NOT
yield
a blank in my cell, and vice-versa.

WHAT AM I DOING WRONG??

How is this fixed?

Thank you,

FLKulchar