 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Worksheet Functions / December 2005Test 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 Neil Try =IF(ISBLANK(Sheet2!G5),"Blah Blah Blah",Sheet2!G5) HTH Sally > On sheet 1 of my spreadsheet I have a cell whose value is the result of a > formula on sheet 2. [quoted text clipped - 4 lines] > > Neil M 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. [quoted text clipped - 4 lines] > > Neil M 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 > On sheet 1 of my spreadsheet I have a cell whose value is the result of a > formula on sheet 2. [quoted text clipped - 4 lines] > > Neil M Enter on Sheet1!A1 =if(sheet2!G5=0,"Blah Blah Blah",Sheet2!G5) > On sheet 1 of my spreadsheet I have a cell whose value is the result of a > formula on sheet 2. [quoted text clipped - 5 lines] > > Neil M 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 Neil try =IF(ISBLANK(Sheet2!G5),"Blah Blah Blah",Sheet2!G5) HTH Sally > On sheet 1 of my spreadsheet I have a cell whose value is the result of a > formula on sheet 2. [quoted text clipped - 4 lines] > > Neil M |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.