On Tue, 15 Mar 2005 01:01:02 -0800, "tika528"
wrote:
I would like to use a formula to return which quartile the given data array
falls into- that is I would like to return 0,1,2,3,4. 0= min, 1=25%, 2=50%,
etc.
The quartile function only returns the value of the various quartiles, while
I need to know within which quartile the value falls.
Any help is appreciated.
Perhaps:
=FLOOR(A1,0.25)*4
will do what you describe?
--ron
|