Excel 2007 : Make cell blank if there is no data in the cell that it is referring too.

[srgtennis]

I am using this formula and it works great but if there is no info in that cell then it gives me a 0 or if it is in the date column it gives me a 1/0/00.
can I use the if(isblank function or what would be the best way to make that cell blank unless there is data in that cell.

='[02-28-2012 Raw Apples.xlsx]Processing'!B6343

[Fotis1991]

Hi

Try something like this.

=if('[02-28-2012 Raw Apples.xlsx]Processing'!B6343="";""; [02-28-2012 Raw Apples.xlsx]Processing'!B6343)

[srgtennis]

That gives me an error, something is wrong with that formula

[Fotis1991]

Try to change the semi-colons, with gomma

=if('[02-28-2012 Raw Apples.xlsx]Processing'!B6343="","", [02-28-2012 Raw Apples.xlsx]Processing'!B6343)

I don't have your workbook, to see..what's wrong....

The point is: If(that cell)="","",that cell)

[srgtennis]

I figured it out. Thanks

=IF(ISBLANK('[02-28-2012 Raw Apples.xlsx]Processing'!B6345),"",'[02-28-2012 Raw Apples.xlsx]Processing'!B6345)

[Fotis1991]

You are welcome.

Pls mark your thread, as SOLVED.