Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Return cell blank ifsum=0
I am using this formula
=SUMIF(F:G,L29,G:G) normal answer is for instance 33456 sometime the answer is 0 When the answer is 0 I want the cell to show nothing at all Is this possible ??? Regards Mark |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Return cell blank ifsum=0
I'd use:
=if(sumif(...)=0,"",sumif(...)) Did you really mean to use F:G??? Mark Allen wrote: I am using this formula =SUMIF(F:G,L29,G:G) normal answer is for instance 33456 sometime the answer is 0 When the answer is 0 I want the cell to show nothing at all Is this possible ??? Regards Mark -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Return cell blank ifsum=0
=IF(SUMIF(F:G,L29,G:G)=0,"",SUMIF(F:G,L29,G:G))
-- David Biddulph "Mark Allen" wrote in message ... I am using this formula =SUMIF(F:G,L29,G:G) normal answer is for instance 33456 sometime the answer is 0 When the answer is 0 I want the cell to show nothing at all Is this possible ??? Regards Mark |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Return cell blank ifsum=0
The formula works but unfortunatley the blank response is showing as blank
but I am then using dynamic charting and it still shows as 0...I need the cell to show nothing so it see's the cell as completly blank !!!!! Help please. "David Biddulph" wrote: =IF(SUMIF(F:G,L29,G:G)=0,"",SUMIF(F:G,L29,G:G)) -- David Biddulph "Mark Allen" wrote in message ... I am using this formula =SUMIF(F:G,L29,G:G) normal answer is for instance 33456 sometime the answer is 0 When the answer is 0 I want the cell to show nothing at all Is this possible ??? Regards Mark |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Return cell blank ifsum=0
Use NA()
as an example instead of =IF(A1=0,"",A1) use =IF(A1=0,NA(),A1) The formula will show as #N/A but the chart will show as null and if you don't like the look of the #N/A you can hide it with conditional formatting using white fonts -- Regards, Peo Sjoblom "Mark Allen" wrote in message ... The formula works but unfortunatley the blank response is showing as blank but I am then using dynamic charting and it still shows as 0...I need the cell to show nothing so it see's the cell as completly blank !!!!! Help please. "David Biddulph" wrote: =IF(SUMIF(F:G,L29,G:G)=0,"",SUMIF(F:G,L29,G:G)) -- David Biddulph "Mark Allen" wrote in message ... I am using this formula =SUMIF(F:G,L29,G:G) normal answer is for instance 33456 sometime the answer is 0 When the answer is 0 I want the cell to show nothing at all Is this possible ??? Regards Mark |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Return cell blank ifsum=0
The NA bit worked but the chart is still seeing something there...
How do I do the condition formatting ?? Regards Mark "Peo Sjoblom" wrote: Use NA() as an example instead of =IF(A1=0,"",A1) use =IF(A1=0,NA(),A1) The formula will show as #N/A but the chart will show as null and if you don't like the look of the #N/A you can hide it with conditional formatting using white fonts -- Regards, Peo Sjoblom "Mark Allen" wrote in message ... The formula works but unfortunatley the blank response is showing as blank but I am then using dynamic charting and it still shows as 0...I need the cell to show nothing so it see's the cell as completly blank !!!!! Help please. "David Biddulph" wrote: =IF(SUMIF(F:G,L29,G:G)=0,"",SUMIF(F:G,L29,G:G)) -- David Biddulph "Mark Allen" wrote in message ... I am using this formula =SUMIF(F:G,L29,G:G) normal answer is for instance 33456 sometime the answer is 0 When the answer is 0 I want the cell to show nothing at all Is this possible ??? Regards Mark |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I want to return the #VALUE! as a blank cell. | Excel Worksheet Functions | |||
If cell blank return a blank | Excel Worksheet Functions | |||
Return a value to a cell that is blank | Excel Discussion (Misc queries) | |||
return a blank cell | Excel Worksheet Functions | |||
use IF to return a truly blank cell | Excel Discussion (Misc queries) |