HOW TO
FIND MAXIMUM AND MINIMUM OF DATA [SCORES] IN EXCEL
Procedures and concepts to
consider:
- Have a data into cells [that among them, we can identify maximum and minimum data] Example 30,92,14 then Maximum data is 92 and Minimum data is 14.
- Identify the column name and row name
Example
Columns
[B, C and D]
and Row
[2]
…....... Horizontal identification
OR
Column
[B]
and Rows
[2,3,4 and 5]
…........ Vertical identification
- Identify the range of data into cells [that among them, we can identify maximum and minimum data]
Example B2 to
D2 (B2:D2)
and B2 to B6 (B2:B6)
- Syntax: '' = MAX(B2:D2) '' …........[In horizontal]
- Syntax: '' = MIN(B2:D2) '' …........[In horizontal]
- Syntax: '' = MAX(B2:B6) '' …........[In vertical]
- Syntax: '' = MIN(B2:B6) '' …........[In vertical]
NOTE:
In writing formula, use semi-colon [;] if you use OpenOffice
otherwise use comma only [,] if you use Microsoft office
OTHER EXCEL FUNCTIONS [SYNTANX]
No comments:
Post a Comment