MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Another simple quetion for you expert

Posted by Mack on July 16, 2001 8:21 AM

but not for me


If no data in that range , I want it to display nothing and not 0. Any ideas ?

Thanks in advance

Posted by Aladin Akyurek on July 16, 2001 8:43 AM




Note that both formula incur a performance cost (they both compute the same thing twice). You can avoid this by formatting the cell of this formula as


This is a valuable tip by Mark W.