cell reference question

  • Thread starter Thread starter bfont
  • Start date Start date
B

bfont

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".
 
Hi,

You can use

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

or if the only things in A1 are numbers or formulas that return numbers:

=IF(A1,A1,"")
 
Back
Top