Thread: cell reference question
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike H Mike H is offline
external usenet poster
  
Posts: 11,501
Default cell reference question
try

=IF(A1<"",A1,"")

Mike

"bfont" wrote:

how do i write a function that basically says "if there's anything in cell
xx, return the data from that cell. if there is nothing in cell xx, leave the
cell blank".
Reply With QuoteReply With Quote