• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

How do you determine the upper limit of a range [SOLVED]


New Member
How do you determine the upper or lower limit of a range, for eg. if the range is from 10,000- 20,000, what would be the upper limit?
Max and Min ofcourse. here is the help: http://chandoo.org/excel-formulas/max.html and http://chandoo.org/excel-formulas/min.html

You can even try the percentile to find 5th and 95th percentile if you are in to that sort of thing...