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