Microsoft Excel Basic Syntax:

INTRO BONUS CLASS SYNTAX EXPLAIN SUM AVERAGE MAX MIN IF SUMIF AVERAGEIF COUNT | COUNTA | COUNTBLANK COUNTIF Excel ShortCut Keys


Excel: MAX Syntax | Logically Excel Ko SEEKHEN In a Very Effective Way

PART 1:


PART 2:

MAX() Syntax

Download: PDF Notes Excel File

Returns the largest value in a set of values

Syntax:

    =MAX(number1,[number2],...)

Parameter:
• number1 - Number, reference to numeric value, or range that contains numeric value
• [number2],... - (Optional) A number or cell reference that refers to numeric values.


Example 1:

thumb

=MAX(32,12,42,55,67)

Output: 67


Example 2:

thumb

=MAX(A2:A5)

Output: 55