This article describes the formula syntax and usage of the function MIN in Microsoft Excel.

Description

Returns the smallest value in the argument list.

Syntax

MIN (number1; [number2]; ...)

The MIN function arguments are described below.

Number1, number2, ... Number1 is required, subsequent numbers are optional. From 1 to 255 numbers, among which you want to find the smallest.

Remarks

Arguments can be either numbers or numbers containing names, arrays, or references.

Boolean values ​​and textual representations of numbers that are directly entered in the argument list are considered.

If the arguments do not contain numbers, MIN returns 0.

Arguments that are error values ​​or text that cannot be converted to numbers result in errors.

Example

Copy the sample data from the following table and paste it into cell A1 of a new Excel worksheet. To display the results of formulas, select them and press F2, and then press Enter. Change the width of the columns as needed to see all the data.

Function MIN in Excel it is used to get the minimum value from a given range of cells.

What the function returns

Returns the smallest value in a data range.

Syntax

= MIN (number1,, ...)- English version

= MIN (number1; [number2]; ...)- Russian version

Function arguments

• number1 (number1)- the first number of the data range from which we need to get the minimum value;
• ,… ([Number2])- (optional) the second number of the data range from which we need to get the minimum value. A total of 255 numeric values ​​can be specified as arguments to the function.

Additional Information

• Blank cells, Boolean expressions, text, or links are ignored;
• If the arguments contain cells with an error or text that cannot be converted to a numeric value, the function will generate an error;
• Function arguments can also be names, arrays or references that contain numeric values;
• Boolean values ​​and text values ​​of numbers that you enter directly into the argument list are taken into account;
• If the argument is an array or a reference, then the function only considers numbers. Blank cells, booleans, or text in an array or reference are ignored;
• If no numeric values ​​are specified in the function arguments, the function will return the value “0” (zero).

Initial data
The source data can be any numeric dataset, such as a horizontal or vertical range, a two-dimensional array, or even non-contiguous ranges, or individually populated cells. For convenience, I took a one-dimensional vertical array A1: A5

To solve this problem, you can use either an additional column with an intermediate formula, or one array formula

1. Solution with an additional column
In B1 write the formula

IF (A1<>0; A1; "")

and copy it to the range B2: B5. This intermediate formula in the additional column will "remove" zeros from the original data, replacing them with an empty string. ""

In C1, write the formula

It will return the desired result - the number 3

IF (A1<>0; A1; "")

you need to use the formula

IF (A1> 0; A1; "")

2. Solution by array formula
To solve this problem, use the following array formula:

MIN (IF (A1: A5<>0; A1: A5))

How it works: This is the part of the formula A1: A5<>0 forms an array (TRUE: TRUE: FALSE: FALSE: TRUE), after which, using the IF () function, we transform the array into the following: (5: 7: FALSE: FALSE: 3)... Since the function MIN () ignores text and logical values, then in the end we get the desired number 3

If there are negative numbers in the range, then instead of the formula

MIN (IF (A1: A5<>0; A1: A5))

you need to use the formula

MIN (IF (A1: A5> 0; A1: A5))

3. Solution by a simple formula
Use this formula:

SMALL (A1: A5; COUNTIF (A1: A5; 0) +1)

How it works: Using the function COUNTIF we count the number of zeros in the range and adding one to this number we return the first smallest number greater than zero using the function LEAST

If there are negative numbers in the range, then instead of the formula

593. Which of the shown devices does not belong to the internal devices of the computer?

1
2
3
4

594. Which of the depicted devices refers to long-term information storage devices?

1
2
3
4

595. Which of the shown devices does not belong to the peripheral devices of the computer?

1
2
3
4

596. Which of the shown devices does not belong to the peripheral devices of the computer?

1
2
3
4

597. Which of the devices shown refers to the peripheral devices of the computer and is intended for copying, scanning, printing documents, receiving and sending faxes?

1
2
3
4

598. Which of the ports shown will allow you to connect a USB flash drive?

1
2
3
4

599. Which of the ports shown will not allow outputting images to external peripheral sources (monitor, TV, projector)?

