Home » Forums » Open Source Learning Center » Question and Answer

Problem I've never had before.

Submitted by Sacohen on 26 August, 2014 - 19:29

When I reference another cell with =Y392 for example.

If there is no value in Y392 it fills the cell with 0.

I have other sheets that I've used this referencing in and that doesn't happen the cell remains blank.

Here's a snapshot.

Excell.png
‹ Help with Customised Excel vba - copy row with any colored cells to a new worksheet ›
»

Probably an easier way

Submitted by mec1981 on 29 August, 2014 - 06:58.

Hi,

There is possibly an easier way to do this but if you put in an if function then you can get rid of the zero value as follows:

=IF(Y392="","",Y392)

In Excel Quotation marks without any characters between them represent Blank, therefore with the above statement you are saying if Y392 is blank/empty then leave this cell blank, otherwise populate with the value in Y392.

Hope this helps

Mark

»