9 Replies Latest reply: Dec 1, 2014 4:35 AM by Michele Barini RSS

    no zero-values in Formula

    Christian Wylezol

      Hello everybody,

       

      I have a topic unfortunately with very much additional work in Excel for me. Maybe some of you can help me.

      I have a table with values and then two additional red columns that calculate the difference between these two black columns

      (one with positive amount, one with negative, but the value is the same, always).

      Now I want to adapt that report.

      Only the lines <> 0 in the red columns should appear. I know how to show only lines with value <> 0

      But how can I only show lines with calculated result <> 0?

       

      hc_019.jpg