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 different types of storage devices

Topic: Explain different types of storage devices in Computer systems Storage Devices Storage devices are used to store data and instructions permanently. Storage devices are also called secondary storage devices / backing storage devices / external storage devices or auxiliary storage devices. Examples of storage devices include Hard Disk, CD and DVD etc. Why Secondary Storage Devices are Used? Secondary storage devices are used because: Primary memory(RAM) is volatile and temporary. When computer is switched off, all data in ram is erased. Storage devices can store large amounts of data and instructions permanently whereas Primary memory has less capacity of storing data. Types Of Storage Devices There are three main types of storage devices:  Magnetic Tape   Magnetic Disk   Optical Disk   Flash Memory storage devices 1. Magnetic Tape Magnetic tape is the oldest storage device. It is made of plastic coated with m...
3 comments
Read more

What are Different Types of Computer

Computers can be divided into the following 3 types on the basis of their working mechanism: 1) Analog Computers 2) Digital Computers 3) Hybrid Computers 1. Analog Computers Analog computer is used to measure continuous values. It measures a physical property like voltage, pressure, speed, time and temperature. An analog computer takes input in analog form and gives output in analog form. Its output is usually displayed on a meter or scale. Analog computer has low memory and fewer functions. Analog computer is mainly used in the field of engineering and medicine. Examples include: Examples of Analog Computers include:  1. Thermometer 2. Speedometer 3. Analog clock 2. Digital Computers A digital computer works with digital data. Digital computer uses binary number system. Binary number system consists of only two digits 0 and 1. A digital computer represents data in digital signals. A 0 represents OFF and a 1 represents ON. Digital computer performs a...
3 comments
Read more

Types Of e-Commerce

Types/Categories/Modes of e-commerce. There are three main types of e-commerce as follows: 1) Business To Consumer (B2C) B2C ecommerce consists of selling goods and services to individual consumers. In this type, consumers or customers can visit the website and purchase goods online. The website will have a StoreFront. This storefront will show product details, pictures and a shopping cart. Shopping cart is used to collect items to purchase. Advantages of B2C e-commerce B2C e-commerce has the following advantages: * Shopping can be faster and more convenient. * Offerings and prices can change instantaneously. * Broadband telecommunications will enhance the buying experience. 2) Business To Business (B2B) B2B e-commerce takes place between two businesses. One business provides services to other business. Examples of B2B include: Online Advertisement, recruiting, sales, marketing, technical support and training. For eample, some companies provide online purchasing...
5 comments
Read more