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
try
=if(SUMIF(F:G,L29,G:G)=0,"",SUMIF(F:G,L29,G: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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Return cell blank ifsum=0 | Excel Discussion (Misc queries) | |||
I want to return the #VALUE! as a blank cell. | Excel Worksheet Functions | |||
If cell blank return a blank | Excel Worksheet Functions | |||
use IF to return a truly blank cell | Excel Discussion (Misc queries) | |||
return zero from a blank cell | Excel Worksheet Functions |