i want a cel is to follow another cel's content but it shows a zero(0) if the first cel is empty!?

T

tucker

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

Gord Dibben

You forgot to designate an alternative to 0.
Try this. . . . .

=IF(A1="Hello";A1;"")

Gord
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

A macro to copy content/sub-contents of outlines and groups in excel 4
Empty content after a calculation 4
refer to the cell as it is empty... 2
Help: How do I fill a column with values if it is blank? 5
Addiing a Zero to a number which is already there 1
Formula returns empty; chart plots zero; I want to skip 6
Need to fill a column if the column next to it is not blank 1
How do I cahnge this code to give a drill through on the same sheet but just next to the current cel 0

Top