Is there such a formula that will leave a cell empty? Example: I use
the formula SUM(...) to add up orders...but, if there are no orders in
that category, then the cell will have the value of "0.0". Is there
any way to leave the cell blank (with the formula still in there) when
there are no orders? I really need help on this, it's driving me
mad!!! Any help would be sweet.

Thanks! -Sarah



--
sarahmross
------------------------------------------------------------------------
sarahmross's Profile: http://www.excelforum.com/member.php...o&userid=28725
View this thread: http://www.excelforum.com/showthread...hreadid=484179