cell reference question
Hi,
You can use
=IF(A1="","",A1)
or if the only things in A1 are numbers or formulas that return numbers:
=IF(A1,A1,"")
--
If this helps, please click the Yes button
Cheers,
Shane Devenshire
"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".
|