When I enter =Temparary!F2 , I get a zero when referancing a blank cell

B

Bruce

When I enter =Temparary!F2 , I get a zero when referancing a blank cell,
where I should get a null, why is this happening? I did this in another
worksheet and it worked fine. I tried several formating options, and it is
the same. I know I could use n IF(len(Temparary!F2) = 0,"",Temparary!F2),
but I should not need to. What am I missing?



Thanks

Bruce
 
N

Niek Otten

<I did this in another worksheet and it worked fine>

I think you're in error. It works the way you found now.

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Bruce" <oleexpres.at.johnsonclan.net> wrote in message | When I enter =Temparary!F2 , I get a zero when referancing a blank cell,
| where I should get a null, why is this happening? I did this in another
| worksheet and it worked fine. I tried several formating options, and it is
| the same. I know I could use n IF(len(Temparary!F2) = 0,"",Temparary!F2),
| but I should not need to. What am I missing?
|
|
|
| Thanks
|
| Bruce
|
|
|
 
T

T. Valko

That's just how it works. An empty cell evalautes as 0 and some functions do
not ignore empty cells. If as you say it worked before it had to have been
because the referenced cell may have contained a formula blank (""), a space
or some other non-visible type of character.

There is no "null" value. The closest you can come is an empty text string
("").

Biff
 
M

Mr BT

could you not use a conditional format changing any cell resulting with zero
to a white format?
 
D

Dave Peterson

But that could hide the 0's that are returned because the "sending" cell
contains 0.

To the OP, I just use:

=if(a1="","",a1)

(I don't check the length.)
 
Top