I am using the following formula to import data from one spreadsheet to another:
=IMPORTRANGE("URL", "Sheet1!N231")
In some cases the imported range is blank. I would like for these cells to say "TBC" on my new spreadsheet, instead of remaining blank.
I have tried to work in the ISBLANK command but am struggling with the syntax.
Aucun commentaire:
Enregistrer un commentaire