View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Sean Timmons Sean Timmons is offline
external usenet poster
 
Posts: 1,696
Default IF cell is blank

=IF(Sheet1!A1="","",A1)

"John Galt" wrote:

I'm having a brain seizure and can't remember. If a cell on sheet #1 has
someone's name typed in it, I want to display it on sheet#2, if it's blank I
want to display nothing...it's an IF statement with a TRUE / FALSE thing,
yes???

I can't seem to make it work.