Formula to leave a cell blank

[dandavis1]

Probably a simple method that i have not tried. I have a table where some cells are populated with #N/A.

I am trying to work out a formula in another cell saying if the cell that contains #N/A then leave this cell blank.

Hope you can help,

Thanks very much!!!

[DonkeyOte]

Not much to go on but:

B1: =IF(ISNA(A1),"",A1)

[dandavis1]

Sorry, perhaps this might explain in better detail. See Attached Dcoument.

On Sheet 1 most cells contain #N/A, they are linked with the table on sheet 2. How can i write a formula for the cells on sheet one so that the cell will be blank instead of showing #N/A?

THanks again!!!!

[DonkeyOte]

see post # 2 (change references to suit)

[dandavis1]

Thanks for both your help, that has worked perfectly!!!