Microsoft Excel Basic Syntax:

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


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

PART 1:


PART 2:

MIN() Syntax

Download: PDF Notes Excel File

Returns the smallest value in a set of values

Syntax:

    =MIN(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

=MIN(21,34,13,54,23)

Output: 13


Example 2:

thumb

=MIN(A1:D1)

Output: 12