Skip to main content

Learn Practical Use of MAX Function and MIN Function in Excel Worksheets

What is MAX Function?

Learn Practical Use of MAX Function and MIN Function in Excel Worksheets
Learn Practical Use of MAX Function and MIN Function in Excel Worksheets
The MAX function is used to get the maximum number from different given numbers in Excel Worksheet.

Syntax of MAX Function in Excel

MAX(number1,number2,number3,...numberN)
For example the function MAX(5,100,35) will return 100, since 100 is largest number of all 5, 100 and 35.

Syntax of MAX Function using Cell References

MAX(CellRef1:CellRef2)
Where CellRef1 is the cell reference of the first cell and CellRef2 is the cell reference of the last cell in the given cell range in Excel Worksheet.

What is MIN Function?

use of Min Function Microsoft Excel Formulas and Functions
The MIN function is used to get the minimum number from different given numbers in Excel Worksheet.

Syntax of MIN Function in Excel

MIN(number1,number2,number3,...numberN)
For example the function MIN(5,100,35) will return 5, since 5 is the smallest number of all 5, 100 and 35.

Syntax of MIN Function using Cell References

MIN(CellRef1:CellRef2)
Where CellRef1 is the cell reference of the first cell and CellRef2 is the cell reference of the last cell in the given cell range in Excel Worksheet.

 How To Implement MAX Function in Excel

 First of all place the cursor in an empty cell to enter the function.
  • Type =
  • Type the function name MAX
  • Type the left parenthesis (
  • Select the cell range A2 to E2 with the help of mouse so that the arguments A2:E2 will be automatically entered in the MAX function. 
  • Note: that you may type A2:E2 by keyboard also.
  • Press Enter key (You need not to enter right parenthesis, it will be automatically included)
  • The result 50 will be displayed in the cell.

How To Implement MIN Function in Excel

 First of all place the cursor in an empty cell to enter the function.
  • Type =
  • Type the function name MIN
  • Type the left parenthesis (
  • Select the cell range A2 to E2 with the help of mouse so that the arguments A2:E2 will be automatically entered in the MIN function. 
  • Note: that you may type A2:E2 by keyboard also.
  • Press Enter key (You need not to enter right parenthesis, it will be automatically included)
  • The result 5 will be displayed in the cell.

Example Worksheet Picture For MAX and MIN Functions

Practical Use of Max Function and MIN Min Function in Excel Worksheet
Practical Use of Max Function and MIN Min Function in Excel Worksheet
Labels:

Comments

Post a Comment

Popular posts from this blog

How Functions are Used in Excel Fast and Easy Way 3

What is a Function in Microsoft Excel? Microsoft Excel provides a large number of Functions for processing data in Excel Worksheets easily. Functions are predefined formulas in Excel. These functions are used in different types of calculations on numerical or other data  quickly. How a Function is Used in Microsoft Excel? There are three popular ways to use built-in functions in Microsoft Excel. 1. Type Functions Manually 2. Use Function Library Commands 3. Use Insert Function Dialogue Box Other Microsoft Excel Topics on www.ComputerGap.com  Microsoft Excel Formulas and Functions Fast and Easy Way -1 Using Simple Formulas in Excel With Arithmetic Operators 2 How Functions are Used in Excel Fast and Easy Way 3 Create Bar Chart in Excel Easily by Example Employee Pay sheet Formulas in Microsoft Excel  Students Test Score Grades Result Sheet in Excel Electricity Bill Calculator Formulas in Excel    Microsoft Office Word Pro...
Post a Comment
Read more

Attributes of Table Tag

Border: It is used to specify a border and its thickness for a table. Cellspacing: It is used to specify the distance between adjacent cells in a table. Cellpadding : it is used to specify the distance between a cell and cell contents in a table. Width : It is used to specify width of a table in pixels or as percentage to screen width. Align : It is used to specify the horizontal alignment of a table. Possible horizontal alignment values are "left", "right" or "center". Valign : It is used to set the vertical alignment of a table as "top", "bottom" or "middle". Bgcolor : It sets the background color of a table. You can specify color names or hex values for the color. Example of table with border=1, width=200 and align=center attributes HTML Coding: <table border="1" width="200" align="center"> <tr> <th>Book</th><th>Price($)</th> </tr> ...
Post a Comment
Read more

Explain Different Features of Microsoft Excel

Microsoft Excel is a spreadsheet software developed by Microsoft Corporation of USA. Microsoft Excel is used to input and format data and to apply suitable mathematical and other formulas on the data. Excel can perform large number of calculations on data easily in a table like format. The main file of Microsoft Excel is called an Excel Workbook. By default, each workbook has three Excel Worksheets . A Worksheet is divided into Rows, Columns and cells. Microsoft Excel provides many easy to use features as follows: Important Features Provided by MS Excel different features of Microsoft Excel application software 1.    Auto Fill MS Excel provides easy series generating feature called Auto Fill. With the help of Auto Fill you can fill the adjacent cell range with a series like days of a weak or a number series like 1,2,3,4,...10 or 5,10,15,...50 or 1990, 1991, 1992... or dates etc. 2.    Header and Footers Header and footer feature is u...
Post a Comment
Read more