IF0
 

I'm trying to have a cell left blank unless the SUM of the formula in that
cell 0

IF0
 

Just check the SUM first...

=IF(SUM(CellsToBeSummed)0,SUM(CellsToBeSummed),"" )

--
Rick (MVP - Excel)


"topdog5564" wrote in message
...
I'm trying to have a cell left blank unless the SUM of the formula in that
cell 0

IF0
 

hi
not too sure, you're a tad short on info but..
are you trying to do this with code or a formula?
if formula
=if(A1+B10, A1+B1,"")
if code then post back with your code AND more details.

Regards
FSt1

"topdog5564" wrote:

I'm trying to have a cell left blank unless the SUM of the formula in that
cell 0

IF0
 

If you want cells to be blank when a formula = 0 you can change a setting in
Excel 2007, just select Excel OptionsAdvanced and uncheck the "Show a Zero
in Cells That Have Zero Value" checkbox. If you have Excel 2003 I think its
under EditOptions or ToolsOptions, I can't remember.

If you just want that particular cell to be blank when its summed to 0 then
use Rick's or FSt1's formula.

Hope this helps! If so, click "YES" below.
--
Cheers,
Ryan


"topdog5564" wrote:

I'm trying to have a cell left blank unless the SUM of the formula in that
cell 0