| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Reference shows zero
Thanks, that's solved it!
/Tommy "Gord Dibben" wrote: Could be a settings issue. There is an option to disply or not display zero values. Might be the other Excel workbook has display zero values unchecked. In 2003........Tools<OptionsViewWindow Options. In 2007........ButtonExcel OptionsAdvancedDisplay options for this worksheet. Gord Dibben MS Excel MVP On Wed, 3 Feb 2010 12:07:01 -0800, TommyD wrote: Thanks for your answer€¦ but the strange thing is that I have an other excel spreadsheet where this phenomena doesnt occur so I thought it could have something to do with settings? /Tommy "Fred Smith" wrote: "Why isn't B1 empty if A1 is?" is the same as "Why does the sun rise in the east?" That's just the way it is. Modify your formula to: =if(a1="","",a1) Regards, Fred "TommyD" wrote in message ... Hi, I have a cell reference in cell B1 (=A1). If A1 is empty B1 shows "0". Why isn't B1 empty if A1 is? Both cells have format General. /Tommy . . |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cell Reference Shows "0" | Excel Discussion (Misc queries) | |||
| Cells shows #NA | Excel Discussion (Misc queries) | |||
| format a cell with a formula so an empty reference cell shows blan | Excel Discussion (Misc queries) | |||
| Cell only shows link in text, not contents of reference cell | New Users to Excel | |||
| cell shows 20. Formula shows 20. why not 540/27 | Excel Worksheet Functions | |||
![TommyD[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
