View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Sean Timmons Sean Timmons is offline
external usenet poster
 
Posts: 1,696
Default Part 2 of Show zero values only when data is.....

if(counta(B2:IV2)=0,"",=SUM(C2-F2)+D2)

"gevew" wrote:

As in my previous question I require that zero values only show when data is
entered in adjoining fields. What I failed to mention is that the field that
I want the zero values to show up in is a calculation (=SUM(C2-F2)+D2). How
do I combine your suggestion with my calculation?

Please let me know if you come up with a solution for my print problem as
well.

Thanks
Happy New Year