Excel Question

[el-Capitan]

Gents.

In Excel 2013, if i use "=" to point to another cell, it will take that target cell's value. However, if that target cell is empty, he'll take a "0", which in itself is a value as opposed to "empty".

How can I avoid this? I need the cell to be empty if there is no value in the target, otherwise this zero is an input to a formula.

The workaround, having the formula ignore a "0", is not an option as "0" is very well a likely input...

Hope I've made myself understandable -

Thanks.

 

[MerlinRML]

If I understand the question correctly, maybe something like this would work.

=IF(NOT(ISBLANK(A1)),A1,"")

If the source cell is not empty, use it's value. Otherwise, make the target cell empty.

 

[el-Capitan]

If I understand the question correctly, maybe something like this would work.

=IF(NOT(ISBLANK(A1)),A1,"")

If the source cell is not empty, use it's value. Otherwise, make the target cell empty.

Yes! That works. Bravo! Thank you very much.