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/ =-

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

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/ =-

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/ =-