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

Explain Main Difference Between System Software and Application Software

Topic: Explain Main Difference Between System Software and Application Software            Differentiate between system software and application software Before , explaining the main differences between application software and system software, let us know the definitions of Application software and System software with examples. What is System Software: System software is a set of programs to control all components of computer and to manage overall operations of computer system. Differences between System software and application software System software is used as a base to install and run all application software. Examples of system software include: Operating Systems, like Microsoft Windows, DOS, Unix and Linux Device Drivers like Device driver software of a Printer (found on CD normally provided with the printer) Utility Programs like AVAST anti virus, Disk Scanners and File Viewers etc. What is Applicat...
10 comments
Read more

Uses Of Computer in Medical Field

Today Computers are an essential part of an hospital . Doctors and administration staff uses computers to manage patient history and medicine stocks etc. Computers play a key role in the medical field .  Their uses include storing patient related data, housing knowledge bases, providing the logic and circuitry for medical equipment, scanning and imaging the body, and facilitating speedy communications. Computers can be used in medical field in the following ways: Uses of Computers in Medical Field Top Seven Uses of Computers in Medical Field    Hospital Administration These days, Computers are being used in hospitals extensively . We can computerize the accounting, payroll and stock system of the hospital. We can keep the record of different medicines.  Recording Medical History Of Patients Computer can be used to store the medical history of the patients . Medical history is very important for patients as well as doctors. Doctors may ...
Post a Comment
Read more

Advantages and Disadvantages of Mesh Topology

Topic: Advantages and Disadvantages of Mesh Topology Mesh Topology In a mesh topology, every device on the network is physically connected to every other device on the network. Therefore, data can be sent on several possible paths from source computer to destination computer. Mesh topology is more reliable with better performance. Mesh Network Topology is mostly used in wide area networks where reliability is important. Advantages of Mesh Network Topology 1. Since, there are many links to transfer data, Mesh topology gets rid of the traffic problem . Data may be transferred through different links. 2. If one link becomes unusable, it does not disturb the whole system . Other links can be used for communication. 3. Since each node has physical connection with other nodes, therefore, one node can transfer data to many nodes at the same time. Disadvantages of Mesh Network Topology 1. It is very expensive due to implementation of multiple links for each no...
Post a Comment
Read more