1
2
3
4

600. Which of the ports shown will allow you to connect an Ethernet cable to access the local area network and the Internet?

1
2
3
4

601. How to call such a menu?

Right-click on the "Desktop"
Left-click on the "Desktop"
The shortcut keys "Ctrl + Alt + Del"
With the "Windows" key

602. How large is the storage medium (disk, memory card, flash drive) that can be used for a file of this size?

700 bytes
70 Mb
70 Kb
700 Kb

603. Which application allows you to open files marked with the following icon?

Graphic editor Paint
Word text editor


Explorer browser

604. Which application allows you to open files marked with the following icon?

Graphic editor Paint
Word text editor
PowerPoint presentation software
Excel spreadsheet program
Explorer browser

605. One of the programs is stuck (not responding). How do I invoke the task manager (shown below) to execute the "kill task" command?

The shortcut keys "Ctrl + Alt + Del"
The shortcut keys "Ctrl + Shift"
The shortcut keys "Ctrl + Alt + Shift"
The shortcut keys "Ctrl + X"

606. The window shown below is active. You want to select all files in this window. What keyboard shortcut can you do this?

Ctrl + A
Ctrl + V
Ctrl + Alt
Ctrl + Shift

607. You have inserted a removable disk into the USB port. What icon do I need to click on to see it?

1
2
3
4

608. What happens if you press the "Type" button?

Files of the same type will be grouped together
The type of selected files will change.
The File Type column will be removed
A new column is added to the right of the File Type column

609. What should be entered in the specified field in order to find all MS Word files (doc, docx) in the General folder?

* .doc *
doc, docx
MS WORD
* .doc / docx

610. MS Word application is not responding. You have called the task manager and selected this application in it. What button do you need to press now to force close the application?

1
2
3
4

611. To restore an accidentally deleted file Ivanov.rar, you have opened the "Trash". What button should I press to start recovering the file?

1
2
3
4

612. What button must be pressed if you need to convert the selected text into two columns?

1
2
3
4

613. Which tab to open to find out the number of characters, paragraphs and lines in the document?

1
2
3
4

614. What button should be pressed to display non-printable service characters (paragraph, tabulation, space, etc.)?

1
2
3
4

615. What button can be used to convert the selected text to capital letters?

1
2
3
4

616. What happens if you click the specified button "Quick Print"?

The current page will print.
The entire document will be printed in one copy
This will switch to the "Preview" mode.
A dialog box with printer settings appears.

617. What command should you use to create a copy of a document under a different name?

1
2
3
4

618. What command will you choose to quickly bring the bottom paragraph to the same format as the top one?

1
2
3
4

619. Which tab should you go to in order to change the fields of the edited document?

1
2
3
4

620. What button was pressed to get this text?

1
2
3
4

621. Which tab should I go to to put down the page numbering in the document?

1
2
3
4

622. The text contains a link to an external source. What should I do to navigate through it?

Left-click on a link
Press the CTRL key and left-click on the link
Press the CTRL key and right-click on the link
Press SHIFT and right-click on the link
Press the SHIFT key and left-click on the link

623. What happens if you click on the indicated button?

A blank page will be created in this document
It will switch to the "Preview" mode
A new Word document will be created
The current page will be printed.

624. Which tab should I go to to change the author of the document, title and keywords?

1
2
3
4

625. You want the bottom paragraph to look like the top one. Which button should you press?

1
2
3
4

626. In which part of the screen should I double-click the left mouse button to enter a header and footer?

1
2
3
4

627. How to select a range of cells marked in yellow on a sheet?

Select the range of cells E2: E8, then hold down the ALT key and select the range H2: H8
Select the range of cells E2: E8, then hold down the CTRL key and select the range H2: H8
Select the range of cells E2: E8, then hold down the SHIFT key and select the range H2: H8
Use conditional formatting

628. You decided to calculate the number of persons who filled public positions and public civil service positions in the executive and legislative bodies in 2013. Which of the options solves this problem?

= SUM (H4: H8)
= SUM (H4: H5)
= SUM (B4: B5)
= SUM ($ 4: $ 5)

