How do I make a cell display a blank instead of a "0" or a "-" when the sum of a formula is zero?
C charlymon Feb 5, 2004 #1 How do I make a cell display a blank instead of a "0" or a "-" when the sum of a formula is zero?
R Rockee052 Feb 5, 2004 #2 Hi, Try going to [Tools] --> Options Under the tab "View" Look at the Window option and uncheck Zero Values Rockee Freema
Hi, Try going to [Tools] --> Options Under the tab "View" Look at the Window option and uncheck Zero Values Rockee Freema
N Norman Harker Feb 5, 2004 #3 Hi Charlymon! Example: =IF(SUM(A1:Z1)=0,"",SUM(A1:Z1)) -- Regards Norman Harker MVP (Excel) Sydney, Australia [email protected] Excel and Word Function Lists (Classifications, Syntax and Arguments) available free to good homes.
Hi Charlymon! Example: =IF(SUM(A1:Z1)=0,"",SUM(A1:Z1)) -- Regards Norman Harker MVP (Excel) Sydney, Australia [email protected] Excel and Word Function Lists (Classifications, Syntax and Arguments) available free to good homes.
A Arvi Laanemets Feb 5, 2004 #4 Hi =IF(MyFormula="","",MyFormula) (Put your sum formula instead MyFormula into it)
