| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
result should equal a blank field
I am linking data from a cell on another page in my workbook. Sheet3 cell B5
is presently blank awaiting input. Sheet1 cell A5 I use formula =Sheet3!B5 which produces a result of 0 instead of being left blank until input is entered into the cell on Sheet3 cell B5. Why is this and how do I make my result blank until data is entered on the other page? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
result should equal a blank field
Try
=IF(Sheet3!B5<"",Sheet3!B5,"") Mike "John M." wrote: I am linking data from a cell on another page in my workbook. Sheet3 cell B5 is presently blank awaiting input. Sheet1 cell A5 I use formula =Sheet3!B5 which produces a result of 0 instead of being left blank until input is entered into the cell on Sheet3 cell B5. Why is this and how do I make my result blank until data is entered on the other page? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
result should equal a blank field
try this
=IF(Sheet3!B5,Sheet3!B5,"") HTH -- If this posting was helpful, please click on the Yes button Thank You cheers, "John M." wrote: I am linking data from a cell on another page in my workbook. Sheet3 cell B5 is presently blank awaiting input. Sheet1 cell A5 I use formula =Sheet3!B5 which produces a result of 0 instead of being left blank until input is entered into the cell on Sheet3 cell B5. Why is this and how do I make my result blank until data is entered on the other page? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| When 1 sheet = a blank date field on another tab the result = 0-Ja | Excel Worksheet Functions | |||
| Linked date field in worksheet defaults a blank field as 1/0/1900 | Excel Worksheet Functions | |||
| If the result of a formula is negative make equal to zero | New Users to Excel | |||
| Making one field equal 2 others | Excel Worksheet Functions | |||
| how to have result field blank | Excel Discussion (Misc queries) | |||
![John M.[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
