# MIN Function. Get the smallest number.(Microsoft Excel)

03/27/2024

Japanese version.

The MIN function obtains the smallest value of a given number.

## How it works

=MIN(number1 to 255)

## Demonstrate

Basic usage example.

If the specified value contains spaces, text, or boolean values, the minimum value is obtained, ignoring them.

If an error is included, the MIN function will also result in an error.

When used with XLOOKUP (VLOOKUP) functions, etc., formulas must be created with this in mind.

### Specify other than cell range.

It is also possible to return a range of cells as the result of a function argument. In this case, the minimum value is taken from the result of the function.

List of functions that result in a range of cells.

It can also be specified as an array.

=MIN({10,1,2,-5})

Multiple values can also be specified simply by separating them with commas.

=MIN(10,1,2,-5)

### Spill

Spill when using the BYROW or BYCOL function.

=BYROW(A1:C3,LAMBDA(r,MIN(r)))
=BYCOL(A1:C3,LAMBDA(c,MIN(c)))

---