I hope you do enjoy this free blog. I only ask one thing from you in return, click in one of the ads

Wednesday 21 January 2015

MAX function

Category: Statistical functions


What does this function do?


Returns the maximum value in a list of values. Ignores logical values and text.



Syntax:


MAX(number1,number2,...)
  • number1 (required): The first of the values or ranges to evaluate.
  • number2 (optional): From the second number or range parameters are optional.

Examples:


=MAX(1, 2, 3) = 3
=MAX(A1:A2,B1:B2) = 3, if A1:A2= {1,2} and B1:B2= {2,3}

No comments:

Post a Comment