IF>0

T

topdog5564

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

Rick Rothstein

Just check the SUM first...

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

FSt1

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+B1>0, A1+B1,"")
if code then post back with your code AND more details.

Regards
FSt1
 
R

Ryan H

If you want cells to be blank when a formula = 0 you can change a setting in
Excel 2007, just select Excel Options>Advanced and uncheck the "Show a Zero
in Cells That Have Zero Value" checkbox. If you have Excel 2003 I think its
under Edit>Options or Tools>Options, 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.
 
Top