View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Sheeloo[_3_] Sheeloo[_3_] is offline
external usenet poster
 
Posts: 1,805
Default If blank do nothing

=IF(A2="","",A3)

to represent blank use two " with nothing in between...

"student-ttu" wrote:

I need to create an If statement so that it reads ... if cell A2 is blank ,
then do nothing, (if not) print the info of cell A3) I don't know how to
reference a cell as blank (or containing no data) nor do I know how to tell
it to do nothing. I'm willing to accept If (cell A2 is blank, " ", A3) but I
will be mail merging from this data and an extra space may look strange, so
I'd rather not have it add an extra space, thank you.