629. You want to insert a new sheet into the book demo14 in one click, which button should you click on?

1
2
3
4

630. Do you want to select the entire "age group" sheet, which button should you click on?

1
2
3
4

631. You want to select a range of columns B: H for this you need:

Ctrl-click the column heading B (area 1) and then click the column heading H (area 2)
Click on the heading of column B (area 1), press and hold the Ctrl key and click on the heading of column H (area 2)
Click on the heading of column B (area 1), hold down the Shift key and click on the heading of column H (area 2)
Shift-click on the column heading B (area 1) then click on the column heading H (area 2)

632. You want to select unrelated lines 10 and 20 for this you need:

Click on the heading for row 10 (area 1) and then click on the heading for row 20 (area 2)
Click on the title of row 10 (area 1), press and hold the Ctrl key and click on the title of line 20 (area 2)
Click on the title of row 10 (area 1), hold down the Shift key and click on the title of row 20 (area 2)
Shift-click the heading for row 10 (area 1) and then click the heading for row 20 (area 2)

633. In cell C9, you need to get the value of the share of the population from 0 to 4 years (the value is in cell B9) in the total population (the value is in cell B7):

Click cell C9, then press the "=" sign on the keyboard, enter the formula B9: B7 and press Enter
Click cell C9 then press the "=" sign on the keyboard, enter the formula B9 / B7 and press the Enter key
Click cell C9 then enter the formula B9 / B7, press the "=" sign on the keyboard and press Enter
Click cell C9 then enter the formula B9: B7, press the "=" sign on the keyboard and press Enter

634. In cell C9, you need to get the value of the specific weight of the population from 0 to 4 years (the value is in cell B9) in the total population (the value is in cell B7) for further auto-copying of the formula for the range of cells C10: C20:

Click cell C9, then press the "=" sign on the keyboard, enter the formula B7 / $ B $ 9 and press the Enter key
Click cell C9, then enter the formula B9 / $ B $ 7, press the "=" sign on the keyboard and press the Enter key
Click cell C9, then press the "=" sign on the keyboard, enter the formula B9 / $ B $ 7 and press Enter
Click cell C9, then enter the formula B7 / $ B $ 9, press the "=" sign on the keyboard and press Enter

635. In cell I7, you need to get the average value of the range of cells B7: H7:

Click cell I7, then go to tab 1, use the Average command and press Enter
Click cell I7, then go to tab 2, use the Average command and press Enter
Click cell I7, then go to tab 3, use the Average command and press Enter
Click cell I7, then go to tab 4, use the Average command and press Enter

636. It is necessary to line the values ​​of the range of cells H7: H21 in descending order:

Click button 1
Click cell H6 and then click button1
Click cell H6 and then go to tab 2
Go to tab 3

637. It is necessary to format the range of cells J8-J22 as in cell J7:

Click cell J7 then click Button 1 and select a range of cells J8: J22 with the appropriate cursor
Click on the column heading J (button 2) then go to tab 4 and use the Format with example command
Select the range of cells J8: J22 then go to tab 3 and use the command Format by example
Click cell J7 then go to tab 4 and select the range of cells J8: J22 with the appropriate cursor

638. In the diagram shown below, you decided to change the scale of the vertical axis for greater clarity, setting the maximum value 5. On which menu item do you need to go?

1
2
3
4

639. You want the "Summary Data" label in the left table to be centered in the selection, as in the right table. Which button should I press?

1
2
3
4

640. You want the Summary Data label in the right table to appear as it does in the left table. Which button should I press?

1
2
3
4

641. What value will appear in the highlighted cell if the function = MIN (H4: H8) is entered there?

624035
12427
136165
11479

642. You want the number on the right cell to appear the same as the number on the left. Which menu item should you choose?

1
2
3
4

643. You want the highlighted cell C19 to be the difference of cells A19 - B19. Where do you start entering a formula?

With space
With the minus sign
With an equal sign
From cell name

644. If you stretch the selected area with the numbers 1, 2, 3 by the lower right corner while holding the left mouse button, the result will be as in the fragment:

