What about entering this formula in A1:
=IF(ISBLANK(Sheet2!G5),"blah blah",Sheet2!G5)


Regards,
Stefi

€žNeil M€� ezt Ã*rta:

On sheet 1 of my spreadsheet I have a cell whose value is the result of a
formula on sheet 2.
I don't want people to enter text or numbers here but I want to direct them
to sheet 2.
Is there a way to make cell A1 on sheet 1 have text that says "Blah blah
blah" until a value is entered on cell G5 on sheet 2?

Neil M