If statement help needed - blank cells

[Bob Dobelina]

I'd like to make an IF statment that says: "if such-and-such a cell is blank, make the destination cell blank also, otherwise replicate the contents of the cell into the destination cell".

The best I've come up with so far is this rather lame attempt:

=IF('Previous_Sheet'!A1=" "," ", 'Previous_Sheet'!A1)

For cells with no data at all (i.e. never been filled or have had their contents cleared) the result is "0" whereas I just wanted a blank cell. I suspect there is a more complete and more elegant solution than this! If anyone has any ideas please let me know.

Cheers,

Bob

 

[Andrew Poulsom]

You are testing for a space not "". Try:

=IF('Previous_Sheet'!A1="","", 'Previous_Sheet'!A1)

 

[Bob Dobelina]

Thanks Andrew... your solution is actually fairly obvious when you think about it! No points for me for being a genius.

Bob