MrExcel Publishing
Your One Stop for Excel Tips & Solutions

display zero if the calc is negative

Posted by dustymontana on January 23, 2002 8:25 AM

I want to display zero if my calculation results in a negative number.

Posted by Steve Hartman on January 23, 2002 8:35 AM


Posted by Aladin Akyurek on January 23, 2002 8:39 AM



Posted by Juan Pablo G. on January 23, 2002 9:07 AM

If it's only a "display" issue, i'd go with custom formatting the cell with something like


The second one "\0", tells Excel to put a "0" string when the result is negative.

Juan Pablo G.