MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Display "0" instead of Formula

Posted by Rob on August 07, 2001 3:34 PM

Can someone please help-- I have formula's that add but if the total is "0" or there is no numbers to enter te Totaldisplays the formula i he cell. Can that be modified to show "0" if there is no value?
Thank you

Posted by Aladin Akyurek on August 07, 2001 3:38 PM


I can't follow your question (a bit garbled). Care to elaborate if it's not a VBA question?