Feedback by UserVoice

lupo1

My feedback

  1. 120 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    An error occurred while saving the comment
    lupo1 commented  · 

    I worked around for 2 of them:

    IFNULL: =IFERROR(1/(1/A1),"")

    IFNULLORNEGATIVE: =IFERROR(EXP(LN(A1)),"")

    My source:
    http://www.office-hilfe.com/support/showthread.php/21725-Simulation-WENNNULL%28%29-und-WENNNULLODERNEGATIV%28%29

    The 2nd one is a nice replacement for an arrayable-MIN and -MAX, too (if using a comparison of only 2 arrays). If you want to MIN-MAX n arrays, you stay with the old solution ...SUBTOTAL(...;OFFSET())...

Feedback and Knowledge Base