Excel help please

[Mathilda]

Hi!

I've got an excel document which I've set up to transfer info from one tab to another.
So for example on tab two in in cell B16 it says

=TAB1!21

The question is, how do I stop it displaying a zero in B16 of the second tab if the cell where the info comes from happens to be empty?
(Some weeks it's empty, other weeks not.)

 

[Jamesds]

Well, this will work, but I have a feeling there's an easier way. It's quite simple though; a conditional, that checks whether the cell on the other tab is blank, and set the value of the mirror cell based on that info. However, I'm a little confused by your use of =TAB1!21 ... is that the name of the cell? It certainly isn't a proper reference.

This is the formula to mirror a value from cell A1 in TAB1 :

[b]=IF(ISBLANK(TAB1!A1),"",TAB1!A1)[/b]

 

[Mathilda]

Yes, my apologies, should have been
=TAB1!B21

Thanks, I'll try that.
Just didn't know the name of the conditional.

 

[Grisu]

you can also do it with formatting:

Select Format, Cells and click on the Number tab. then pick custom. now if you for example have 0.00;-0.00 as your formatting, just append a semicolon at the end, like this: 0.00;-0.00;
Excel should no longer display 0 values

alternatively you can make Excel not display any 0s with this:
Select Tools, Options -> View tab. Then deselect the 'Zero values' option

 

[Jamesds]

Ah, yes - the formatting described above is the better way to do it

 

[Mathilda]

alternatively you can make Excel not display any 0s with this:
Select Tools, Options -> View tab. Then deselect the 'Zero values' option

OMG, that's excellent for this purpose



I owe you one Kaeptn.

 

[Grisu]

I owe you one Kaeptn.

you're welcome. I'll not that in my little black book