1
2
3
4

645. What tool was used to obtain a picture, as in cells A24: A28?

1
2
3
4

646. Which tab should you go to to add slides to the presentation?

1
2
3
4

647. To change the design of the "Header and Object" layout, you need to go to the bookmark?

1
2
3
4

648. What button should be pressed to convert the selected text of Fragment 1 into a bulleted list, as in Fragment 2?

1
2
3
4

649. What button should be pressed in order to transform the selected text of Fragment 1 into the same form as in Fragment 2?

1
2
3
4

650. What button should you press to make the word "Cell" in the upper table look like in the lower one?

1
2
3
4

651. How do I switch to slideshow mode?

1
2
3
4

652. What does the indicated icon next to the slide number mean?

Slide included in custom display
Slide will be skipped when showing presentation
The slide uses animation effects
Slide contains video files

653. Which menu item should you choose to get the result, as in the picture on the right?

1
2
3
4

654. What shortcut must be used to launch the browser to view WEB-pages?

1
2
3
4

655. You should immediately go directly to the website www.kremlin.ru. In which field should you enter the address you are looking for?

1
2
3
4

656. Which tab should you go to in order to print the text from the site?

1
2
3
4

657. Which tab should you go to to change the encoding?

1
2
3
4

658. Without closing the tabs of the kremlin.ru site, you want to go to the gov.ru portal by opening it in a new tab. Which option should you take?

1
2
3
4

659. What happens if you click on the specified button in Internet Explorer?

Safe browsing mode will turn on
A new tab will open
The viewed page will be added to "Favorites"
Animation effects will turn on on the page

660. What happens if you click on the indicated icon?

Stop loading a page
Close Internet Explorer Browser
Go to the previous page
Refreshing the page

661. You have received an e-mail with several addressees in the copy. If you press the "Reply" button, which addresses will appear in the "To" field of your letter?

Igor Zhuravlev
Igor Zhuravlev, Andrey Kurosh, Alexey Chumachenko, Polina Vafina
Igor Zhuravlev, Polina Vafina

662. You have received an e-mail with several addressees in the copy. What happens if you click the Reply All button?

A letter will be created, where the address from which you received the original letter will be indicated in the "To" field
A letter will be created, where all recipients listed in the original letter will be indicated in the "To" and "Cc" fields, respectively.
A letter will be created with an empty "To" field
A letter will be created, where the recipients listed in the original letter will be indicated in the "Cc" field

663. You received a letter from a certain address. There are several more addresses in the "Cc" field. You want to reply only to the person from whose address the letter came. Which button should you press?

To answer
Reply All
Create message
Forward

664. What is the "Follow Up" button used for?

To set a calendar reminder
To prepare a response on behalf of the manager
So that the letter is always marked as unread
To forward a letter to a subordinate

665. The definition of what concept is given below?

Information posted on the Internet in the form of systematized data, organized in a format that ensures its automatic processing without prior human modification, for the purpose of repeated, free and free use

Open data

Open data passport

666. The definition of which concept is given below:

A set of information about the set of open data necessary to establish the fact that the set of open data belongs to a particular thematic heading, its potential suitability for solving consumer problems, as well as establishing the location address, the method of loading and subsequent automatic processing of the set of open data

Open data
Open government data
Open data passport

667. In what format is the preparation of data for a set of open data for the purpose of their publication on the Open Data Portal of the Russian Federation not carried out?

XML format
DOC format
CSV format

668. Which icon will allow you to launch a software application for creating a set of open data in CSV format?

1
2
3
4

669. Which of the tables meets the requirements for publishing an open dataset?

Table 1

table 2

Table 1
table 2

670. Which of the tables meets the requirements for publishing an open dataset?

Table 1

table 2

Table 1
table 2

671. Which of the addresses will not allow you to go to search engines on the Internet?

www.yandex.ru
www.rostelecom.ru
www.ya.ru
www.google.com

672. Where is the open data of state bodies located?

