1. Forum
  2. Usenet
  3. MICROSOFT.PUBLIC.EXCEL.MI

  • Blank if zero

    From Weston Cook@21:1/5 to All on Thu Oct 1 13:21:58 2020
    Hi,
    I'm wondering if there is a function similar to "iferror" that will leave a cell blank if the result of its formula equals zero. I normally do something like:

    if(A1-A2>0, A1-A2, "")

    This gets tedious and difficult to follow with long and/or nested formulas, so I'm looking for a shortcut. Does such a thing exist?

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Claus Busch@21:1/5 to All on Fri Oct 2 00:01:05 2020
    Hi Weston,

    Am Thu, 1 Oct 2020 13:21:58 -0700 (PDT) schrieb Weston Cook:

    Hi,
    I'm wondering if there is a function similar to "iferror" that will leave a cell blank if the result of its formula equals zero. I normally do something like:

    if(A1-A2>0, A1-A2, "")

    This gets tedious and difficult to follow with long and/or nested formulas, so I'm looking for a shortcut. Does such a thing exist?

    Options => Advanced => Display options for this worksheet and
    deactivate "Show a zero in cells that have zero value"


    Regards
    Claus B.
    --
    Windows10
    Office 2016

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)