On Tue, 16 Sep 2014 23:35:31 -0000, Lonnie Vann <[email protected]> wrote:
I have a column, in this case, I want the MAX function to choose the largest. I click the MAX function, then in the "First Number" choice, I enter B5. In the "Second Number" choice, I enter B31. I have numbers in B5 through B11 and it chooses B5, even though each successive number in the column is larger than the previous.
you should enter 'b5:b31' into the 'first number' box. indeed, the boxes' names are a bit misleading; they would better be 'first range', 'second range' etc... when you enter 'b5' to the first box and 'b31' to the second one, the program searches for the maximal value among these two cells, not within the whole b5:b31 range. by the way, microsoft excel's max function behaves the same way. sorry for the late reply. --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