on the official websites of state bodies on the Internet
on the official website of the President of the Russian Federation
in the federal state information system "Federal portal of civil service and management personnel"
on the Open Data Portal of the Russian Federation

673. What type of file is the source for its translation into CSV format?

Word
Excel
PowerPoint
Access

674. How many levels of openness do federal executive authorities have?

2
5
7
15

675. Which item should you click to view the amount of installed RAM in your computer?

1
2
3
4

676. What item must be clicked to change the keyboard language?

1
2
3
4

677. What keys are used to take a snapshot of the active window?

Tab + Insert
Alt + Print Screen
Ctrl + Insert
Shift + F5

678. Click the title bar of the window below?

1
2
3
4

679. What button should be pressed to increase the size of an open window?

1
2
3
4

680. How does the selected file relate to the selected folder?

The selected folder and the selected file are on the same level
The selected file is located in the selected folder
The selected file contains the selected folder
The selected file and the selected folder are in different locations

681. Which tab can be used to call the Properties command to determine the size of the selected folder?

1
2
3
4

682. Which tab can be used to change the view of the selected folder so that the contents of the folder looks like the picture below?

1
2
3
4

683. Which command on the Arrange menu allows you to determine the size of the selected folder?

1
2
3
4

684. Which button must be clicked to access the Shut Down command?

1
2
3
4

685. You want the text to be indented by the first line of each paragraph by 1.25 cm. Which button must you click to bring up the corresponding dialog box?

1
2
3
4

686. You want the line spacing of 2 paragraphs of text to be the same as the line spacing of 1 paragraph of text and be exactly 22 pt. Which button must be pressed to bring up the corresponding dialog box?

1
2
3
4

687. You want the line spacing of 2 paragraphs of text to be the same as the line spacing of 1 paragraph of text and be 22 pt. What sequence of actions in the dialog box will get this result?

Enter the value "12" in field 1, then enter the value "12" in field 2 and click on the OK button
Click on field 3 and select the command Exactly then in field 4 enter the value 22 and click OK
Enter the value "22" in field 1 and press the OK button

688. You want to arrange a table in your document. Which tab do you need to open for this?

1
2
3
4

689. You want to design a table with invisible borders in your document. Which button should you click to do this?

1
2
3
4

690. Which tab should you go to in order to enable the change tracking mode?

1
2
3
4

691. Which tab should you go to in order to create a note to the current part of the document

1
2
3
4

692. Which tab should you go to to complete the current page and go to the next?

1
2
3
4

693. You want to use an Auto Collected Table of Contents for the document you are creating. What tabs should I go to for this?

First go to tab 4 and bring up the Styles dialog box, mark up the text, and then on tab 1 click the Table of Contents button
First go to tab 4, bring up the Styles dialog box, mark up the text, and then on tab 2 click the Table of Contents button
Go to tab 1 and click the Table of Contents button
Go to Tab 2 and click the Table of Contents button

694. You want to change the page orientation from portrait to landscape. Which area must be double-clicked to bring up the corresponding dialog box?

1
2
3
4

695. Clicking on which button will place the selection in the clipboard without deleting it?

1
2
3
4

696. Can you place a picture in a document using a tab?

View
Service
Insert

697. Infection with computer viruses can occur during

Working with files
Work with peripheral devices
Web browsing

The MIN function is used to find the minimum number in the range to be examined and returns the corresponding number.

The MINA function is designed to find the minimum value in the investigated data range and return the corresponding result.

Examples of using the MIN and MINA functions in Excel

The Excel table contains data on the date of birth of office workers. Determine the minimum age for the employee.

Data table:

For calculations, we use the array formula (the correct result is only when pressing the combination Ctrl + Shift + Enter):

The only argument is the expression YEAR (TODAY ()) - YEAR (B3: B10), which returns an array of numeric values ​​equal to the difference between the current year and the year of birth of each employee. As a result of the calculations, we get:

The formula automatically calculated that the youngest employee was 27 years old.



How to calculate the sum of minimum non-negative values ​​in Excel

An Excel spreadsheet contains multiple columns of numeric data. Find the sum of the minimum non-negative values ​​contained in these columns. Additionally find the smallest number available in the table.

