Enter on Sheet1!A1 =if(sheet2!G5=0,"Blah Blah Blah",Sheet2!G5)


"Neil M" wrote in message
...
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