Excel Question - How to prevent Zeros displaying

  Evolution 13:49 28 Dec 2006
Locked

Hi,

I have an Excel Question (using Excel 2000)

I would like to suppress calculated Zero values from being displayed in a particular column.

However all positive and negative calculations should be displayed.

Can anyone help?

Many thanks,

Evo

  VoG II 13:51 28 Dec 2006

Can you give the formula that is being used in that column, please.

  Evolution 14:17 28 Dec 2006

Hi Vog,

Formula is simply B4-G4, B5-G5, B6-G6 etc

Thanks,

Evo

  VoG II 14:20 28 Dec 2006

In your column in Row 4 change the formula to

=IF(B4=G4,"",B4-G4)

then click in that cell, hover the cursor over the bottom right of the cell until the cursor turns into a + then double click to copy the amended formula down as far as needed.

  TonyV 14:51 28 Dec 2006

Not seen it written like that before, I have always used =IF(B4-G4=0,"",B4-G4). I've learnt a simpler way today!

TonyV

  Evolution 14:52 28 Dec 2006

Cheers Vog,

Been using 'if and else' statements all day on things far more complex but missed the obvious with this one.

Thought there might be an option to suppress but your suggestion works perfectly.

Many thanks again and Happy New Year!

Evo

  VoG II 15:38 28 Dec 2006

There is an option to suppress - Tools > Options > View tab, untick Zero values. But I thought that you wanted this to apply just to a particular column.

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Alienware 17 R4 2017 review

Illustrator Sylvain Tegroeg created thousands of intricate line drawings for the mobile game…

Best iPad buying guide 2017

Comment télécharger une application indisponible en France ?