How to have a cell return blank when the target cell it is copying is blank

Basically, I have a formula that copies details from one workbook to the other based on if 'yes' or 'no' is selected in one of the previous boxes. It is doing what I need it to, but I am struggling on the dates column. If there is a date in the cell then it willc opy it over just fine, but if the cell is blank it will enter 01/01/1900.. here is the formula:

=IF('[TSC LOG (DW).xlsm]2013-2014'!C126="Yes",'[TSC LOG (DW).xlsm]2013-2014'!I126,"")

What can I do with that to make it so that a blank in the cell that it is copying from, is actually copied as a blank?

Take a look at this thread from earlier:

http://www.excelforum.com/excel-form...te-values.html

Hope this helps.

Pete

Doesn't work, it returns the same result. Surely it would be an AND statement? I just don't know how to work it

Ahh, brilliant, the formatting with the two semi colons has solved the issue. Thanks!

Originally Posted by Miraun

Ohh ohh... I misunderstood your question.

Rather than just having the cell appear blank, you'd rather that there's no equation in there at all?

Unfortunately, that's not going to be able to be accomplished short of a macro. There's really no way for both an equation and a null to exist in a single cell at any given time... You can either return null as the result of an equation, or not have an equation.

Alternatively, if you're trying to use the data elsewhere, or want to 'scrub' it, sort to speak, you can always highlight the column, copy, Paste Special (alt, e, s), and paste just Values, which will remove the equation and just return the results.

What I meant is that I wanted it to leave the cell visibly empty rather than have the date come up as 00/01/1900, thanks for the help though