Source table:

To determine the minimum non-negative numbers, we use the array formula:

!}

The only argument is the IF function, which checks the data array for occurrences of positive numbers. If the condition is true, the MIN function takes an array containing only positive numbers as an argument. Similarly, we will find the minimum values ​​for the remaining columns. The resulting result (Ctrl + Shift + Enter):

Find the smallest number in the table using the formula:

The function arguments are the values ​​returned by each of the MIN functions for the specified data vector. Use as an array formula. Result (Ctrl + Shift + Enter):

Find multiple smallest values ​​under conditions in Excel

A certain company previously worked with a single product supplier. However, it has become known that some other suppliers are offering better prices. The Excel spreadsheet contains item codes and discounts offered by other suppliers. If there is no discount, the logical value is FALSE, if the number is positive, the product costs more. Find the biggest discount for the same products only at different prices from different suppliers.

Source table:

Calculation formula (array formula):

= 0; "No discount"; MINA (IF (A3: A15 = D1; B3: B15; ""))) "class =" formula "/>

Calculation algorithm:

1. The IF function tests the MINA condition (IF (A3: A15 = D1; B3: B15; ""))> = 0, where MINA returns the minimum discount value for the item whose code is specified in cell D1.
2. The MINA function takes logical values ​​into account. It is possible that there is no discount for any product (all values ​​are FALSE), and the result 0 (zero) will be returned. In this case, the text string "No discount" will be returned. A similar event will happen if all discounts are only positive numbers.
3. If the condition is not met, the maximum discount (largest negative value) for the specified item code will be returned.

Let's calculate the largest discounts for the rest of the products. As a result, we get (Ctrl + Shift + Enter):

Features of using the MIN and MINA functions in Excel

The MIN function has the following syntax:

MIN (number1; [number2] ...)

Description of arguments:

• number1 is a required argument characterizing the first number in the range in which you want to find the minimum value;
• [number2] ... - the second and subsequent optional arguments characterizing the second and subsequent numbers from the range under study.

The MINA function has the following syntax:

MINA (value1; [value2] ...)

Description of arguments:

• value1 is a required argument characterizing the first occurrence in the range in which you want to find the minimum value;
• [value2] ... are the second and subsequent optional arguments characterizing the second and subsequent occurrences of the data range under study.

Notes 1:

1. The difference in syntax emphasizes the semantic difference between the two functions: MIN works only with numeric values, MINA additionally takes into account the logical data type.
2. If only text strings that are not textual representations of numbers were passed as arguments to the MIN and MINA functions, the functions will return the value 0.
3. The MIN function, which takes a reference to a data range as an argument, ignores not only logical TRUE and FALSE, but also text strings and empty cells.
4. If MIN or MINA is a formula that returns an error, these functions will also return an error code. It is recommended to check the data using the IFERROR function.
5. The MIN and MINA functions do not have analogous logical functions, as is implemented, for example, in the COUNT (COUNTIF) function, therefore, data verification should be performed when MIN and MINA are executed, passing them logical functions (IF, ISLIOSHIBKA and others) as an argument.

Notes 2:

1. MINA returns 0 (zero) if the range referenced as an argument contains text values ​​or textual representations of numbers.
2. Both functions are used to find the minimum values ​​in the range of values ​​passed as an argument, but there are several differences between them:

• If one of the arguments to the MIN function is a Boolean value (TRUE or FALSE, which can be converted to numeric values ​​1 and 0, respectively), that value will be included in the calculation. For example, the function = MIN (100; TRUE; FALSE; 10) will return the value 0.
• If a reference to a range containing data of a Boolean type was passed as an argument to the MIN function, the latter will not be taken into account. For example, = MIN (A1: A4) will return 10 if the cell range A1: A4 contains the following data: 100, TRUE, FALSE, and 10, respectively.
• In order for the calculations to take into account also the data of the boolean type, use the MINA function. For example, writing = MINA (A1: A4) will return 0 (logical FALSE is equivalent to numeric 0) if cells A1: A4 contain data as in the previous paragraph.