Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
IF0
I'm trying to have a cell left blank unless the SUM of the formula in that
cell 0 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|