Feedback by UserVoice


My feedback

  1. 120 votes
    Sign in
    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),"")


    My source:

    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