| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
i want a cel is to follow another cel's content but it shows a zero(0) if the first cel is empty!?
Hello,
As a beginner I bumped into the following (probably easy to solve) problem. For example I want cel B7 follow the content of cel A1 only if cel A1 contains a particular word. For this, in cel B7 I entered =IF(A1="Hello";A1;) If A1 contains Hello, B7 shows Hello as it should but if A1 contains something different B7 shows 0 (a zero) which is unwanted as I want it to be empty. Why this zero? Help is appreciated. --------------= Posted using GrabIt =---------------- ------= Binary Usenet downloading made easy =--------- -= Get GrabIt for free from http://www.shemes.com/ =- |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
i want a cel is to follow another cel's content but it shows a zero (0) if the first cel is empty!?
Try...
=IF($A$1="Hello",A1,"") -- Garry Free usenet access at http://www.eternal-september.org Classic VB Users Regroup! comp.lang.basic.visual.misc microsoft.public.vb.general.discussion |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
i want a cel is to follow another cel's content but it shows a zero (0) if the first cel is empty!?
You forgot to designate an alternative to 0.
Try this. . . . . =IF(A1="Hello";A1;"") Gord On Tue, 30 Jul 2013 17:16:30 +0200, "tucker" wrote: Hello, As a beginner I bumped into the following (probably easy to solve) problem. For example I want cel B7 follow the content of cel A1 only if cel A1 contains a particular word. For this, in cel B7 I entered =IF(A1="Hello";A1;) If A1 contains Hello, B7 shows Hello as it should but if A1 contains something different B7 shows 0 (a zero) which is unwanted as I want it to be empty. Why this zero? Help is appreciated. --------------= Posted using GrabIt =---------------- ------= Binary Usenet downloading made easy =--------- -= Get GrabIt for free from http://www.shemes.com/ =- |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
i want a cel is to follow another cel's content but it shows a zero (0) if the first cel is empty!?
BTW
A cell containing a formula can never be "empty". Gord On Tue, 30 Jul 2013 09:26:57 -0700, Gord Dibben wrote: You forgot to designate an alternative to 0. Try this. . . . . =IF(A1="Hello";A1;"") Gord On Tue, 30 Jul 2013 17:16:30 +0200, "tucker" wrote: Hello, As a beginner I bumped into the following (probably easy to solve) problem. For example I want cel B7 follow the content of cel A1 only if cel A1 contains a particular word. For this, in cel B7 I entered =IF(A1="Hello";A1;) If A1 contains Hello, B7 shows Hello as it should but if A1 contains something different B7 shows 0 (a zero) which is unwanted as I want it to be empty. Why this zero? Help is appreciated. --------------= Posted using GrabIt =---------------- ------= Binary Usenet downloading made easy =--------- -= Get GrabIt for free from http://www.shemes.com/ =- |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Link shows formula instead of content of cell | Links and Linking in Excel | |||
| ComboBox still shows data when linked cell is empty | Excel Programming | |||
| Link malfunction-shows path instead of cell content | Excel Worksheet Functions | |||
| Paste Link shows '0' for empty cells | Excel Discussion (Misc queries) | |||
| How can I make the bar that shows the content of the cell visible. | Excel Discussion (Misc queries) | |||
Linear Mode
