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

Explain Different Types of Data Processing and Advantages Disadvantages

Today we will discuss different types or levels of data processing in detail. Let us define Data processing first. DATA PROCESSING Data processing is the sequence of operations performed on data to convert it into useful information . These operations may be arithmetic, statistical or logical operations. We can arrange or classify data. We can send and receive data from one point to another. Explain different types of data processing TYPES OF DATA PROCESSING (OR) LEVELS OF DATA PROCESSING) There are three types of data processing . 1) Manual data processing 2) Mechanical data processing 3) Electronic data processing We may also use the term Levels of data processing. First level of data processing was manual data processing when there were no calculating devices (before the invention of calculators). Therefore all processing jobs were performed manually by hand with the help of pen , paper and mind. In second level of data processing, machines like calculat...
2 comments
Read more

Explain Different Types Of Computer Networks - LAN, MAN, WAN

Explain different types of computer networks:(LAN,WAN,MAN) Today, we will discuss the main types of computer networks on the basis of the maximum distance covered where they can be accessed and operate. The main types of computer networks are: LAN, WAN, MAN Explain different types of computer networks 1.    LAN - Local-Area Network 2.    WAN - Wide-Area Network 3.    MAN - Metropolitan-Area Network 1)LAN (Local Area Network) What is LAN or Local Area Network LAN stands for Local Area Network . It covers a small area. Most LANs are used to connect computers in a single building or group of near buildings. A network contained within a relatively small area, such as a classroom, school, or single building, is commonly referred to as a local area network. Hundreds or thousands of computers may be connected through LAN . LANs are used in office buildings, college or university campus etc. Local Area Networks can t...
Post a Comment
Read more