Results 1 to 5 of 5

Quartile with IF function

Threaded View

  1. #1
    Registered User
    Join Date
    10-19-2017
    Location
    Holland
    MS-Off Ver
    2013
    Posts
    8

    Quartile with IF function

    So I wanna use the quartile function in combination with the IF function.

    I have football data and I wanna use the cells of a particular team.
    So I created this formula:
    =QUARTILE(IF(E$8:E$1618=D$1621,N$8:N$1618),1)
    D$1621 is the cell with name of the team I choose. E$8:E:1618 is the column with the teamnames. N8:N1618 is the data I want the first quartile of.

    But I keep getting #value error.

    I added the workbook.
    Attached Files Attached Files
    Last edited by nodejo; 10-25-2017 at 09:08 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Conditional Quartile.INC function
    By nzgin in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-08-2016, 04:40 AM
  2. Replies: 1
    Last Post: 08-05-2013, 01:52 PM
  3. Correlation for 1st quartile, 2nd quartile, 3rd quartile, 4th quartile
    By DexterG in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 02-11-2013, 07:17 AM
  4. Excel 2007 : Quartile If
    By cloud36 in forum Excel General
    Replies: 3
    Last Post: 07-13-2012, 05:37 PM
  5. Replies: 3
    Last Post: 06-01-2012, 02:06 PM
  6. [SOLVED] Quartile / Quintile Function
    By Greg in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-20-2005, 11:06 PM
  7. Quartile Function
    By tika528 in forum Excel General
    Replies: 5
    Last Post: 03-16-2005, 09:25 AM

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