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
|