Dividing a range into 4 equal parts

[HuckFinn]

I have a range of salary where I have a minimum ($39,500) and a maximum ($65,750) value. I would like to divide that range into four equal parts, where each quartile would have its own minimum and maximum value. The challenge I have is that I am basing my minimum and maximum value off of a midpoint ($52,600). The max of Q2 and the min of Q3 should be near the midpoint (if that makes sense).

Is there a way of doing this? Where I can maintain the midpoint value?

 

[Rick Rothstein]

I have a range of salary where I have a minimum ($39,500) and a maximum ($65,750) value. I would like to divide that range into four equal parts, where each quartile would have its own minimum and maximum value. The challenge I have is that I am basing my minimum and maximum value off of a midpoint ($52,600). The max of Q2 and the min of Q3 should be near the midpoint (if that makes sense).

Is there a way of doing this? Where I can maintain the midpoint value?

I am not sure exactly what you mean by "midpoint"... you say the midpoint for the range is $52,600 whereas it is actually $52,625. Is there some adjustment you need for the difference or was your number just a guess?

Also, I am not sure what kind of output you want. Do you have numbers in cells and want the quartile those values fall in displayed in the cell next to them? Perhaps if you posted a sample of some numbers and the output you want from them, you desired result would be clearer to us.

Is a VBA solution acceptable or is this a formula only request?

 

[jproffer]

You mean like this?:

Excel 2013/2016
	A	B	C	D	E	F
1	39500	65750	39500-46062.5	46062.5-52625	52625-59187.5	59187.5-65750
Sheet1

Cell Formulas
Range	Formula
C1	=A1&"-"&((B1-A1)/4)+A1
D1	=(((B1-A1)/4)+A1) & "-" & AVERAGE(A1,B1)
E1	=AVERAGE(A1,B1) & "-" & (B1-(B1-A1)/4)
F1	=(B1-(B1-A1)/4) & "-" & B1

If I understood what you wanted, max of Q2 and min of Q3 wouldn't be "near" the midpoint, it would be exactly the midpoint.

 

[HuckFinn]

Thanks for the replies. This has helped me rethink how I am approaching this.