Applies ToSharePoint Server 訂閱版本 SharePoint Server 2019 SharePoint Server 2016 SharePoint Server 2013 SharePoint Server 2013 企業版 Microsoft 365 中的 SharePoint SharePoint Foundation 2010 SharePoint Server 2010 Microsoft 365 小型企業版中的 SharePoint Windows SharePoint Services 3.0

Returns the smallest number in a set of values.

Syntax

MIN(number1,number2,...)

Number1, number2,...     are 1 to 30 numbers for which you want to find the minimum value.

Remarks

  • You can specify arguments that are numbers, empty, logical values, or text representations of numbers. Arguments that are error values or text that cannot be translated into numbers cause errors.

  • If an argument is a column reference, only numbers are used. If logical values and text should not be ignored, use MINA instead.

  • If the arguments contain no numbers, MIN returns 0.

Examples

Col1

Col2

Col3

Col4

Col5

Formula

Description (Result)

10

7

9

27

2

=MIN([Col1],[Col2],[Col3],[Col4],[Col5])

Smallest of the numbers (2)

10

7

9

27

2

=MIN([Col1],[Col2],[Col3],[Col4],[Col5],0)

Smallest of the numbers and 0 (0)

需要更多協助嗎?

想要其他選項嗎?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.