cell reference question

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".
 
S

Shane Devenshire

Hi,

You can use

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

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

=IF(A1,A1,"")
 
Top