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

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

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