Help with a formula
Posted by Libby on February 08, 2002 10:54 AM
Please can you tell me how I would set up a formula for the follwing sum.
I want to do a "if formula" for a datasheet based on quartiles.
I want to return a value of 1 - 4 based this rule
if < then lower quartile return a value of 4
If > then lower but < then median return a value of 3
If > then median but < the upper return a value of 2
If > than Upper return a value of 1
I will carry this acrossmy whole data set
Looking forward to hearing from you
Thanks for help