Excel Question - How to prevent Zeros displaying

  Evolution 13:49 28 Dec 06
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 06

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

  Evolution 14:17 28 Dec 06

Hi Vog,

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

Thanks,

Evo

  VoG II 14:20 28 Dec 06

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 06

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 06

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 06

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.

Sniper Elite 4 review: Headshotting Nazis has never felt so good

1995-2015: How technology has changed the world in 20 years

The Best Design, Illustration, Animation and VFX Awards of 2017

WWDC 2017 dates: How to get WWDC 2017 tickets, when is WWDC 2017 and more details announced