View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
F. Lawrence Kulchar F. Lawrence Kulchar is offline
external usenet poster
 
Posts: 124
Default FORMULA DOES NOT WORK

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