KEMBAR78
Excel MIN/MAX Functions Guide | PDF | Western Cuisine | Regional & Ethnic Food
Scribd
Upload
64 views3 pages

Excel MIN/MAX Functions Guide

The document discusses the MIN and MAX functions in Excel. It explains that the MIN function returns the smallest value in a range of cells, while the MAX function returns the largest value. It provides examples of using the MIN and MAX functions to find the minimum fruit or item amount, and maximum meat or item amount. Additional information on the functions is available online.

Uploaded by

anil basnet
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
64 views3 pages

Excel MIN/MAX Functions Guide

The document discusses the MIN and MAX functions in Excel. It explains that the MIN function returns the smallest value in a range of cells, while the MAX function returns the largest value. It provides examples of using the MIN and MAX functions to find the minimum fruit or item amount, and maximum meat or item amount. Additional information on the functions is available online.

Uploaded by

anil basnet
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 3

MIN and MAX functions

MIN and MAX functions


Use the MIN function to get the minumum number in a range of cells.
Use thecell
Select MAX Use
D7, the to get the maximum number in a range of cells.
function
use theUse
then select
Now cell the
G7,cell
In and enter
D15, youa
can
More use either 1
information on
All aobut the MIN function
2 function
All about the MAX
Free Excel
GOOD TO training online

3
KNOW

More information on the web


You can use either MIN or MAX with multiple ranges, or values to show the greater or lesser of those values, like =MIN(A1:A10,B1:B10), or =M

More information on the web


All about the MIN function
All about the MAX function
Use Excel as your calculator
Free Excel training online
MIN and MAX functions
Fruit
Use the MIN function to get the smallest number in a range of cells. Apples
Use the MAX function to get the largest number in a range of cells. Oranges
Bananas
1 Select cell D7, then use the AutoSum Wizard to add a MIN function. Lemons
MIN >

2 Now select cell G7, and enter a MAX function by typing =MAX(D3:D6).
Item
Bread
Donuts
3 In cell D15, you can use either the AutoSum Wizard, or type to enter a MIN or
Cookies
MAX function.
Cakes
Pies
MIN or MAX >

More information on the web


can use either MIN or MAX with multiple ranges, or values to show the greater or lesser of those values, like =MIN(A1:A10,B1:B10), or =MAX(A1:A10,10).

All about the MIN function

All about the MAX function

Free Excel training online


Fruit Amount Meat Amount
Apples 50 Beef 50
Oranges 20 Chicken 30
Bananas 60 Pork 10
Lemons 40 Fish 50
MIN > MAX >

Item Amount Item Amount


Bread 50 Bread 50
Donuts 100 Donuts 100
Cookies 40 Cookies 40
Cakes 50 Cakes 50
Pies 20 Pies 20
MIN or MAX > 10

GOOD TO KNOW
You can use either MIN or MAX with multiple
(A1:A10,B1:B10), or =MAX(A1:A10,10).
ranges, or values to show the greater or lesser of
those values, like =MIN(A1:A10,B1:B10), or
=MAX(A1:A10,B1), where B1 contains a threshold
value, like 10, in which case the formula would
never return a result less than 10.

You might also like