Excel 2007 : Quartile If

**cloud36** · 07-12-2012, 11:52 PM

How do I write an IF equation in an array of another function

For example the function..

=QUARTILE(array,quart)

I want = QUARTILE(IF(something),quartile 1)

I don't want the IF True, IF FALSE parts of the IF function.

Thanks.

**MarvinP** · 07-13-2012, 12:07 AM

Hi cloud36,

Quartile returns a single number. The second argument can be only 0,1,2,3,4. The first argument needs to be an array or range of cells that are numbers.
Read http://office.microsoft.com/en-us/ex...005209226.aspx for the specifics.

I have no idea what you are asking. How about an example and maybe we can figure out what you desire.

**cloud36** · 07-13-2012, 05:35 PM

Say I have a table with two columns: Place and Time. Imagine the list contains the time it took a certain place to complete the mile...1st place, 2nd place. The table contains the same place more than one. So, it may have 500 entries of times it took a 1st place runner to complete a race. I'm trying to find the 1st quartile when place equals 1. So, in my QUARTILE formula I need to write in IF equation so it only computes quartile 1 when the Place Column equals 1. Does that make sense.

Table 1
Place Time
1 30
2 45
1 33
2 47
2 60
3 55
4 65
5 75
. .
. .