• 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

    Hui...

  • 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]

Qiqi

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?
 

keymaster

New Member
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...
 
Top