Hello,

In Excel 2007, I have a range of positive and negative numbers:
Example: -5,-4,-3,-2,0,1,4,6,7....etc.
I want to select the maximum of the negative numbers i.e. "-2" in the above
example using a formula. How should I write the formula?

Please advise.