Test display until value
 

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

Test display until value
 

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

Test display until value
 

Neil
Try =IF(ISBLANK(Sheet2!G5),"Blah Blah Blah",Sheet2!G5)

HTH
Sally

"Neil M" wrote:

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

Test display until value
 

Try this:

On Sheet1
A1: =IF(ISBLANK(Sheet2!G5),"You must enter a value in cell G5 on
Sheet2.",Sheet2!G5)

Is that what you're looking to do?

***********
Regards,
Ron


"Neil M" wrote:

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

Test display until value
 

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

Test display until value
 

Neil
try =IF(ISBLANK(Sheet2!G5),"Blah Blah Blah",Sheet2!G5)
HTH
Sally

"Neil M" wrote:

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

Test display until value
 

I think this might work since I have G5 as the sum of several totals on
sheet 2 and there is a "0" there now. I will try and update.

Thanks,

Neil M

Test display until value
 

Yep, That was it!! Thanks Everyone!


Neil M