MAXIFS & MINIFS

Discussion in 'CP2' started by GemmaHayes, Aug 16, 2020.

  1. GemmaHayes

    GemmaHayes Member

    Hi there, does anyone know if it is ok to use new functions such as MAXIFS & MINIFS in our solutions? I understand these are only available in later versions of MS excel. Thanks for feedback.
     
    GemmaHayes, Aug 16, 2020
    #1
  2. Satk

    Satk Active Member

    I believe there is no issue as long as it is available in the higher version of excel against the minimum requirement. But I would suggest to use simple formulae as long as possible.
     
    Satk, Aug 18, 2020
    #2
  3. GemmaHayes

    GemmaHayes Member

    Thanks for the reply :)
     
    GemmaHayes, Aug 31, 2020
    #3
  4. ntickner

    ntickner Very Active Member

    Indeed - definitely no issue there. The most recent sitting included a calculation where AVERAGEIFS was the easiest way to do it, and a good number of candidates used that function.
     
    ntickner, Sep 10, 2020
    #4
  5. dkv1996

    dkv1996 Member

    I'm assuming an IFERROR function is fine?
     
    dkv1996, Sep 16, 2020
    #5
  6. Satk

    Satk Active Member

    Yes, it is fine. This is a standard function available in all almost all versions.
     
    Satk, Sep 17, 2020
    #6
    dkv1996 likes this.

Share This Page