Test display until value

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
What about entering this formula in A1:
=IF(ISBLANK(Sheet2!G5),"blah blah",Sheet2!G5)


Regards,
Stefi

„Neil M†ezt írta:
 
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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SUMPRODUCT formula I think w/ wild card & number vs number as text 8
Scrabble Value calculation for Welsh words 0
Update cell value based on name and specific date 1
Vlookup and return sheet name also 2
Worksheet linking 2
Formatting Text 2
using the =page! feature to transpose a row to column 0
Not sure what the subject is 2

Back
Top