Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Part 2 of Show zero values only when data is.....
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Part 2 of Show zero values only when data is.....
And Happy new year to you! :-)
"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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Part 2 of Show zero values only when data is.....
Hi,
Another way: =IF((C2-F2)+D2=0,"",(C2-F2)+D2) Or,to not show any zeros at all.........Tools/Options/View and uncheck "zero values" HTH Jean-Guy "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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Part 2 of Show zero values only when data is.....
Thanks but I have to have the zero values showing for rows with data in them.
I will try this as well though. "pinmaster" wrote: Hi, Another way: =IF((C2-F2)+D2=0,"",(C2-F2)+D2) Or,to not show any zeros at all.........Tools/Options/View and uncheck "zero values" HTH Jean-Guy "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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Part 2 of Show zero values only when data is.....
Excellent, this worked perfectly for me except that it didn't like the =
before sum so I removed it. Have a great 2007 "Sean Timmons" wrote: 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 |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Part 2 of Show zero values only when data is.....
Sorry about that... should have looked before I pasted. :-)
"gevew" wrote: Excellent, this worked perfectly for me except that it didn't like the = before sum so I removed it. Have a great 2007 "Sean Timmons" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
macro | Excel Discussion (Misc queries) | |||
Why would Show All not be active in Filter part of Data menu? | Excel Worksheet Functions | |||
Excel Macro to Copy & Paste | Excel Worksheet Functions | |||
From several workbooks onto one excel worksheet | Excel Discussion (Misc queries) | |||
Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions |