+ Reply to Thread
Results 1 to 2 of 2

Percentile If with Multiple Conditions

Hybrid View

  1. #1
    Registered User
    Join Date
    12-09-2019
    Location
    Boston, MA
    MS-Off Ver
    2016
    Posts
    1

    Percentile If with Multiple Conditions

    Hi - I am trying to write a conditional percentile formula with multiple conditions from data in a table. See attached mock-up sheet for the problem I'm having. When I write the formula using Percentile.EXC, I get a NUM error, and when I write it using Percentile or Percentile.INC, the formula returns 0.

    Note that when I use this exact methodology, but without the AND() and only with multiple condition, it works perfectly.

    Thanks so much!
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    09-25-2015
    Location
    Milan Italy
    MS-Off Ver
    office 365
    Posts
    1,988

    Re: Percentile If with Multiple Conditions

    G2=IFERROR(PERCENTILE.EXC(IF(Table1[[Include?]:[Include?]]=1, IF(Table1[[Product]:[Product]]=G$1, Table1[[Price]:[Price]])),0.25),"")

    copy across

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Percentile with multiple conditions from data in another sheet
    By ferguson9 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 09-27-2019, 12:23 PM
  2. How to Determine Values of Percentile and Percentile Rank
    By rbellotti in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-30-2019, 09:57 AM
  3. Percentile with multiple variable ranges
    By Michael Maor in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-23-2018, 01:18 AM
  4. Percentile function with multiple conditions
    By ranabananagirl in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-13-2015, 04:06 AM
  5. [SOLVED] Conditional percentile: Bug in percentíle function?
    By Duronka in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-13-2013, 08:08 AM
  6. Percentile calculation with 2 conditions
    By soakaos in forum Excel General
    Replies: 3
    Last Post: 05-06-2010, 11:19 AM
  7. Need Percentile VBA Coding with multiple criteria
    By vinothsudar in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-10-2009, 04:45 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1