Zero Values in Excel

  Dirk Diggler 19:15 20 Aug 2004
Locked

An appeal to any Excel wizzo's out there!

I have a simple sum ie, a1:a10 in a cell

If that value is zero, how can I get it to leave it blank?

  VoG II 19:18 20 Aug 2004

=IF(SUM(A1:A10)=0,"",SUM(A1:A10))

  clm2 19:24 20 Aug 2004

Or Tools>Options>View>Windows Options and clear 'Zero Values' box

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

Elsewhere on IDG sites

AMD Radeon Adrenalin release date, new features, compatible graphics cards

8 brilliant character artists speaking at Pictoplasma 2018

iMac Pro release date, UK price & specs

Football : comment regarder la Ligue 1 en direct ?