| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Test display until value
Yep, That was it!! Thanks Everyone! Neil M |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Look Up and Display set data | Excel Discussion (Misc queries) | |||
| Display the max, then the next down, then the next down, etc. | Excel Discussion (Misc queries) | |||
| How do you display Greek and Russian languages in excel? | Excel Discussion (Misc queries) | |||
| Global Replacement of Test to Display | Excel Worksheet Functions | |||
| Combine & Display “Fixed” & “Automatically Updated” Date Parts | Excel Worksheet Functions | |||
Hybrid Mode
