Excel : empty cell instead of 0
Solved
chouag
-
rick -
rick -
Hello,
I want to copy data from an existing cell. For example, if I want to copy cell B2 into cell D2, I go to cell D2 and type “=B2”. So far, so good. However, if B2 is empty, I get 0 in cell D2... I would like my cell D2 to remain empty as well, but with the formula that triggers as soon as data appears in B2.
I hope you understand what I mean!!
Thanks in advance
I want to copy data from an existing cell. For example, if I want to copy cell B2 into cell D2, I go to cell D2 and type “=B2”. So far, so good. However, if B2 is empty, I get 0 in cell D2... I would like my cell D2 to remain empty as well, but with the formula that triggers as soon as data appears in B2.
I hope you understand what I mean!!
Thanks in advance
Configuration: Windows XP Safari 525.28.1
3 answers
-
Hi,
It's normal if your formula finds nothing in B2, it translates to 0
Two possibilities: either you go to Tools/Options in the Display tab and uncheck Zero values
Or you write your formula with a conditional, if B2 is not empty, then display its content, otherwise display nothing
=IF(B2<>"",B2,"")
See you+
